[Libreoffice-bugs] [Bug 132135] New: Ctrl+mousewheel zooming displays rounded numbers as "###" in column A only

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Apr 15 20:34:31 UTC 2020


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

            Bug ID: 132135
           Summary: Ctrl+mousewheel zooming displays rounded numbers as
                    "###" in column A only
           Product: LibreOffice
           Version: 7.0.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jim.avera at gmail.com

Created attachment 159595
  --> https://bugs.documentfoundation.org/attachment.cgi?id=159595&action=edit
Trivial demo spreadsheet showing the bug

If a cell with Number format 0.00 (i.e. two decimal places) contains the value
1234567.894999 it is displayed rounded to 1234567.89

However, if it is in Column A, then at various zooms "###" appears instead. 
This does not seem to happen in Column B.

Please see attached demo spreadsheet.

STEPS TO REPRODUCE (if not using attached demo):

1. Select A2 and B2, rightclick->Format Cells...
   Click Numbers tab, set format code to 0.00, then OK

2. Enter the value 1234567.894999 into both cells.

3. Ctrl+mousewheel to change zoom.

RESULTS: A2 flashes between the correct display (1234567.89) and "###" at
certain maginifications.

EXPECTED RESULTS: Numbers should be displayed correctly at any magnification.

Note: This might have the same root casue as
https://bugs.documentfoundation.org/show_bug.cgi?id=99584
however this bug is much simpler with a trivial demo.  If devs think they are
the same underlying problem, I suggest linking that older bug to this one
rather than vice-versa.

-- 
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/20200415/ff7d883f/attachment.htm>


More information about the Libreoffice-bugs mailing list