<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Status bar displays "wrong" sum when colored negative cell format used" href="https://bugs.documentfoundation.org/show_bug.cgi?id=119248#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Status bar displays "wrong" sum when colored negative cell format used" href="https://bugs.documentfoundation.org/show_bug.cgi?id=119248">bug 119248</a> from <a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> Mike Kaganski</a> <pre>(In reply to Eleni Zapridou from <a href="show_bug.cgi?id=119248#c5">comment #5</a>) 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 <a href="show_bug.cgi?id=119248#c3">comment 3</a>, 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>