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

            Bug ID: 153913
           Summary: FILESAVE / FORMATTING: Failure to save cell background
                    colour of otherwise empty cells
           Product: LibreOffice
           Version: 4.3.0.4 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Description:
Repeatedly encountered an issue with the background cell colour not being saved
in a .xls file when using Calc. I had been using LibreOffice 7.4.03 and have
upgraded to 7.4.5.1 in the hope of fixing this issue but this did not help.

The spreadsheet I've been working on saves the background colour of some cells,
but fails to save the background colour for other cells. I'm not entirely sure
but I think the cells where it isn't saving the background colour are ones on
lines where I inserted rows. However, this is not consistent behaviour if true;
error seems to mostly affect sheet 2 and 3 of the file.

This appears to be less of a problem when saving the file as .xlsx but
sometimes still causes the error.

Reliable workaround: If I write text in the cells with a background colour, the
text and the background colour is saved.

Error persists in safemode.

Possible duplicate of Bug 46738.

Steps to Reproduce:
1) Set background colours for cells.
2) Save using the keyboard shortcut "Ctrl+s" or by clicking the save icon.
3) The file appears to have been saved (no longer shows the "unsaved" symbol).
4) Close the file.

Actual Results:
Reopen the file and the cells have reverted to no-background colour.

Expected Results:
Reopen the file and the cells retain formatting.


Reproducible: Sometimes


User Profile Reset: Yes

Additional Info:
Version: 7.4.5.1 (x64) / LibreOffice Community
Build ID: 9c0871452b3918c1019dde9bfac75448afc4b57f
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to