Launchpad has imported 2 comments from the remote bug at https://bugs.documentfoundation.org/show_bug.cgi?id=120502.
If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. ------------------------------------------------------------------------ On 2018-10-11T07:38:59+00:00 Aidas Kasparas wrote: 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 Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1796698/comments/3 ------------------------------------------------------------------------ On 2018-10-11T07:40:11+00:00 Aidas Kasparas wrote: Created attachment 145586 Example file Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1796698/comments/4 ** Changed in: df-libreoffice Status: Unknown => New ** Changed in: df-libreoffice Importance: Unknown => Medium -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1796698 Title: Assigns style to collumns it cannot handle in .xlsx files To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1796698/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
