Bug 165790 - When sheet duplication occurs, conditional formatting relies on sheet number instead of sheet name
Summary: When sheet duplication occurs, conditional formatting relies on sheet number ...
Status: RESOLVED DUPLICATE of bug 162692
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.5.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-03-17 15:17 UTC by Borisz
Modified: 2025-03-17 15:22 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
The original file (34.61 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-03-17 15:18 UTC, Borisz 		Details
The result of the sheet dupplication (39.46 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-03-17 15:18 UTC, Borisz 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Borisz 2025-03-17 15:17:26 UTC 
Description:
If you create a conditional formatting that relies on another sheet, then the sheet references will be wrong when you duplicate the sheet that has the conditional formatting.

I suspect the problem is the references to other sheets are based on the sheet number, not on the sheet name, even with $ used.

Steps to Reproduce:
Open Testdoc.ods, duplicate "Results" sheet.

Actual Results:
See in Testdoc_duplicatedsheets.ods

Expected Results:
Properly working formatting.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 24.8.5.2 (X86_64) / LibreOffice Community
Build ID: fddf2685c70b461e7832239a0162a77216259f22
CPU threads: 12; OS: Windows 10 X86_64 (10.0 build 19044); UI render: Skia/Vulkan; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: CL threaded
Comment 1 Borisz 2025-03-17 15:18:26 UTC 
Created attachment 199854 [details]
The original file
Comment 2 Borisz 2025-03-17 15:18:48 UTC 
Created attachment 199855 [details]
The result of the sheet dupplication
Comment 3 Xisco Faulí 2025-03-17 15:22:58 UTC 
Thanks for reporting this issue.
I think this is a duplicate of bug 162692 and it should be fixed in LibreOffice 24.8.6

*** This bug has been marked as a duplicate of bug 162692 ***