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
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.
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.
You can activate in the formatting rule the icons for insert/delete rows/columns. Selecting several cells clicking the icon, do the job.
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
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
