https://bugs.documentfoundation.org/show_bug.cgi?id=167609
Bug ID: 167609
Summary: Single cell in a spreadsheet linked to CSV replaces
comma with null
Product: LibreOffice
Version: 25.2.4.3 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: imwellcushtymelike+documentfoundat...@gmail.com
Description:
I have a spreadsheet that links to a number of CSV files which are generated
automatically.
In every case except for one cell the CSV is correctly detected as a CSV. Even
the same CSV in another cell appears to be detected correctly.
If I remove the link and recreate it, the CSV is correctly detected and the
relevant cell is inserted into my spreadsheet. If I save and re-open it,
however, the cell always reverts to the whole line from the CSV, comma
included.
There is nothing special about this CSV. It is in the same format and encoding
as all the others.
I had to pull apart my .ods to find the answer.
<table:table-source xlink:type="simple" xlink:href="/some/path/ThisWorks.csv"
table:table-name="ThisWorks" table:filter-name="Text - txt - csv (StarCalc)"
table:filter-options="44,34,76,1,,0,false,true,true,false,false,0,false,false,true"
table:mode="copy-results-only"/>
<table:table-source xlink:type="simple"
xlink:href="/some/path/ThisDoesNotWork.csv" table:table-name="ThisDoesNotWork"
table:filter-name="Text - txt - csv (StarCalc)"
table:filter-options="0,34,76,1,,0,false,true,true,false,false,0,false,false,true"
table:mode="copy-results-only"/>
The working cell, and all the working cells, have the first option set to 44
(comma), but for some reason Calc keeps setting the broken cell to 0 (null).
Null isn't even an option in the CSV importer dialog. I don't know where it got
this idea from.
I installed the latest pre-release, 25.8.0, to see if it was fixed but it
wasn't.
Manually editing the XML and sticking it all back together solved this for me
(I've kept a backup of the broken one).
Steps to Reproduce:
1. Link CSV
2. Save
3. Re-open
Actual Results:
The whole CSV is imported as... text?
Expected Results:
The CSV is treated as a CSV and the cells are parsed correctly.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 25.2.4.3 (X86_64) / LibreOffice Community
Build ID: 33e196637044ead23f5c3226cde09b47731f7e27
CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
