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-bugs@lists.freedesktop.org
Reporter: a.kaspa...@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
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
