<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 - FILEOPEN XSLX following SAVE from ODS when Range Names are "large:"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=143058">143058</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILEOPEN XSLX following SAVE from ODS when Range Names are "large:
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.7.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (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>malcolm.d.robbins@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=173187" name="attach_173187" title="Trivial ODS that exhibits the problem when exported to Excel and then loaded">attachment 173187</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=173187&action=edit" title="Trivial ODS that exhibits the problem when exported to Excel and then loaded">[details]</a></span>
Trivial ODS that exhibits the problem when exported to Excel and then loaded
There's a defect saving to Excel and then reloading the Excel sheet (whether
into Calc or Excel) when the sheet has named ranges defined that represent a
"large" column. i.e. If you create a named range by selecting an entire
column.
Attached sheet illustrates the problem via the following steps (note the sheet
has 2 named ranges A and B defined in it that encompass the column column even
though the table has only 10 rows - to support extendability).
1) Open the provided ODS and select Data/Define Range and note that A and B are
defined ranges. A is defined as $Sheet1.$A$1:$A$1048576, B similarly
2) Save the sheet as Excel (either format) and close
3) Now open the XLSX document. It *looks* OK but click on the items in the C
column (defined as A+B) and force evaluation with F9 and you'll get #VALUE!
4) Now go to the range definitions again and you'll see they have been
truncated so a is now defined as $Sheet1.$A$1 and B similarly.
In larger spreadsheets this causes even more severe problems such as the
spurious "Warning loading document 'blah'. The data could not be loaded
completely because the maximum number of rows per sheet was exceeded".</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>