[Libreoffice-bugs] [Bug 120502] New: Assigns style to columns it cannot handle in .xlsx files

[b***@bugs.documentfoundation.org]

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

Bug ID: 120502
Summary: Assigns style to columns it cannot handle in .xlsx
files
Product: LibreOffice
Version: 6.0.6.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-***@lists.freedesktop.org
Reporter: ***@gmail.com

Description:
LibreOffice Calc can handle only 1024 columns, but default style says it apply
style to column 1025 too. If such .xlsx document is processed with PhpOffice
and single cell value is written, <col> nodes gets expanded, including for <col
min="1025" max="1025"/>. This column cannot be processed by LibreOffice Calc
and produces warnings that some information is lost.

Value should be at most 1024 (or whatever limit is in 6.1).



Steps to Reproduce:
1) Open LibreOffice Calc
2) File > New > Spreadsheet
3) File > Save As, choose name vanilla.xlsx > Save

Extract contents of vanilla.xlsx file to some directory.

Actual Results:
In the xl/worksheets/sheet1.xml file in the node worksheet/cols/ you'll find
node
<col collapsed="false" customWidth="false" hidden="false" outlineLevel="0"
max="1025" min="1" style="0" width="11.52"/>

Expected Results:
<col collapsed="false" customWidth="false" hidden="false" outlineLevel="0"
max="1024" min="1" style="0" width="11.52"/>



Reproducible: Always


User Profile Reset: Yes



Additional Info:
Ideally I prefer to avoid ranges at all if that does not change how documents
are shown. If the max will be in tens of thousand, after processing with
PhpOffice tens of thousands of nodes will be generated after writing even
single cell. Of course it's problem of PhpOffice, but it would be good not to
trigger it.

File produced on my copy of libreoffice is attached.

Bug was filled in Ubuntu bug tracking system at
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1796698 and
instructions were given to submit report here.

Version: 6.0.6.2
Build ID: 1:6.0.6-0ubuntu0.18.04.1
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3;
Locale: en-US (en_US.UTF-8); Calc: group

[b***@bugs.documentfoundation.org]

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

--- Comment #1 from Aidas Kasparas <***@gmail.com> ---
Created attachment 145586
--> https://bugs.documentfoundation.org/attachment.cgi?id=145586&action=edit
Example file

[b***@bugs.documentfoundation.org]

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

Buovjaga <***@suomi24.fi> changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@suomi24.fi
Ever confirmed|0 |1
Status|UNCONFIRMED |NEW

--- Comment #2 from Buovjaga <***@suomi24.fi> ---
Repro.

Arch Linux 64-bit
Version: 6.3.0.0.alpha0+
Build ID: 750ccfb2a60582a5652c08f3cbb6f11d4c152275
CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: gtk3_kde5;
Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US
Calc: threaded
Built on 22 November 2018

[b***@bugs.documentfoundation.org]

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

Roman Kuznetsov <***@mail.ru> changed:

What |Removed |Added
----------------------------------------------------------------------------
Blocks| |108897


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker