https://bugs.documentfoundation.org/show_bug.cgi?id=166211
Bug ID: 166211
Summary: Calc any write to a csv file corrupts file 25.2.2.2
Product: LibreOffice
Version: 25.2.2.2 release
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I download a csv file generated by another program. I use an "R" language
program to read it (data_raw <- read.csv("000-mislocates.csv", header = TRUE,
stringsAsFactors = FALSE, na.strings = "N/A"). Program runs fine. Anything that
causes Calc to re-write that csv file causes it to scramble data. This is NEW
to 25.2.2.2. I downgraded to 24.8.6.2 and the problem disappeared. One of the
columns of my data contains a comma, ex "August 26, 2023" and I presume this is
the field which causes v.25 to wreck, but v.24 can handle just fine. The
sinister part is that FROM THE CALC SCREEN, you do not see any problems, the
table looks just fine. However, when you perform a "read.csv" from the "R"
program, the columns are scrambled, the parse/placement into variables based
upon column numbers doesn't interpret the columns correctly... seems to insert
"phantom columns" with invented bad data... AGAIN, this problem is NOT apparent
from the Calc screen presentation where everything looks fine. It seems pretty
obvious that the NEW version of Calc cannot deal with data containing a comma,
whereas the OLD version could.
Steps to Reproduce:
1.Download good .csv file generated by another program, which contains a data
field containing a comma ("June 11,2023", for example)
2.Perform any Calc operation which re-writes the file... such as "rename" or
"save", "save as"
3.
Actual Results:
Internal representation of the column fields is corrupted. Phantom columns are
added, filled with a consistent pattern of junk data.
Expected Results:
I would expect a 100% correct transfer of data and column formatting when
saving data. The copy should exactly replicate the original.
Reproducible: Always
User Profile Reset: No
Additional Info:
I have a sample data file which I will attach for your use.
NO. I did not reset my UserProfile as this problem is not related to that
process.
--
You are receiving this mail because:
You are the assignee for the bug.
