https://bugs.freedesktop.org/show_bug.cgi?id=87266
jackvig...@yahoo.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|NOTABUG |---
Ever confirmed|0 |1
--- Comment #3 from jackvig...@yahoo.com ---
Thank you m.a.riosv,
unfortunately, it is not optimal if I have 16 columns to force to text, or if I
have many documents to open everyday. Also, there is a risk if a civil servant
opens the file with the default method (or even with a Visual Basic macro),
changes something not related (adds a new column... adds a new line, updates 1
figure...), then saves and exit : the zipcode (postal code) and other codes
(primary key) will be altered in the csv file.
I just tried (default saving prompted when user exit LibreOffice) and here is
the resulting .csv file :
pk,city,zipcode,name,population
1001,L ABERGEMENT CLEMENCIAT,1400,L'Abergement-Clémenciat,780
EOF,,,,
Thank you Urmas,
I tried with all those 3 samples and the standard method is not recognizing
code as char(text) but code as number (then truncating zeros on the left) :
pk;city;zipcode;name;
"01001";L ABERGEMENT CLEMENCIAT;"01400";L'Abergement-Clémenciat;
EOF
pk;city;zipcode;name;
''01001'';L ABERGEMENT CLEMENCIAT;''01400'';L'Abergement-Clémenciat;
EOF
pk;city;zipcode;name;
'01001;L ABERGEMENT CLEMENCIAT;'01400;L'Abergement-Clémenciat;
EOF
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
