Calc add row below based on a cell value

[zarenco]

hi all,
i need to insert a row based on a cell value(if cell value>0 add a new blank row below). Can someone help me...
thanks...

[MrProgrammer]

Hi, and welcome to the forum.

i need to insert a row based on a cell value(if cell value>0 add a new blank row below).

The answer depends on why you want the new row. Are you inserting the row so you can enter data there? Or are you inserting the row just to visually separate your data?

[zarenco]

The new row is for enter data...and it has to be the same format as above row ..

[MrProgrammer]

if cell value>0 add a new blank row below

Let's say your cell values are in column D. Pick an unused column. I will use Z an an example. Put 0 in Z1. In Z2 enter formula =Z1<>(D1>0). Fill Z2's formula down the column as needed to match the data in column D. Select column Z. Data → Subtotals → GroupBy=0 → Function=COUNT → ✓Subtotals=0 → OK. Data → Group and Outline → Remove. Clear column Z.

it has to be the same format as above row

Format your columns using Styles.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[elinadicosta]

You can insert row by using formula.

[zarenco]

Let's say your cell values are in column D. Pick an unused column. I will use Z an an example. Put 0 in Z1. In Z2 enter formula =Z1<>(D1>0). Fill Z2's formula down the column as needed to match the data in column D. Select column Z. Data → Subtotals → GroupBy=0 → Function=COUNT → ✓Subtotals=0 → OK. Data → Group and Outline → Remove. Clear column Z.

if cell value>0 add a new blank row below

Let's say your cell values are in column D. Pick an unused column. I will use Z an an example. Put 0 in Z1. In Z2 enter formula =Z1<>(D1>0). Fill Z2's formula down the column as needed to match the data in column D. Select column Z. Data → Subtotals → GroupBy=0 → Function=COUNT → ✓Subtotals=0 → OK. Data → Group and Outline → Remove. Clear column Z.

it has to be the same format as above row

Format your columns using Styles.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

Thanks for your solution, but i'm looking for an automatic process that alows me to do that row insertion(like a macro). When i enter data to a cell from a row, based on that cell's value, a new row has to be inserted below if condition is met.

[zarenco]

You can insert row by using formula.

What formula, if you dont't mind?

[robleyd]

You can insert row by using formula.

What formula, if you dont't mind?

Yes, we'd all love to know the formula to use

@zarenco - the script in this topic might be useful for you.

[Zizi64]

A formula will refresh at every related events: Opening the document, Saving the document, when the related cell is changed, when you hit Ctrl-Shift-F9...
Every event activates the formula: it will be insert a new row again and again... (if you can create such macro function).
This behavior is appropriate for you?