Bug 132135 - Ctrl+mousewheel zooming displays rounded numbers as "###" in column A only
Summary: Ctrl+mousewheel zooming displays rounded numbers as "###" in column A only
Status: RESOLVED DUPLICATE of bug 108638
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-04-15 20:34 UTC by Jim Avera
Modified: 2020-04-15 21:04 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Trivial demo spreadsheet showing the bug (13.47 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-04-15 20:34 UTC, Jim Avera
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jim Avera 2020-04-15 20:34:31 UTC
Created attachment 159595 [details]
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.
Comment 1 m_a_riosv 2020-04-15 21:04:44 UTC
I think a dup of tdf#108638 FORMATTING Text size is not scaled correctly according to the zoom factor.

Please if you are not agree, reopen it.

*** This bug has been marked as a duplicate of bug 108638 ***