[Libreoffice-bugs] [Bug 131025] Writer document with tables lost data in cells (apparently) replacing with 0

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #20 from Jim DeLaHunt <from+documentfoundation at jdlh.com> ---
Following the instructions from Eike Rathke in comment 16, I was able to
reconstruct the .odt package using the ZIP command on my directory of XML files
(with edits as noted in my comment 15). LibreOffice opened this .odt document
with no error messages.

I agree that this is a severe bug. It causes data loss, for reasons which we
can't expect users to understand. The workaround of opening up the .odt package
and editing XML files is something we can't expect ordinary users to accept.

Part of what makes this problem harder to understand is the behaviour of the
Table… Number Format… menu item when multiple cells are selected. When I
selected cells where some were formatted as "Text" and some as "Number"
"General", the Number Format displayed was "Text" only. This lulled me into
thinking that all the cells were formatted as Text. But when I selected cells
which were all formatted as "Number" "General", then Number Format displayed
the format "Number" "General".

My table happend to have "Text" format for column A, and "Number" "General"
format for remaining columns. When I selected the entire table, it looked like
it was entirely formatted as "Text". That was incorrect.

Thus I suspect that the Number Format UI doesn't display clearly when a
selection of cells have different formats. It should. That would be the subject
of a different bug, an enhancement request.

-- 
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/20201214/5faf2b62/attachment-0001.htm>