https://bugs.documentfoundation.org/show_bug.cgi?id=155848
Bug ID: 155848
Summary: CSV import improperly import floats as text prefixed
by a hidden apostrophe
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: mmokr...@fold.natur.cuni.cz
Hi,
the CSV import is terribly broken and Libreoffice Calc too on its own.
The fields containing float numbers get imported as '0.65 instead of just 0.65.
Because the leading apostrophe is NOT show in the table but ONLY on the EDITIng
line it took me ages to realize it. Instead I was just blindly to set the
Format -> Cells -> Numbers to some othe Category that current "Number". It did
not help because the leading apostrophe is in place. It should have been
REMOVED by this action.
Once somebody told me about the Data -> Text to columns I could FIX the table
importred via the broken import procedure but only column by colum (one cannot
select multiple columns or cells spanning more than one column). One can do:
Data -> Text to columsn -> Set the Other delimiter to the ' tick and click OK
Set the cell content to Number via Format -> Cells -> Numbers .
Then, you can use =SUM() or =AVG() functions over those cells to continue what
used to work in the past.
SUM() and AVG() function could be smart enough to act on text fields and try to
interpret the contents as numbers.
I do not see a point why during CSV import the contents should NOT be tried to
be set to Number whenever possible. Or the import procedure should ASK user or
provide a table for data format review upon import, emphasizing cells which are
currently defined as TEXT but could have been Number.
Either way, if sombody goes to Format -> Cells -> Numbers it should remove
those offending ticks or at least give an error message. It is a pity whole
column because typically on first line we have column descriptions which are
TEXT, right?
Ability to perform Data -> Text to columns trickery over multiple cells
spanning more than one comlumn would be very helpful.
Yes, the thousands separator ',' got interpreted regardles of my locale as a
decimal dot so 12,600 (twelve thousand 6 hundred) turned into 12,6. But that is
another story.
Thank youf for any efforts to fix these.
Version: 7.5.4.2 (X86_64) / LibreOffice Community
Build ID: 50(Build:2)
CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Gentoo official package
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
