[Libreoffice-bugs] [Bug 117210] New: Superfluous warning about data loss when opening XLSX file with defined worksheet style

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=117210

            Bug ID: 117210
           Summary: Superfluous warning about data loss when opening XLSX
                    file with defined worksheet style
           Product: LibreOffice
           Version: 6.0.3.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ondrej at kluug.net

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="http://schemas.openxmlformats.org/spreadsheetml/2006/main"
xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">
  <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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180424/4edbdd23/attachment.html>