[Libreoffice-bugs] [Bug 108279] New: export to xlsx shows only 65k rows when imported into SPSS

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108279

            Bug ID: 108279
           Summary: export to xlsx shows only 65k rows when imported into
                    SPSS
           Product: LibreOffice
           Version: 5.3.1.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: silvandy at katamail.com

Description:
When you save a spreadsheet file to XLSX format, in Libreoffice or ms Excel the
rows are shown in full when reopening. Instead if yuu impport the xlsx file
into SPSS software, only the first 65k rows of the sheet will be imported. This
does not happen when saving the file with MS Excel, so the fault lies with the
xlsx export procedure in LO. If you are not aware of this and do not check
thoroughly the results obtained in SPSS, you could end up with HUGE loss of
data.

Steps to Reproduce:
1. The file "more than 65000.xlsx" created with LO 5.3.1.2, has 80.001 rows.
These are all saved and shown also if you open the file in MS Excel.
2.Now open it with SPSS (22 or 23): only the first 65k rows will be imported,
any further data will be lost
3. The file "more than 65000 resaved by microsoft.xlsx" if the same as above,
but it was re-saved using MS Excel 2013 without any change.
4. Now if you import the latter into SPSS, all the rows will be correctly
imported, not only the first 65k!

Actual Results:  
xlsx created or saved by LO have something inside that prevents SPSS from
reading all data, which is instead read if the xlsx file was saved by MS Excel.
Since Excel 97-2003 supported only 65k rows, maybe there is something in the
xlsx file that confuses SPSS into thinking it is an older file?

Expected Results:
All data within the spreadsheet range (1 million rows) should be read correctly
by SPSS


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:53.0) Gecko/20100101
Firefox/53.0

-- 
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/20170601/29183e34/attachment.html>