CSV EXPORT : improvments
Various improvments :
As most of the users are using Windows it could be usefull not to use UTF8 (use ANSI?) as accents are not easyly managed with utf8,
comma should not be used as separator (confusion for text or future concat of elements). Maybe ";" instead ?,
Updated by Étienne Loks almost 13 years ago
And we should use no accentuated letters and write all fields with caps-lock? :)
Seriously: which prehistoric application is problematic? OOo manage UTF8 with no problems.
Not using UTF8 can be really painful in internationalization.
Comma for separator is not really an issue as quotation marks are used to managed strings with commas. But semi-colon are more common: it will be changed.
Updated by Yann Le Jeune almost 13 years ago
- % Done changed from 0 to 50
Yeah. It's a shame. :)
It works with Ooo but not by default.
The actual process is (here with winXp) :
the csv is generated and saved in the Download directory (not elsewhere, not open on_the_fly),
I open the Download directory, right clic (open with...), i choose Ooocalc,
I get a windows where i can choos the coding (long list, UTF8 is the last) and the separator (radio button),
Now I have my fancy table :)
Maybe the prehistoric application is WinXP...
For Internationalisation reason i understand. But for most XP users this will be painfull. Secretary are not used to caract coding.
One another simple solution is to provide the list in HTML (in a tab for example). That list (table) can be paste in OOocalc with correct accent or printed. BUT this is another feature. So We can keep that export at that step. :) Sure that peoples will talk to me about "accent problem" for a long time. :P