STR open new calc spreadsheet. enter A1 370000 A2 2.2% B2 =A1*A2/12 result 8.3333333 should be 678.3333333 with least significant digets truncated or ### displayed notes of explanation: 67 is truncated from display. number is correct but not displayed. resizing window or formatting the cell as something other than General Number corrects the display. 'general' number formatting needs a patch. this can be reproduced as follows enter =370000*.022/12 same problem
I can't reproduce it in Version: 6.1.5.2 (x64) Build ID: 90f8dcf33c87b3705e78202e3df5142b201bd805 CPU threads: 4; OS: Windows 10.0; UI render: default; Locale: de-DE (de_DE); Calc: result is: 678,333333333333 for me Which LO version did you use? The number of decimal places changes with the column width - this is a feature. To be certain the reported issue is not related to corruption in the user profile, could you please reset your Libreoffice profile ( https://wiki.documentfoundation.org/UserProfile ) and re-test? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the issue is still present
Created attachment 150230 [details] demo calc format
Created attachment 150240 [details] sample#1 LO vers is like I posted 4.3.x. When I click update it says it's uptodate. not sure why it doesn't advise of ver 5 and 6. Model Name: MacBook Air Model Identifier: MacBookAir4,2 Processor Name: Intel Core i5 Processor Speed: 1.7 GHz System Version: macOS 10.13.6 (17G5019) Resolution: 1440 x 900 (Widescreen eXtended Graphics Array Plus) I cleared the profile and LO reset a new user profile. Opened your sample ods. everything displayed properly. executed view->zoom->zoom-> changed custom to 85% attached 2 snaps of it
Created attachment 150241 [details] snap#2
I was able to reproduce this by pinching the trackpad to zoom in and out and noticed the display changing at certain resolutions. So I fiddled with the zoom factor and found 85% is one spot it does it though that changes with other files. May I suggest if you have a mouse to try zooming with the control wheel I think. Or what ever your system uses to dynamically zoom the table view and see if you can spot a change in the display to the problem one. It's not a big issue because the user can probably stumble over the fix or will usually reset the format to something other than number General which seems to do it.
(In reply to Phil from comment #5) > I was able to reproduce this by pinching the trackpad to zoom in and out and > noticed the display changing at certain resolutions. i still can not reproduce with LO 6.1.5.2 / 4.4.7.2 (Win10,1920x1080, 125%), so maybe a Mac OS X issue only. you could try to update LO to current version.
Please test if changing Menu/Edit/Preferences/LibreOffice calc/General - Use printer metrics for text formatting has some effect?
(In reply to m.a.riosv from comment #7) > Please test if changing Menu/Edit/Preferences/LibreOffice calc/General - Use > printer metrics for text formatting has some effect? That fixes it. Hopefully that will give some help on resolving an underlying issue with the unchecked display. good job
No repro with Version: 6.2.1.2 Build ID: 7bcb35dc3024a62dea0caee87020152d1ee96e71 Threads CPU : 4; OS : Mac OS X 10.14.3; UI Render : par défaut; VCL: osx; Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded Repeated instructions in initial report. Observed display - the default cell positioning of the numbers correctly truncated the result according to cell size on the right hand side. Zooming in or out with the mouse scroll wheel made no difference. I stepped through zoom values of 400% down to 25% with no visible difference in truncation. The Printer Font Metrics option is not activated in my setup under LO Preferences. Screen Output resolution : 30,5 pouces (1920 x 1080) Intel Iris 1536 Mb
@Phil : LO4352 is End of Life - no one will correct bugs in that version. Please try and repeat this with a current production release (6152 or 6212) of LibreOffice and report back. You can't rely on the update mechanism to work properly on Mac.
update 61xx fixes it. the v4 update button didn't show update needed. Not a mac issue I think but updating is the