[Libreoffice-bugs] [Bug 125110] New: CalcSpreadsheet: issues converting .CSV wherre there are more than 30K rows of data

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: admin at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190504/2a989fdb/attachment.html>