Row height not sticking

Discuss the spreadsheet application

Row height not sticking

Postby wendi » Sat Jul 20, 2019 4:13 am

Win10Pro64, OO4.1.6. I have large spreadsheet filled with text. "Wrap text automatically" is selected for all cells. Many cells do contain enough text to wrap, some four or five lines worth. I've "selected all" (ctrl A), and used "optimum row height" for all rows. At this point, all is good, and all text is visible. But... if I save, quit, and re-start, many rows are now not tall enough to show all of the text that they contain. I can again select all, and select optimum row height, and all will be good, but only for that session. Any ideas on what I can do to preserve the row height?
OpenOffice 4.1.5 on Windows 10
wendi
 
Posts: 6
Joined: Wed May 23, 2018 10:23 pm

Re: Row height not sticking

Postby robleyd » Sat Jul 20, 2019 4:32 am

Are you saving in OpenOffice format, i.e. .ods? If not, please try saving as .ods and see what happens.
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2865
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Row height not sticking

Postby wendi » Sat Jul 20, 2019 5:02 am

Hi robleyd. Thanks for replying. I've been saving it as .xls, but I just tried .ods as you suggested. It behaves exactly the same in both formats.

As a test, I noted a particular row that opened with a row height of 0.52. After "optimum row height", that row grew to 0.71. After saving, closing, and reopening, that row is again 0.52. Another row behaved similarly, growing from 0.85 to 0.89, but reverting to 0.85 upon reloading.
OpenOffice 4.1.5 on Windows 10
wendi
 
Posts: 6
Joined: Wed May 23, 2018 10:23 pm

Re: Row height not sticking

Postby Zizi64 » Sat Jul 20, 2019 5:59 am

Can you uploadf a small, ODF type sample file here?
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8137
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Row height not sticking

Postby wendi » Sat Jul 20, 2019 6:13 am

Hi Zizi64. I can't send you my actual file, because it has confidential information. I created a new spreadsheet, and after a bit of playing around, I was able to create an example. It's not as extreme as on my real spreadsheet, but the row height does change. If it behaves the same for you as it does for me, you'll see that it opens with row A at 0.85, and the text is a just a bit squished on top. There is also a little red triangle indicating some missing text. Perform "optimum row height", and the height will grow to 0.89. Save, quit, and restart, and the height will be back to 0.85. At least that's what it just did for me.
Attachments
test.ods
(9.49 KiB) Downloaded 6 times
OpenOffice 4.1.5 on Windows 10
wendi
 
Posts: 6
Joined: Wed May 23, 2018 10:23 pm

Re: Row height not sticking

Postby FJCC » Sat Jul 20, 2019 6:21 am

The row height does not change for me. It opened with the right height and saving the file, closing OpenOffice and reopening the file caused no change in the row height. I do not have a suggestion of how to change the behavior you are seeing but I will think about it.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7221
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Row height not sticking

Postby wendi » Sat Jul 20, 2019 6:26 am

FJCC. Thanks for jumping in. What was the row height that you saw?
OpenOffice 4.1.5 on Windows 10
wendi
 
Posts: 6
Joined: Wed May 23, 2018 10:23 pm

Re: Row height not sticking

Postby Zizi64 » Sat Jul 20, 2019 6:34 am

Yes, I can see some changing between 2.03 cm and 2.11 cm when is set the "optimal height" and then I reopen the saved state.
(I am using LibreOffice 6.1.6 and SI units.)

2.03 cm is the original state, that will be changed to 2.11 cm by usage the "Optimal height" function, and then it will be reset to 2.03 cm automatically after reopening the saved file.

The manual setting to 2.11 cm will be permanently saved into the file.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8137
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Row height not sticking

Postby wendi » Sat Jul 20, 2019 6:38 am

You are correct. I confirmed it with my spreadsheet. So did I discover a bug?
OpenOffice 4.1.5 on Windows 10
wendi
 
Posts: 6
Joined: Wed May 23, 2018 10:23 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 28 guests