https://bugs.documentfoundation.org/show_bug.cgi?id=166361
Bug ID: 166361
Summary: Conditional formatting in LO Calc sometimes corrupt -
needs better checks
Product: LibreOffice
Version: 25.2.2.2 release
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
FORMATTING: After heavy use (but no crash), I found that conditional formatting
acted strangely on a file.
- Deleting the sheet before the one with conditional formatting changes all
conditional formatting cell references to #REF!
- Duplicating the sheet with conditional formatting yields a copy of the cells,
but not of the conditional formatting.
Steps to Reproduce:
Doesn't happen systematically ex-nihilo → see attached file with conditional
formatting somehow corrupted.
1)Open file "LO conditional formatting corruption.ods".
2)Look at conditional formatting in sheet "Détails" = 2 conditions OK.
3a) Delete first sheet "Liste" → conditional formatting in "Détails" broken
- See screenshots → #REF! in conditional formatting
- Upon saving & opening, conditional formatting has entirely disappeared!
- See
3b) Duplicate the sheet "Détails" -> no conditional formatting in copy
"Détails_2".
- See attachment "LO conditional formatting corruption delete sheet.ods".
Actual Results:
Conditional formatting is:
3a) broken upon prior sheet deletion, then disappears entirely, or
3b) not copied in sheet copy.
Expected Results:
a) Conditional formatting in a sheet should not be broken by deletion of
another (unless there is a dependency, which is not the case here).
b) Conditional formatting should be reliably copied when duplicating a sheet.
Reproducible: Always
User Profile Reset: No
Additional Info:
This is not easily reproducible in general, but always in the attached sheet.
Somehow, the conditional formatting info here has some form of subtle
corruption → LO Calc needs more robust checks (conditional formatting is in
general one of the weak points).
Version: 25.2.2.2 (X86_64) / LibreOffice Community
Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac
CPU threads: 8; OS: macOS 12.7.6; UI render: default; VCL: osx
Locale: fr-CH (fr_CH.UTF-8); UI: fr-FR
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
