https://bugs.freedesktop.org/show_bug.cgi?id=44944
Bug #: 44944 Summary: FILEOPEN: Importing csv file with data "-" imports as -0 Classification: Unclassified Product: LibreOffice Version: LibO 3.4.5 release Platform: Other OS/Version: All Status: UNCONFIRMED Status Whiteboard: BSA Severity: normal Priority: medium Component: Spreadsheet AssignedTo: libreoffice-bugs@lists.freedesktop.org ReportedBy: grof...@hotmail.com Created attachment 55794 --> https://bugs.freedesktop.org/attachment.cgi?id=55794 import text file Problem description: I have a csv document that is produced by database output. Database produces sign "-" (without double quotes) when there is no data for current field. When data are imported into Calc "-" characters is imported as "-0" (without double quote). I think it should be imported as text, but I can't mark whole column as Text, because other cells in column can contain numeric values. Steps to reproduce: 1. File | Open and select csv file (attachment text_file.csv). 2. Default fixed width and manually mark fields separations (attachment import_window.png) and click OK button to start importing. 3. File gets imported, but character "-" is imported as "-0". Current behavior: Fields with "-" get imported as "-0". Expected behavior: Fields with "-" should be imported as "-" and become text fields. Platform (if different from the browser): Windows XP sp3 -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- 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