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

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|FIXED                       |---
             Status|RESOLVED                    |NEW
           Hardware|x86-64 (AMD64)              |All
                 OS|Linux (All)                 |All
            Version|6.0.6.2 release             |3.3.0 release

--- Comment #5 from Mike Kaganski <mikekaganski at hotmail.com> ---
Actually, although the problem actually doesn't manifest now for majority of
cases, it still is reproducible like this:

1. Create a new spreadsheet
2. Go to last column: AMJ (Ctrl+Arrow Right)
3. Change the width of column AMJ
4. Save as XLSX.

The reason is the code in sc/source/filter/excel/xetable.cxx introduced in
https://git.libreoffice.org/core/+/64274b38f6cc50a8bb49f114f1ac9e7c1c3b3c4f
back in 2009: that was the commit introduced export to XLSX (integrated to LO
from Go-oo). The code starts with this comment:

> // if last column is equal to last possible column, Excel adds one more

which is directly taken from the older code that exports to XLS binary formats.
Obviously, this is just a left-over from copy-paste. When writing to OOXML
format, Excel doesn't do that.

Setting to NEW.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191231/a16be712/attachment.htm>