Annoying OpenOffice Calc (Spreadsheet) Bug

So, Calc has a nifty option (which may not be unique) that auto-sizes the height of a row (up OR down) to fit the cell in that row that has the most text. For text in a scene description cell or in a scene notes cell, I just type away (I enabled text auto-wrap), hit Enter when done, and Calc takes care of adjusting the row height for me. Having all cells fully visible (with no effort on my part) is great because I want to read every cell at a glance without having to go into the big text cells to expand them. And auto-height ALMOST works perfectly.

There is another option that Calc has, a zoom factor. I recently upgraded my computer monitor because my old one (the thing was eight years old) was taking longer and longer to turn on (it was taking 12 minutes to fully turn on and display anything when I finally broke down and ordered a new one). Anyway, the new monitor is a 2k monitor, that is it displays 2560 by 1440 pixels. It starts right up as it should and has a fantastic amount of screen space. Text on everything, though, is a bit smaller due to the smaller pixel size (Larger resolution with about the same screen size means that the pixels are smaller, and that means everything appears smaller, though it also means more things fit on the screen). That being the case, in Calc I clicked on the zoom adjustment thingy, set it to 105% and . . . rows were no longer adjusting to the correct heights. The height was a little bit off, which cut part of the text in the fullest cells. I asked my trusty friend Google about it and tried all the things I found. Some SEEMED to work, but as soon as I sorted, rows were again not adjusting to the correct heights. It seems that Calc’s auto-height function breaks if zoom is larger than 100%. It might also break if zoom is less than 100, but I’m too lazy to test.

So, how did I get around this annoying bug? I set the zoom back to 100%, selected the entire document, increased the font size, and then modified the Default text format to have the same font size so that newly entered text would also have that font size. Still, aside from this bug, I really like OpenOffice. It’s a fantastic alternative to, and a lot cheaper than, the big productivity suite, particularly for people who are on very tight budgets.

Advertisements
Categories: Tips, Writing | Leave a comment

Post navigation

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: