https://bugs.documentfoundation.org/show_bug.cgi?id=165319
Bug ID: 165319
Summary: LibreOffice Calc looses track of references used in
FORMATTING, if reference is to a later page, on
FILEOPEN
Product: LibreOffice
Version: 24.8.4.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I am formatting some cells on my page in a classic green-yellow-red spectrum
but want some easy reconfiguration. For this, I have a configuration page where
I have different values set to which I want to refer often/easily. As this page
however does not have content, I want to "hide" it in the back of my pages.
When saving and reopening the file (.ods format), the formatting no longer
works and the format which references my configuration page does not find the
configuration page, it needs to be entered as that page again.
Steps to Reproduce:
1. Create a file with at least two pages
2. Fill first page with values
3. Set comparison values in second page
4. Format cells in first page in three colors with reference to the values in
the second page, notice the cells are colored according to their values
5. Save and close the file.
6. Open the file.
7. All formatted cells have the same color now and the format no longer finds
the second page.
8. (Correct the format, swap the order of the pages and do another
save/close/open cycle: The colors remain, no uniform color)
Actual Results:
Color information on formatted cells with the format referencing a later page
gets lost when saving->closing->opening the file.
Expected Results:
Color information on formatted cells with the format referencing a later page
remains when saving->closing->opening the file, just like when referencing an
earlier page in the format.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 24.8.4.2 (X86_64) / LibreOffice Community
Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002
CPU threads: 32; OS: Windows 10 X86_64 (10.0 build 19045); UI render:
Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
