Created attachment 58780 [details] in the ZIP file, and sample of ODS & screenshot with marked issue are shown Problem description: In these new versions 3.5.* , if I do enter a lot of text (meaning several lines, e.g. 17, etc. ...) within one cell, the final view of that cell is somehow corrupted, while several empty lines (or blank space) are shown above the text, despite of that, there ain't no empty space entered by myself. And the more lines are within one cell, the more blank space is shown above it. And if i set smaller font for the cell, the blank space is even bigger than with larger font. Screenshots & sample ODS file will be provided. On smaller display, like on laptop, this is consuming lot of space, where other content of spreadsheed can be displayed. Steps to reproduce: 1. open new spreadsheed, 2. enter e.g. following sample text (without brackets of course) into one cell: { This is only sample text. This is only sample text. This is only sample text. This is only sample text. This is only sample text. This is only sample text. This is only sample text. This is only sample text. This is only sample text. This is only sample text. This is only sample text. This is only sample text. This is only sample text. This is only sample text. This is only sample text. This is only sample text. This is only sample text. } 3. the blank space shall be displayed above the text in the cell. Current behavior: This behaviour is unwanted, as it's consuming lot of viewing space on e.g. laptops. Expected behavior: On previous versions, this was not an problem. Platform (if different from the browser): Arch Linux Browser: Mozilla/5.0 (X11; Linux x86_64; rv:11.0) Gecko/20100101 Firefox/11.0
### update ### The issue I described previously is mainly occuring on my Arch Linux, at work. After comming home, I've detected this issue to be very random and strange. Have tested it on three another Linux systems (all have latest 3.5.1 version of LO), where: - main computer, using Debian based system, LO installed from downloaded DEB packages. - virtual Ubuntu 11.10, installed from repository. - virtual Arch Linux, installed from main repository. While at work, if I create any new spreadsheet, I get this "blank space" issue instantly. After testing it at home, if I created new spreadsheet on any of mentioned home systems, the issue cannot be reproduced. BUT! if I open this same copy of sample.ods I provided/attached in here, the issue is shown again - precisely as on the work system, but only in this sample.ods I created at work. I though, that if that might be some distribution specific bug, then at least the home testing virtual with Arch shall be affected the same way, as they use the same source to install the LO, but it didn't reproduced on new sheets even in there. Now I'm dubious, what to hell! Is this indeed an bug, or what might be causing this?
I am unable to reproduce the problem by myself on my x64 Win7 machine by typing in the text manually. But opening the attached .ods document shows the problem only for the smaller font cells. The normal sized font cells are okay.
(In reply to comment #2) > I am unable to reproduce the problem by myself on my x64 Win7 machine by typing > in the text manually. > > But opening the attached .ods document shows the problem only for the smaller > font cells. The normal sized font cells are okay. Hi, yes, I've discovered the same behaviour, while trying it on a new sheet on another machine, unable to reproduce it on new. Anyway, I would love to know what is causing the problem as e.g. on the attached sheet you've confirmed also on Win platform. Also as you've said, after sizing the font to normal, the cells are okay, I also detected this at one of my attempts. Strange.
Comment on attachment 58780 [details] in the ZIP file, and sample of ODS & screenshot with marked issue are shown not issue in the file
Created attachment 61056 [details] source of this issue is in this file
I've made some more research on my own, and have found, that possible root cause is in the file ~/.config/libreoffice/3/user/registrymodifications.xcu If anybody applies this XCU modifications (just to test it) file https://bugs.freedesktop.org/attachment.cgi?id=61056 to his LO profile, the issue will be displayed. If I remove these data from this XCU file: { <item oor:path="/org.openoffice.Office.Calc/Layout/Zoom"> <prop oor:name="Value" oor:op="fuse"> <value>86</value> </prop> </item> } The issue is gone if I remove this code, or to remove the XCU file at all, so that new one will be created anyway. I've checked also another registrymodifications.xcu on my other computer, where the issue didn't appeared. And the XCU file also contain this same code above, but this other computer ain't affected. So I presume, that there must be something more related in this particular XCU file, which is causing this. But there is too much of data inside of this file for me, to understand it entirely, to find the root cause. Anyway, I'm happy I've found it. I'll leave this bug opened, in case somebody would like to play more with it, perhaps some research that might lead to another or greater hypothetical bug. If not, feel free to close it.
Very common problem. LO 3.4 corrupted user profile. Now in 3.5 users should delete user profile at all. Or restore from pre-3.4 backup of user profile.
RESOLVED WORKSFORME as per comment 6.
The content of attachment 61056 [details] has been deleted