https://bugs.documentfoundation.org/show_bug.cgi?id=125110
Bug ID: 125110
Summary: CalcSpreadsheet: issues converting .CSV wherre there
are more than 30K rows of data
Product: LibreOffice
Version: 6.1.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: ad...@okbarrydale.com
Description:
We have a need to convert a .CSV file with more than 13,000 rows of data to and
XLXS file.
The data is a mix of character and numerals with 9 columns - simple data
It is our product lines Master Stock List exported from our back office
inventory and sales system - the data contains product ID, descriptions, pack
sized, last sold dates etc.
What appears to happen at about 131K lines or so the data does not get unpacked
into columns/rows and comes through as a "stack" into one cell containing
thousands of lines of data.
However, if I convert the same file using MS Excel, and then open the XLS file
as created by MS EXCEL, then LibreOffice has no issues using and formatting the
data.
Now it may be that the source data has some special characters and MS Excel is
a liottle more forgiving ... I am not sure.
What I find
Steps to Reproduce:
1.Select given .CSV to import/convert - character set "Western Europe
windows-1252/winlatin1"
2.at data row 13137 conversion stops ... data not unpacked
3.
Actual Results:
Warning message: The data could not be loaded completely because the maximum
number of characters per cell was exceeded.
Expected Results:
Unpack all rows of data correctly
Reproducible: Always
User Profile Reset: No
Additional Info:
We will load the data file on the ticket about 5mb
I cannot find a corrupt data record, there may well be though
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
