<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 - Superfluous warning about data loss when opening XLSX file with defined worksheet style"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117210">117210</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Superfluous warning about data loss when opening XLSX file with defined worksheet style
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</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>ondrej@kluug.net
</td>
</tr></table>
<p>
<div>
<pre>Description:
If an XLSX file (created with MS Excel) has defined column styles in the whole
worksheet, the following warning dialog box is shown at startup:
--
Warning loading document test.xlsx:
The data could not be loaded completely because the maximum number of columns
per sheet was exceeded.
--
But there is no data after the ODS limit, only column definitions. So this
warning is redundant.
Steps to Reproduce:
1. Create a new XLSX file with Excel 2007 or newer.
2. Click the upper-left cell header between A and 1 to select all cells.
3. Change font style and background color. The properties will be applied to
all cells.
4. Save the XLSX file.
5. The sheet1.xml in the XLSX file will look like this:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<worksheet xmlns="<a href="http://schemas.openxmlformats.org/spreadsheetml/2006/main">http://schemas.openxmlformats.org/spreadsheetml/2006/main</a>"
xmlns:r="<a href="http://schemas.openxmlformats.org/officeDocument/2006/relationships">http://schemas.openxmlformats.org/officeDocument/2006/relationships</a>">
<dimension ref="A1"/>
<sheetViews>
<sheetView tabSelected="1" workbookViewId="0">
<selection activeCell="A2" sqref="A2"/>
</sheetView>
</sheetViews>
<sheetFormatPr baseColWidth="10" defaultColWidth="6.85546875"
defaultRowHeight="15"/>
<cols>
<col min="1" max="16384" width="6.85546875" style="1"/>
</cols>
<sheetData>
<row r="1" spans="1:1">
<c r="A1" s="1" t="s">
<v>0</v>
</c>
</row>
</sheetData>
<pageMargins left="0.7" right="0.7" top="0.78740157499999996"
bottom="0.78740157499999996" header="0.3" footer="0.3"/>
<pageSetup paperSize="9" orientation="portrait" horizontalDpi="0"
verticalDpi="0" r:id="rId1"/>
</worksheet>
-> note the col/@max value of 16384: <col [...] max="16384" [...] />
6.) Open the XLSX file with LibreOffice 6.0.3.2. It will report a warning
although there is no data after the ODS limit.
LibreOffice 5.1.6.2 doesn't report any warning when opening the file.
Actual Results:
The following warning is shown:
Warning loading document test.xlsx:
The data could not be loaded completely because the maximum number of columns
per sheet was exceeded.
Expected Results:
No warning should be shown because there is no data after the limit and thus
nothing is lost.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 6.0.3.2 (x64)
Build ID: 8f48d515416608e3a835360314dac7e47fd0b821
CPU threads: 4; OS: Windows 10.0; UI render: default;
Locale: cs-CZ (cs_CZ); Calc: group
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/65.0.3325.181 Safari/537.36 OPR/52.0.2871.64</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>