calc csv limits for columns [closed]
there are columns to CA, but on opening I received a message saying I exceeded the maximum columns. It only imported to BU.
First time here? Check out the FAQ!
there are columns to CA, but on opening I received a message saying I exceeded the maximum columns. It only imported to BU.
Columns up to AMJ (i.e. 1024 columns) are available, but your CSV data may be malformed with embedded separators but unquoted field content, or you chose a wrong separator, for example ticked blank as well and field content text has blanks. Hard to tell without seeing the actual data.
That turned out to be the case. The data had non-displayed characters that was breaking the text quote pairs. After scrubbing the incoming text to remove any of these characters, it opened without error. Thanks
Asked: 2019-02-07 14:53:20 +0100
Seen: 61 times
Last updated: Feb 07 '19
Alternating table column numbering, Col1 Numbers, Col2 Letters? [closed]
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]