Bug 148856 - conditional formatting cannot reference cells from other sheets
Summary: conditional formatting cannot reference cells from other sheets
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.1.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-04-29 16:11 UTC by Christoph Anton Mitterer
Modified: 2022-05-03 21:13 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.