[Libreoffice-bugs] [Bug 137735] FILESAVE: Chart defects when reopening : loss of backwards compatibility

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from matthewnote at yahoo.co.uk ---
Additional information for debug and User workaround.  Excel format saves.

With a file already open (Calc 5,6,7,Fresh) a chart may become frozen.
The Calc 5 workaround is to Save, Close.  Only after Re-Open we see all the
charts correctly, including on all sheets.  The "close" is necessary.

File, Save As, Excel format xlsx behaves differently.  It prepares the "save"
format of a broken-chart situation (cache) and (for some reason) that causes a
redraw.  The charts will jump to the correct series' values visually during the
write process.  Therefore it confirms to the user what is being saved, which
helps a lot on a busy project.  The "close, re-Open" is unnecessary.

Furthermore, frozen charts workaround saving in Excel format is possible in any
version of Calc 6,7 (not limited to Calc 5).  Users are best choosing latest
calc version for xlsx, to include the maximum compatibility in the details. 
For example "conditional formats" have received attention and corrections to
the translation.

-- 
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/20201027/6ae69f17/attachment.htm>