Summary: | Named Ranges Should Be Able to be Used in Conditional Formatting Dialog Box | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | BillMal <william.malchisky> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | UNCONFIRMED --- | ||
Severity: | enhancement | CC: | erack, heiko.tietze, miguelangelrv, stephane.guillou |
Priority: | medium | Keywords: | needsDevAdvice |
Version: | 7.3.3.2 release | ||
Hardware: | All | ||
OS: | All | ||
URL: | https://ask.libreoffice.org/t/calc-how-to-apply-conditional-formatting-color-scale-or-data-bar-to-a-named-range-or-expression/60688 | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=66250 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 87351, 109178 |
Description
BillMal
2024-03-18 06:35:50 UTC
Looks nice. Thanks for the suggestion. I guess this is an issue that applies to various features that make sure of a range picker; e.g. see bug 66250 for the Chart equivalent of this request. Eike, is there any reason why this shouldn't work? You are welcome. Thank you both for your comments and also the Chart equivalent bug link. Given that premise, to be complete, I would expect Calc to recognize an underlying geometry change of a named range and reflect that within any utilized range pickers: Chart, Conditional Formatting, etc. Otherwise, one would necessitate manually changing the range everywhere it is referenced, outside of formulas where named ranges work fine in my experience. Appreciate the support. Would be nice but requires cross-platform and -application support. In other words it needs to be defined in the file format. |