Bug 164897 - Calc fails to import csv
Summary: Calc fails to import csv
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.2.0.1 rc
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: CSV-Import
  Show dependency tree / graph
 
Reported: 2025-01-28 18:48 UTC by Andreas Säger
Modified: 2025-01-29 15:02 UTC (History)
1 user (show)

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 Andreas Säger 2025-01-28 18:48:34 UTC 
https://ask.libreoffice.org/t/how-do-i-format-a-column-of-calendar-dates-in-calc/55289/24

Unlike any previous version, LO 25.2.0.3 imports all the data as text.

01/01/2019 $177.40 -$6.86 $170.54
03/01/2019 $22.95 -$1.15 $21.80
19/01/2019 $30.00 -$1.41 $28.59

Import settings:
Locale: English(Australia)
Detect speicial numbers.
Comment 1 m_a_riosv 2025-01-28 21:36:18 UTC 
With Spanish(Mexico), works fine for me without modify any column.

Also works with English(USA), modifying the first column to D/M/Y

Version: 25.2.0.3 (X86_64) / LibreOffice Community
Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
Comment 2 Andreas Säger 2025-01-28 22:14:02 UTC 
I beg your pardon. I checked "scientific numbers" instead of "special numbers". Too many options too late in the evening.
Please mark invalid.
Comment 3 m_a_riosv 2025-01-28 22:52:25 UTC 
So, not a bug?
Comment 4 Andreas Säger 2025-01-29 14:42:48 UTC 
(In reply to m_a_riosv from comment #3)
> So, not a bug?

Not a bug.