https://bugs.documentfoundation.org/show_bug.cgi?id=158073
Bug ID: 158073
Summary: Problem with reading csv-files: Dot not recognised
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 190658
--> https://bugs.documentfoundation.org/attachment.cgi?id=190658&action=edit
zip-file of images mentioned in my account.
I am using LO-Calc in the German version, that is, the decimal delimiter is
','.
I have data saved in CSV-Files to be processed by another program and there the
decimal delimiter is '.'. I still want to use Calc to manage my data, as
text-entries.
But Calc does not allways recognise the '.' and simply ignores it on occasion.
Then numeral entries are read as numerals and the data get corrupted if saved
again as csv file.
See images attached
(1) Screenshot of my data in Microsof editor
(2) Screenshot of the open prompt from calc: All the dots in place.
(3) Screenshot of spreadsheet
The frames show that on some occasions the data oj a whole column get
misrepresented - see data for Kiel marked in red box - and sometimes this
happens erratic without any systematic that I could recognise.
Would be great if you could fix this.
Best regards
Norbert
--
You are receiving this mail because:
You are the assignee for the bug.
