Results for first 3 lines in the CSV file:
CSV LINES (sep: comma) |
column A |
column B |
column C |
|
|---|---|---|---|---|
| 2026-03-30, 6, 1.8 | 30/03/2026 (date) |
6 (number) |
1.8 | **(text ?!?)**← |
| 2026-03-30, 7, 3.967 | 30/03/2026 (date) |
7 (number) |
3.967 | (number) |
| 2026-03-30, 8, 0.445 | 30/03/2026 (date) |
8 (number) |
0.445 | **(text ?!?)**← |
The actual CSV contains 3,775 lines. Dates are correctly imported as dates and re-formatted from yyyy-mm-dd to dd/mm/yyyy as per my locale preferences in Spreadsheet Editor. Integers are correctly imported as numbers. However, after examining the entire file in search for some pattern, my conclusion is that non-integers are erroneously imported as text, unless -
- the represented value is greater than 1, AND
- the value includes three decimal positions.
I detected the flaw yesterday while using Desktop Editors v 9.2.1.43 for Linux so updated to the latest available 9.4.0.129 (x64 deb). I have thoroughly searched the community for coincident topics (found some CSV-related although different) but no luck. As I am a new community user I am not allowed to attach samples for a while, but I am ready to cooperate with anyone in a position to fix this, and of course will appreciate any suggestion to a workaround. Thanks!