https://bugs.documentfoundation.org/show_bug.cgi?id=150306
Bug ID: 150306
Summary: Conversion from conditional formatting to regular or
static formatting
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: mgb1...@gmail.com
Description:
It would be great if there was a way to convert, for a selection of cells,
conditional formatting to static or regular formatting. A kind of special
paste.
It would be like the equivalent of "Paste values" to remove the formulas and
leave only the results (fixed values), but for the formatting. That is, the
formatting will no longer depend on any condition/formula but will be fixed and
can be edited/copied to other cells.
I suppose this should be possible using macros, but this is not within the
reach of most users.
Once I wanted to use one of the colors derived from a conditional formatting,
color scale, let's say, one of the intermediate colors of the whole range of
greens created and I could not find a way to do it.
Steps to Reproduce:
Select a range of cells that have conditional formatting and convert the
formatting of that selection to static formatting.
Actual Results:
There is no simple way to do this.
Expected Results:
There is a tool that does the desired conversion.
Reproducible: Always
User Profile Reset: No
Additional Info:
For Excel, there is an extension that does exactly this, see here:
https://www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=276&utilities=117&lang=en_us
--
You are receiving this mail because:
You are the assignee for the bug.
