[Libreoffice-bugs] [Bug 94393] if I open an MS Excel XLSX file in Calc, dropdowns in cells do not show

[bugzilla-daemon at bugs.documentfoundation.org]

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

Martin Spacek <tdf at mspacek.mm.st> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
                 CC|                            |tdf at mspacek.mm.st
         Resolution|WORKSFORME                  |---

--- Comment #16 from Martin Spacek <tdf at mspacek.mm.st> ---
This bug is NOT fixed. I've tried it on two Ubuntu machines running 5.4.0.3,
one Ubuntu machine running 5.3.4.2, and a Mac running 5.0. As described
elsewhere, using LO Calc to add a validity rule of any kind (not just a list)
to a cell in an empty column, then saving it to .xlsx, then re-opening it
(whether in Excel or LO Calc), reveals that the validity rule wasn't saved at
all. However, putting e.g. a space on line 1000 of that column before saving to
.xlsx prevents the bug from arising. Presumably, for .xlsx, LO Calc doesn't
bother saving anything past the last non-empty cell in a column, even if
formatting or validity rules are applied to those subsequent cells.

This isn't a problem when saving to .ods, and I don't think it ever was.

This post sums it up nicely, and also confirms the bug still exists in 5.4.0.3:

https://ask.libreoffice.org/en/question/77843/validity-rules-are-missing-when-a-calc-file-is-re-opened/

I think this is part of a more general problem: LO Calc doesn't save any types
of formatting to .xlsx, such as cell colour, after the last "empty" row, where
empty means no values entered.

-- 
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/20170804/b4fdc253/attachment.html>