Bug 132135

Summary:	Ctrl+mousewheel zooming displays rounded numbers as "###" in column A only
Product:	LibreOffice	Reporter:	Jim Avera <jim.avera>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	miguelangelrv
Priority:	medium
Version:	7.0.0.0.alpha0+
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Trivial demo spreadsheet showing the 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 ***