[Libreoffice-bugs] [Bug 108279] New: export to xlsx shows only 65k rows when imported into SPSS
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Thu Jun 1 12:05:58 UTC 2017
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>
More information about the Libreoffice-bugs
mailing list