SOLVED:duplicate rows - macro not translating data correctly

[davemorley]

Hi all.

I have a macro (below) that is doing mostly what I need but I am getting formula translation errors.

I would have thought that if I have a formula in a cell that reads =AD9*$AK$31 ($AK$31 being absolute) that when the row is duplicated the formulae should remain as =AD9*$AK$31. But it is changing the formula to =AD8*$AK$30. (of course changing to AD8 is correct, but the $AK$31 should stay as is?)

Is this expected behaviour? How do i get around this?

Also, the macro uses a simple "InsertRows" statement. This places the new row above the current selected one. Can I change this behaviour to add the new row below the current one?

[davemorley]

Ive worked out adding the row below the current one;


dispatcher.executeDispatch(document, ".uno:GoToEndOfRow", "", 0, args2())
dispatcher.executeDispatch(document, ".uno:Copy", "", 0, Array())
dispatcher.executeDispatch(document, ".uno:GoDown", "", 0, Array())
dispatcher.executeDispatch(document, ".uno:GoToStartOfRow", "", 0, args2())
dispatcher.executeDispatch(document, ".uno:InsertRows", "", 0, Array())
dispatcher.executeDispatch(document, ".uno:Paste", "", 0, Array())

But still have the formula translation issues.

Any advise?

[davemorley]

SOLVED:

Sorry for the bandwidth.

I ended up replacing the absolute reference using the "name" function

So I named the cell "AK31" to "costWeighting"

Then the actual cell formula became


AD9*costWeighting

Duplicating the row with the macro now works as expected.

thanks