[Libreoffice-bugs] [Bug 119248] New: Status bar displays "wrong" sum when colored negative cell format used

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Aug 13 12:23:03 UTC 2018


https://bugs.documentfoundation.org/show_bug.cgi?id=119248

            Bug ID: 119248
           Summary: Status bar displays "wrong" sum when colored negative
                    cell format used
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: easyHack, skillCpp
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com
                CC: erack at redhat.com

If current cell is formatted to only show negatives using color, without minus
sign, then the format is used to display status bar functions (sum, average,
...), but does not use colors, which is confusing.

Steps:

1. Put -1 to A1, -2 to A2
2. Format A2 to use "0;[RED]0" format string.

Now if you select A2, status bar would show sum as 2; if you select A2 and A1
*starting from A2* (so that thick border marks A2), sum shown as 3 (but if you
select them starting from A1, sum is shown a -3).

The problem is that color information is discarded in
ScTabViewShell::GetFunction; if we could store the color in the resulting
string somehow, then we could use it in SvxPosSizeStatusBarControl::Paint; in
that case, we would still need to use undecorated string in
SvxPosSizeStatusBarControl::StateChanged when setting item text used in
tooltips.

Nominating as easy hack; Eike: could you please also look at it if this is
reasonable?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180813/535e61f8/attachment.html>


More information about the Libreoffice-bugs mailing list