<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 - Calc does not give warning when opening file containing a sheet with more than 1024 columns"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114555">114555</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Calc does not give warning when opening file containing a sheet with more than 1024 columns
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>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>kevin.c.paxman@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
Calc cannot handle sheets with more than 1024 columns. Some files opened by
calc will contain sheets with more than this (for example spreadsheets created
with Excel can have up to ~16,000 columns).
The current behaviour is to silently truncate the sheets at the 1024 column
mark (AMJ). This can lead to the user being unaware that the spreadsheet is
incomplete. If the user saves the file, these columns will be permanently lost.
I propose that a clear warning is given when a user opens a file with over 1024
columns informing them that not all columns are being displayed and that saving
the file will lead to loss of data.
Steps to Reproduce:
1. Open a file saved by Excel with a sheet with more than 1024 columns
2. Save the file
Actual Results:
The large sheet is truncated after column 1024 (AMJ).
No warning of this is given.
The saved file is smaller and no longer contains these columns.
Expected Results:
A warning informs the user that truncation has occured.
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/60.0.3112.90 Safari/537.36</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>