[Libreoffice-ux-advise] [Bug 138478] CALC: Dynamic conditional colour formatting in autofiltered arrays
https://bugs.documentfoundation.org/show_bug.cgi?id=138478 Heiko Tietze changed: What|Removed |Added Resolution|--- |WONTFIX CC||er...@redhat.com Status|NEEDINFO|RESOLVED --- Comment #8 from Heiko Tietze --- 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 -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 138478] CALC: Dynamic conditional colour formatting in autofiltered arrays
https://bugs.documentfoundation.org/show_bug.cgi?id=138478 --- Comment #7 from Colin --- (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 are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 138478] CALC: Dynamic conditional colour formatting in autofiltered arrays
https://bugs.documentfoundation.org/show_bug.cgi?id=138478 Heiko Tietze changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #6 from Heiko Tietze --- 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. -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 138478] CALC: Dynamic conditional colour formatting in autofiltered arrays
https://bugs.documentfoundation.org/show_bug.cgi?id=138478 QA Administrators changed: What|Removed |Added Whiteboard| QA:needsComment| -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 138478] CALC: Dynamic conditional colour formatting in autofiltered arrays
https://bugs.documentfoundation.org/show_bug.cgi?id=138478 Colin changed: What|Removed |Added Ever confirmed|1 |0 Resolution|WORKSFORME |--- Status|RESOLVED|UNCONFIRMED --- Comment #5 from Colin --- (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. -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 138478] CALC: Dynamic conditional colour formatting in autofiltered arrays
https://bugs.documentfoundation.org/show_bug.cgi?id=138478 --- Comment #4 from Colin --- Created attachment 168828 --> https://bugs.documentfoundation.org/attachment.cgi?id=168828&action=edit Simple example sheet with an effective data volume -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 138478] CALC: Dynamic conditional colour formatting in autofiltered arrays
https://bugs.documentfoundation.org/show_bug.cgi?id=138478 Heiko Tietze changed: What|Removed |Added Resolution|--- |WORKSFORME Status|NEEDINFO|RESOLVED --- Comment #3 from Heiko Tietze --- Whether magically or silently fixed, happy to see it working for you. Feel free to reopen in case. -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 138478] CALC: Dynamic conditional colour formatting in autofiltered arrays
https://bugs.documentfoundation.org/show_bug.cgi?id=138478 --- Comment #2 from Colin --- (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? -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 138478] CALC: Dynamic conditional colour formatting in autofiltered arrays
https://bugs.documentfoundation.org/show_bug.cgi?id=138478 Heiko Tietze changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #1 from Heiko Tietze --- Could you please attach a document with a minimum example? -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 138478] CALC: Dynamic conditional colour formatting in autofiltered arrays
https://bugs.documentfoundation.org/show_bug.cgi?id=138478 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Keywords||needsUXEval CC||libreoffice-ux-advise@lists ||.freedesktop.org Blocks||87351 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=87351 [Bug 87351] [META] Conditional formatting bugs and enhancements -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise