Summary: | CALC: Dynamic conditional colour formatting in autofiltered arrays | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Colin <that.man.colin> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED WONTFIX | ||
Severity: | enhancement | CC: | erack, libreoffice-ux-advise |
Priority: | medium | Keywords: | needsUXEval |
Version: | 7.0.3.1 release | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 87351 | ||
Attachments: | Simple example sheet with an effective data volume |
Description
Colin
2020-11-25 08:22:48 UTC
Could you please attach a document with a minimum example? (In reply to Heiko Tietze from comment #1) > Could you please attach a document with a minimum example? I can confirm that I am currently using Release version 7.0.4.2 as opposed to version 7.0.3.1 which was active at the time of the request. I just constructed a small sheet which should have demonstrated what I was suggesting and it now performs as I would have expected from the suggested enhancement. I originally believed my request and the existing behaviour were both valid scenarios but must now assume somebody had already flagged it as a bug - which has now been remedied. Should I set it to RESOLVED - NOT A BUG or is that your domain? Whether magically or silently fixed, happy to see it working for you. Feel free to reopen in case. Created attachment 168828 [details]
Simple example sheet with an effective data volume
(In reply to Heiko Tietze from comment #3) > Whether magically or silently fixed, happy to see it working for you. Feel > free to reopen in case. My entire text was deleted because I submitted the sheet at the same time as I posted the comment. Sheet one shows a filtered data set and the colour rendition covering the whole spectrum. so one column is almost entirely red (un-filtering will demonstrate the complete spectrum) Sheet two shows a paste special of the filtered event where the colour format has been created to cover the data ranges it encounters and produces the colour spectrum suggested by my request. Probably a misconception. Let's take a simple example Group Value 1 1 1 1 1 2 2 2 2 3 2 3 If you apply the color scale to value 1 becomes green, 2 yellow, and 3 red. If you copy the group 1 and apply the same color scale you don't have the full range and 2 becomes red. Without having read the initial request: doing the calculation based on the current filter makes absolutely no sense. A filter is not a subset. (In reply to Heiko Tietze from comment #6) > Probably a misconception. Let's take a simple example > > Group Value > 1 1 > 1 1 > 1 2 > 2 2 > 2 3 > 2 3 > > If you apply the color scale to value 1 becomes green, 2 yellow, and 3 red. > If you copy the group 1 and apply the same color scale you don't have the > full range and 2 becomes red. > > Without having read the initial request: doing the calculation based on the > current filter makes absolutely no sense. A filter is not a subset. Precisely the substance of the request. The implication is that the boundaries are set by the original group and it would be nice if there were some mechanism by which the boundaries could be changed by the selection of a subset to reflect the new highs & lows extant in the subset. I think what you're saying is - Not possible/desirable/logical via the auto-filter/SUBTOTAL() mechanism and that a user would have to copy and paste special the data and then re-define the conditional colour spectrum for each and every iteration of paste special. You define the range in the color scale dialog. No idea how to work around this but the request is a WF. Adding Eike for an idea - and you can always go to ask.libreoffice.org |