Bug 159056 - .csv import
Summary: .csv import
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.9.2 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-01-07 17:10 UTC by tkroessin
Modified: 2024-01-08 13:31 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description tkroessin 2024-01-07 17:10:51 UTC 
Description:
when I import a .csv file, calc deletes a . in a few numbers
e.g. 9.295 will be changed during import to 9295
the . is only deleted when the number has 4 digits

Actual Results:
9295

Expected Results:
9.295


Reproducible: Always


User Profile Reset: No

Additional Info:
9.295
Comment 1 Werner Tietz 2024-01-08 08:54:12 UTC 
Hallo
Guessing your locale is german? and the dot means thousand-seperator?
⇒Format the Cells to (Number)-Formatcode:

#.###,##

Bug solved?