Created attachment 68616 [details] sample (ods) that shows problem. See attachment (sample.ods). Zoomed at 100% the complete contenst is visible. see attachment (100percent.gif) When zooming to e.g. 90% by clicking on the minus left of the zoom-scale in the status bar of the form, the content is partly hidden because it no longer fits in the cell. see attachment (90percent.gif) IMO when zooming the layout should not change.
Created attachment 68617 [details] sample zoomed at 100% (gif)
Created attachment 68618 [details] sample zoomed at 90% (gif)
I can confirm this bug on LO 4.3.1 It's particularly bad because the page numbering goes crazy: depending on the zoom (80-90-120%...) the number of pages in the spreadsheet changes (e.g. when you have a macro showing the page number). The only "workaround" is working constantly at the same zoom level, which is not a viable solution. Set to HIGH normal: Calc becomes potentially useless working on some documents.
Another (weak) workaround, at the beginning of a macro you can use something like: ThisComponent.CurrentController.ZoomValue = 100 It's still a poor solution, users might be disoriented by a zoom automatic change.
I've also experienced this issue with LibreOffice, on Ubuntu, and for some years now, up to and including Version 4.4.5.2.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.1.6 or 5.2.3 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20161108
Problem still present in version 5.2.3 (Windows7).
I think this bug is a duplicate of bug 73658. *** This bug has been marked as a duplicate of bug 73658 ***
(In reply to Tom Colley from comment #8) > I think this bug is a duplicate of bug 73658. > > *** This bug has been marked as a duplicate of bug 73658 *** It would be better practise to make the newer bug report (i.e. bug 73658) a duplicate of the older one (i.e. bug 56028). For instance, bug 56028 shows that the problem occurs since (at least) version 3.6.2.2, whereas bug 73658 suggests that the problem only exists since version 4.1.0.4. . I will change this.
*** Bug 73658 has been marked as a duplicate of this bug. ***
*** Bug 108274 has been marked as a duplicate of this bug. ***
*** This bug has been marked as a duplicate of bug 108638 ***