First time here? Check out the FAQ!
asked 2012-02-27 14:11:54 +0200bkalaska
Hi: Is there a way to insert many rows in a spreadsheet without doing it manually, one row at a time.I have to insert 2 rows at every other row 400 times. I can do it with a macro but still have to insert manually the first time. Thanks, Bill
answered 2012-02-27 21:44:15 +0200MegaTallDave
I don't know a direct way, but there may be a way to work around the problem.
You could number your data rows, and have a 2 rows of otherwise blank rows that started with those same numbers. Then sort by the column with those numbers and the blank rows will be interspersed.
Alternately, if you are extending a pattern, one idea that people commonly overlook is to have a blank as part of that pattern.
If you highlight a calculation and a blank and extend that pattern, then Calc will alternate between a doing a calculation and then skipping a cell.
answered 2012-11-01 17:23:45 +0200jkcunningham
Select a number of consecutive blank rows. Right-click on in the row-number part of the selection Select "Insert Rows".
It will insert the same number of rows you have selected.
answered 2012-03-01 07:11:17 +0200Kris
I had faced similar issues, but the solution to the problem is quite a tedious process. Meanwhile I've heard there are some tools which are looking very interesting. There is this tool called CollateBox http://www.collatebox.com/ heard that its got featureof directly uploading the data. Seems great.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-02-27 14:11:54 +0200
Seen: 624 times
Last updated: Nov 01 '12