[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