[Libreoffice-bugs] [Bug 133207] LibreOffice Calc not saving cell fill-color

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from rhacer at sbcglobal.net ---
Btw, I can see how this may open a huge can of worms.  The program may be in
the midst of a catch-22.

Specifically, the current behavior appears to be:
If data is present in cell > write out data and metadata
Else > write nothing

If this were changed to...
If data OR metadata is present in cell > write out data and metadata
Else > write nothing

... you'd have worse headaches.

In the latter case, the following steps...

1) Enter some data in a few cells.
2) Select All
3) Change cell formatting on selected cells
4) Save the file

... would result in EVERY cell currently in memory being written out creating
unnecessarily large files.

I can think of other solutions, but all come with similar complications except
1:
Have a flag on each cell in memory that only changes if:
1) Data is entered
2) Metadata is changed while Select All is not "on"

But that's just off the top of my head and may have other undesirable results.

As I said, I found a workaround, so I lowered the importance, but I'll be
interested to learn what you find out.

Thanks.

-- 
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/20200520/7a56c9d2/attachment.htm>