https://bugs.documentfoundation.org/show_bug.cgi?id=173598
Bug ID: 173598
Summary: Conditional formatting formula incorrectly evaluated
after updating a linked sheet
Product: LibreOffice
Version: 26.2.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
A source ODS contains a sheet with conditional formatting using a formula such
as $Z4<>"S" applied to B4:B....
In a second ODS, insert the source sheet as a linked sheet.
Actual behaviour:
When the linked sheet is initially inserted, conditional formatting is
displayed correctly. After updating the sheet link, the conditional formatting
is incorrectly applied to all cells in the range.
Workaroud:
Open the conditional formatting rule editor and confirm the existing rule with
OK, without making any changes. The formatting is immediately evaluated
correctly again.
Updating the sheet link once more reproduces the problem.
Ctrl+Shift+F9 / Calculate All does not fix the issue.
The issue is reproducible with a minimal source and destination ODS.
Steps to Reproduce:
1. Open the destination ODS file containing a linked sheet from the source ODS
file.
2. The linked sheet contains conditional formatting based on the formula:
$Z4<>"S"
3. The conditional formatting is initially displayed correctly.
4. Update the linked sheet using:
Sheet > External Links
5. After updating the link, the conditional formatting is evaluated
incorrectly: the style is applied to all cells in the affected range, as if the
condition were TRUE for every row.
6. Open: Format > Conditional > Manage
7. Edit the affected conditional formatting rule and confirm it by clicking OK,
without making any changes to the rule.
8. The conditional formatting is immediately evaluated and displayed correctly
again.
9. Update the linked sheet once more.
10. The problem occurs again and the conditional formatting style is applied to
all cells.
Additional information:
Using Ctrl+Shift+F9 (Calculate All) does not correct the problem.
The issue is reproducible with the attached minimal source and destination ODS
files.
Actual Results:
After updating the linked sheet, the conditional formatting formula is
evaluated incorrectly and the "CodiceChiuso" style is applied to all cells in
the affected range, regardless of the actual values in column Z.
Opening the conditional formatting rule in the editor and clicking OK without
making any changes immediately restores the correct formatting.
The problem occurs again every time the linked sheet is updated.
Expected Results:
After updating the linked sheet, the conditional formatting should be
re-evaluated correctly according to the formula $Z4<>"S".
The "CodiceChiuso" style should only be applied to rows where the corresponding
cell in column Z contains a value different from "S".
Updating the linked sheet should not alter or invalidate the correct evaluation
of the conditional formatting rule.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 26.2.5.2 (X86_64)
Build ID: cd7284b4cbbfeb507e630c1aac019f4157393acb
CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster;
VCL: win
Locale: it-IT (it_IT); UI: it-IT
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
