You are here

LO Calc, How to delete certain rows in spreadsheet automatically

4 posts / 0 new
Last post
cutie_pyie
Offline
Last seen: 9 years 12 months ago
Joined: 2010-02-18 02:20
LO Calc, How to delete certain rows in spreadsheet automatically

Hi all,

I am doing some taxes for some elderly people & I gave them a spreadsheet to use for charitable giving but now I need to edit it down and have a minor problem.

I need some kind/type of command that will automatically delete certain rows that do not have any items in them.
I know I could do this by hand but it certainly is labor intensive & I worry that I might delete a row through error that they need.
Is there a way to automate this process?

Columns A, B, & C are fixed items/values, Rows 7 & 8 of cols B thru H repeat later on down with different thing in A7.
They only had to fill in columns D, E, & G and the rest (F & H) would be computed.
There are some rows at the end of each 'set' where A is blank and B & C have zeroes in them.

This one 'set' is just one of many that I have to clean up for just this couple, there are many more to do!

Thanks a bunch, I very much appreciate any & all help I can get!
Sincerely,
Cindy ;>)

If there is a way to include an image to make things more clear, please let me know how to do so.

J Neutron
Offline
Last seen: 7 months 3 weeks ago
Joined: 2008-06-10 19:26
Sort, then delete

The easiest way without getting crazy with programming or macros, etc, is to just highlight the whole spreadsheet (or the lines in that section), sort on that column (which will group all the offending lines together), delete the lines, then sort the remainder back to the original (probably date).

neutron1132 (at) usa (dot) com

tapsklaps
Offline
Last seen: 6 years 2 months ago
Developer
Joined: 2010-10-17 08:11
some screenshots

Indeed would some screenshots (with some notations within these screenshots) make your problem more transparently.

kensai
Offline
Last seen: 2 years 2 weeks ago
Joined: 2011-11-19 21:02
you may get better

you may get better suggestions on one of the boards that deal directly with using LO or OO.org
for exemple:
http://ask.libreoffice.org/en/questions/
http://www.openoffice.org/support/index.html#community-support

Log in or register to post comments