[Libreoffice-bugs] [Bug 119248] Status bar displays "wrong" sum when colored negative cell format used
https://bugs.documentfoundation.org/show_bug.cgi?id=119248 Hossein changed: What|Removed |Added Whiteboard||reviewed:2023 --- Comment #7 from Hossein --- Re-evaluating the EasyHack in 2023 This bug is still relevant in the latest LO dev master, and the status is as described in comment 1. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 119248] Status bar displays "wrong" sum when colored negative cell format used
https://bugs.documentfoundation.org/show_bug.cgi?id=119248 --- Comment #6 from Mike Kaganski --- (In reply to Eleni Zapridou from comment #5) This is not a bug per se, and it was never stated otherwise. Even the title has "wrong" in quotes. Still, there's a usability issue. The status bar is incapable of displaying the formatted value using all the features which cells can use - like colors in format strings, or conditional formatting that might change background for negatives e.g. Also users could custom-format cells to look like sort of booleans to indicate if something matches some conditions or not (like '[<10]"GOOD";[<20]"WARNING";"BAD"')... and it totally doesn't make sense to have such things in status bar for aggregates, when for a sum of cells, you'd see "BAD" in status instead of "100" - what is "BAD" for a data point is not necessarily bad for the sum. So there is a suggestion by Eike in comment 3, which is to use *cell format category's default format* for displaying aggregates in the status bar, which are expected to be generic enough to provide useful aggregate results, even when selection has some fancy formatting. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119248] Status bar displays "wrong" sum when colored negative cell format used
https://bugs.documentfoundation.org/show_bug.cgi?id=119248 Eleni Zapridou changed: What|Removed |Added Assignee|ezapri...@gmail.com |libreoffice-b...@lists.free ||desktop.org -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119248] Status bar displays "wrong" sum when colored negative cell format used
https://bugs.documentfoundation.org/show_bug.cgi?id=119248 Eleni Zapridou changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |ezapri...@gmail.com |desktop.org | -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119248] Status bar displays "wrong" sum when colored negative cell format used
https://bugs.documentfoundation.org/show_bug.cgi?id=119248 --- Comment #4 from Eleni Zapridou --- I am interested to work on this bug with two coworkers of mine, so I am assigning this to me. We will try to solve this, following the proposing instructions from Eike Rathke. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119248] Status bar displays "wrong" sum when colored negative cell format used
https://bugs.documentfoundation.org/show_bug.cgi?id=119248 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||86066 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=86066 [Bug 86066] [META] bugs and improvements to the statusbar -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119248] Status bar displays "wrong" sum when colored negative cell format used
https://bugs.documentfoundation.org/show_bug.cgi?id=119248 --- Comment #3 from Eike Rathke --- Transporting colour to display in status bar IMHO would be overkill. Solution probably would be to not use the actually applied format, but the format's locale's category's default format instead. Of course not for currencies.. Suitable as EasyHack, code pointer: sc/source/ui/view/tabvwsha.cxx ScTabViewShell::GetFunction() place calling pDoc->GetNumberFormat(...) Add something calling SvNumberFormatter::GetStandardFormat( double, sal_uInt32, SvNumFormatType, LanguageType) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119248] Status bar displays "wrong" sum when colored negative cell format used
https://bugs.documentfoundation.org/show_bug.cgi?id=119248 Xisco Faulí changed: What|Removed |Added CC||xiscofa...@libreoffice.org Version|unspecified |Inherited From OOo --- Comment #2 from Xisco Faulí --- Also reproduced in LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119248] Status bar displays "wrong" sum when colored negative cell format used
https://bugs.documentfoundation.org/show_bug.cgi?id=119248 raal changed: What|Removed |Added Ever confirmed|0 |1 CC||r...@post.cz Status|UNCONFIRMED |NEW --- Comment #1 from raal --- reproducible Version: 6.2.0.0.alpha0+ Build ID: ea59fc4831b9d2430de51faa8c3e0a24e6d90cd1 CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3; -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
