Open the exported file with Excel

[wos]

Many users reported problems with the exported file for Excel. They double-click the file and it will be opened by Wordpad. The layout is not very nice...

More experienced users will use the right click and choose "Open with..." ==> Excel. As this Excel function might have a bug, the result in Excel is also not convincing (usually Chinese characters are broken).

We cannot repair Excel, but it has another function which works properly: Menu "Tools" / "Import from external file...".

Suggested solution:

The addressbook gets a new export function called "Export for Excel". In fact, this "export" function is a HELP manual which describes the way how to import from external files correctly. The manual should also contain the place where this external file can be found on CD. The user will start Excel, go to Tools / Import... and selects this particular file from CD. If he likes he can save the result in proprietary / native Excel format. That's it.

[Zhang Weiwu (zhangweiwu)]

Okay, here is the images that represents the process of importing these data files back to Excel. Important is:
1) must select UTF-8
2) must select only TAB as separator;
3) must select "none" for text qualifier
4) please don't resize these screenshots in the final tutorial.

Thanks! Please write the tutorial and upload the HTML file for the tutorial with references to these images.

[Zhang Weiwu (zhangweiwu)]

Wolfgang wrote the manual, I should add it to the software. He sent me the manual by email for failing to upload it to launchpad.I upload for him.

[Zhang Weiwu (zhangweiwu)]

Wolfgang: I found I have to remove the "hspace", "vspace" and "style" attributes of all <img> elements in order to display them using the old html browser offered in tkwebview. Now I did the removal, and committed the code.