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

2020-05-21 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133207

V Stuart Foote  changed:

   What|Removed |Added

 Resolution|--- |WORKSFORME
 Status|UNCONFIRMED |RESOLVED

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


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

2020-05-21 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133207

--- Comment #7 from rha...@sbcglobal.net ---
Problem no longer exists in 6.4.4.2.

Opened file.
Changed fill color in BY5 to green (an empty cell).
Saved file.
Closed program.
Restarted program.
Reloaded file.
Fill color for BY5 was still green.

So we're all good.

Not sure what was up with 6.3.2.2, but no longer matters.
Thanks for your assistance, the both of you.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


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

2020-05-21 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133207

--- Comment #6 from stragu  ---
I can't seem to reproduce this with:

Version: 6.4.3.2 (x64)
Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8
CPU threads: 8; OS: Windows 10.0 Build 18363; UI render: GL; VCL: win; 
Locale: en-AU (en_AU); UI-Language: en-US
Calc: threaded

Would you mind trying with a more recent version of LibreOffice? 6.4 or the
pre-release 7.0

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


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

2020-05-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133207

QA Administrators  changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


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

2020-05-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133207

--- Comment #5 from QA Administrators  ---
[Automated Action] NeedInfo-To-Unconfirmed

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


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

2020-05-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133207

--- Comment #4 from rha...@sbcglobal.net ---
Complication...

Changing a fill color on an empty cell makes the save button in the tool bar
indicate there are "unsaved changes" (the little red dot appears)

So you have a choice to make.  Fix the original bug in this post or change the
behavior of the save button in the toolbar so it doesn't mislead people into
believing it's going to save fill color changes on dataless cells if that's the
only change that's been made.

Sorry.  The rabbit hole got a little deeper...

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


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

2020-05-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133207

--- Comment #3 from rha...@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.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


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

2020-05-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133207

--- Comment #2 from rha...@sbcglobal.net ---
.ODS
I know I mentioned that, but must have removed it when editing/proofreading my
submission. Apologies.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


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

2020-05-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=133207

V Stuart Foote  changed:

   What|Removed |Added

 CC||vstuart.fo...@utsa.edu
 Ever confirmed|0   |1
 Status|UNCONFIRMED |NEEDINFO

--- Comment #1 from V Stuart Foote  ---
What document format are you saving out to? ODF calc .ODS, or OOXML excel
.XLSX?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs