https://bugs.documentfoundation.org/show_bug.cgi?id=161211
Bug ID: 161211
Summary: spreadsheet data in exploded view
Product: LibreOffice
Version: 3.3.0 release
Hardware: Other
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Many CSV files I open in Libre Office errantly expand data across cells so that
columns of data do not line up. Sometimes it behaves as if spaces are
interpreted as commas. That is to say, if in a cell there is a string "my dog
has fleas", libre office places each word in its own column thus moving
following cells to the right and mis-aligning columns of data.
Steps to Reproduce:
1.open a csv created by another person, software unknown
2.
3.
Actual Results:
cell data split and spread to adjacent cells to the right of intended cell
Expected Results:
cell data stay in its cell
Reproducible: Sometimes
User Profile Reset: No
Additional Info:
Opening same file in Google Sheets, Mac Numbers, Microsoft Excel shows data in
appropriate cells. It appears files I create in Libre Office behave as intended
but other sources do not which include: WordPress data exports, CSVs sent from
other people.
This is on Mac Studio 2023 running Sonoma and Macbook Pro 2016 running
Monterrey
I don't know what hardware or version applies.
--
You are receiving this mail because:
You are the assignee for the bug.
