« OpenOffice.org 3.0 feature preview | Main | Four Table Tips for OpenOffice Writer: Blank line above a table, splitting tables, automatic optimal column width, and joining tables »

March 24, 2008


I've always thought I had to select blank rows too. Thanks for the tip.

Thanks Solveig!

This has long been a pet peeve of mine, as I have to insert rows all the time. I even put in a feature request a long time ago to allow one to choose the number of rows one wanted to insert. Out of curiosity, I just checked the help files to see what they said. Somewhere along the line the help has been updated to say: "The number of rows inserted correspond to the number of rows selected.", but no one has the time to keep going back to read through the help to find out what has changed. So thanks again for bringing this to our attention.

BTW, I check your blog often and never fail to come away without learning something new. Keep up the great work.


Thanks Bob! I'm glad it helped.


Hi there!
I have a sheet in OpenOffice.org Calc with more than 4000 rows with data and I want to insert a row between every data row. How to make that?

in OOo calc I found that when two or more cells are merged at top it does not allow to insert some other columns in between them. And also it does allow to insert one by one row or columns i.e. suppose if we select columns B, D, E .... by holding ctrl key and trying to insert columns alternately it does not allow that. This is same for the rows also. Why it is occurred. Please clarify this problem for me.

thanks to give solution ,its realy help us to do fast work.

Thank you for addressing a topic which has bothered me ever since I made the switch to OO back in 2007. Problem solved.


please define shorcut keys to color text in spread sheet ???

The comments to this entry are closed.

GetOpenOffice Consulting

Get Book Resources

Search This Blog