[Bug 433378] New: Oocalc CSV import doesn't treat quoted number as text
https://bugzilla.novell.com/show_bug.cgi?id=433378 Summary: Oocalc CSV import doesn't treat quoted number as text Product: openSUSE 11.0 Version: Final Platform: 64bit OS/Version: openSUSE 11.0 Status: NEW Severity: Normal Priority: P5 - None Component: OpenOffice.org AssignedTo: kyu@novell.com ReportedBy: sabelka@iue.tuwien.ac.at QAContact: qa@suse.de Found By: --- When I open a csv file (TAB-delimited, double quote as text delimiter), numbers which are inside double quotes are not interpreted as text but as numbers. E.g: If the .csv file contains "1." oocalc will interpret this as 1 (as number). When I save to the same .csv file again (without doing any modifications) the "1." in the original file will be replaced by 1 (without the trailing dot and without quotes). I would expect oocalc, when it reads an .csv file and encounters some quoted strings it should set the cell type to text and keep the string exactly as is was (BTW excel does it this way). -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=433378
Ken Yu
https://bugzilla.novell.com/show_bug.cgi?id=433378
User nopower@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433378#c1
Noel Power
https://bugzilla.novell.com/show_bug.cgi?id=433378
Noel Power
https://bugzilla.novell.com/show_bug.cgi?id=433378
User kyoshida@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433378#c2
Kohei Yoshida
https://bugzilla.novell.com/show_bug.cgi?id=433378
User kyoshida@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433378#c3
--- Comment #3 from Kohei Yoshida
https://bugzilla.novell.com/show_bug.cgi?id=433378
User kyoshida@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433378#c4
--- Comment #4 from Kohei Yoshida
https://bugzilla.novell.com/show_bug.cgi?id=433378
User kyoshida@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433378#c5
Kohei Yoshida
participants (1)
-
bugzilla_noreply@novell.com