Bug 148856

Summary: conditional formatting cannot reference cells from other sheets
Product: LibreOffice Reporter: Christoph Anton Mitterer <calestyo>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal CC: miguelangelrv
Priority: medium    
Version: 7.3.1.3 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

Description Christoph Anton Mitterer 2022-04-29 16:11:14 UTC 
Description:
Hey.

When setting up conditional formatting, e.g. trying to look for duplicate values, referencing cell-ranges from other sheets doesn't seem to work.

I can e.g. enter "A1:A10,sheet1.B1:B10" in the respective field and it does seem to recognise whether sheet1 is actually a sheet or not, but after I clicked ok, the "sheet1." part is simply dropped and it uses "A1:A10,B1:B10" instead.

Thanks,
Chris.

PS: This is actually on 7.3.3~rc2

Steps to Reproduce:
see above

Actual Results:
uses the wrong cell range

Expected Results:
use the cell range from the referenced sheet


Reproducible: Always


User Profile Reset: No



Additional Info:
.
Comment 1 m_a_riosv 2022-05-02 22:44:05 UTC 
As I remember, it is so by design.
Comment 2 Christoph Anton Mitterer 2022-05-02 22:54:08 UTC 
Why so? Why shouldn't one be able to use other sheets... seems like a completely unnecessary limitation.
Comment 3 m_a_riosv 2022-05-03 08:31:39 UTC 
CF is defined and saved per sheet, and If I'm not wrong works in the same way with excel.
Comment 4 Christoph Anton Mitterer 2022-05-03 20:07:22 UTC 
Oh, I didn't know that LibreOffice mustn't exceed Excel's features =)
Comment 5 m_a_riosv 2022-05-03 21:13:10 UTC 
Sure, there are a lot of things that you and me don't know.