Public bug reported:
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/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"/>
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-0ubuntu0.18.04.1
ProcVersionSignature: Ubuntu 4.15.0-34.37-generic 4.15.18
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)
** Affects: libreoffice (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug bionic
** Attachment added: "Example file from my version of libreoffice"
https://bugs.launchpad.net/bugs/1796698/+attachment/5198690/+files/vanilla.xlsx
--
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1796698
Title:
Assigns style to collumns it cannot handle in .xlsx files
Status in libreoffice package in Ubuntu:
New
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/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"/>
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-0ubuntu0.18.04.1
ProcVersionSignature: Ubuntu 4.15.0-34.37-generic 4.15.18
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)
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1796698/+subscriptions
--
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
