[upstream] Assigns style to columns it cannot handle in .xlsx files
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
LibreOffice |
Fix Released
|
Medium
|
|||
libreoffice (Ubuntu) |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
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. In the xl/worksheets/
<col collapsed="false" customWidth="false" hidden="false" outlineLevel="0" max="1025" min="1" style="0" width="11.52"/>
LibreOffice Calc can handle only 1024 columns, but style says it apply to 1025. 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).
File produced on my copy of libreoffice is attached.
ProblemType: Bug
DistroRelease: Ubuntu 18.04
Package: libreoffice-calc 1:6.0.6-
ProcVersionSign
Uname: Linux 4.15.0-34-generic x86_64
ApportVersion: 2.20.9-0ubuntu7.4
Architecture: amd64
CurrentDesktop: ubuntu:GNOME
Date: Mon Oct 8 18:08:43 2018
InstallationDate: Installed on 2018-04-11 (180 days ago)
InstallationMedia: Ubuntu 18.04 LTS "Bionic Beaver" - Alpha amd64 (20180409)
SourcePackage: libreoffice
UpgradeStatus: No upgrade log present (probably fresh install)
Changed in df-libreoffice: | |
importance: | Unknown → Medium |
status: | Unknown → New |
summary: |
- Assigns style to collumns it cannot handle in .xlsx files + Assigns style to columns it cannot handle in .xlsx files |
Changed in df-libreoffice: | |
status: | New → Confirmed |
summary: |
- Assigns style to columns it cannot handle in .xlsx files + [upstream] Assigns style to columns it cannot handle in .xlsx files |
Changed in df-libreoffice: | |
status: | Confirmed → Fix Released |
Thanks for the report. Could you please file an upstream bug report at https:/ /bugs.documentf oundation. org/enter_ bug.cgi? product= LibreOffice& format= guided and share the link to it here?
Thanks!