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: .
As I remember, it is so by design.
Why so? Why shouldn't one be able to use other sheets... seems like a completely unnecessary limitation.
CF is defined and saved per sheet, and If I'm not wrong works in the same way with excel.
Oh, I didn't know that LibreOffice mustn't exceed Excel's features =)
Sure, there are a lot of things that you and me don't know.