<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - export to xlsx shows only 65k rows when imported into SPSS"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108279">108279</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>export to xlsx shows only 65k rows when imported into SPSS
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.1.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>silvandy@katamail.com
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>