| Summary: | export to xlsx shows only 65k rows when imported into SPSS | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Andy <silvandy> |
| Component: | Calc | Assignee: | Eike Rathke <erack> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | ||
| Priority: | medium | ||
| Version: | Inherited From OOo | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | target:5.5.0 target:5.4.0.1 target:5.3.4 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
xlsx saved by LO causing data loss when imported into SPSS
the same xlsx saved by Excel that work OK when imported into SPSS |
||
|
Description
Andy
2017-06-01 12:05:58 UTC
Created attachment 133781 [details]
xlsx saved by LO causing data loss when imported into SPSS
Created attachment 133782 [details]
the same xlsx saved by Excel that work OK when imported into SPSS
It's probably (can't check as I don't have SPSS) the <dimension> element (here in ./xl/worksheets/sheet1.xml) that is <dimension ref="A1:B65536"/> instead of <dimension ref="A1:B80001"/> Apparently SPSS ignores any data beyond but sane applications don't. Note that the first file https://bugs.documentfoundation.org/attachment.cgi?id=133781 actually contains only 65536 rows, so the dimension thing is just an assumption. Apparently you attached a wrong file. Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=259c2409310814ae62c8d0aefef19a71e8d88dbe Resolves: tdf#108279 dimension rows are 32-bit and don't wrap at 64k It will be available in 5.5.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Pending review https://gerrit.libreoffice.org/38330 for 5-4 https://gerrit.libreoffice.org/38331 for 5-3 https://gerrit.libreoffice.org/38332 for 5-3-4 Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=e81a6b8a7531cb9f3066234cc4cda53ed7ecd8a9&h=libreoffice-5-4 Resolves: tdf#108279 dimension rows are 32-bit and don't wrap at 64k It will be available in 5.4.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=190c0d9ed02a5ed0659b07955b839bb16b1ba638&h=libreoffice-5-3 Resolves: tdf#108279 dimension rows are 32-bit and don't wrap at 64k It will be available in 5.3.5. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-3-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8273f90c8438f7ee7ecf15cb7825c71855b2fff5&h=libreoffice-5-3-4 Resolves: tdf#108279 dimension rows are 32-bit and don't wrap at 64k It will be available in 5.3.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. |