Ask Your Question
0

set formula on cell range (using api)

asked 2015-05-29 13:51:43 +0200

stefano.fraccaro gravatar image

updated 2015-05-29 14:06:32 +0200

I need to use the linest() function throug the .net api . The function return a matrix and I can't use the setFormula of cell object. In LibreOffice I select 4 cells, I write the formula and I press Ctrl+Shift+Enter to confirm. How can I do the same throug the API?

Stefano

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2015-05-29 15:26:13 +0200

pierre-yves samyn gravatar image

Hi - Define ArrayFormula for the range. For example:

oSheet = thiscomponent.sheets.getByIndex(0)
oRange = oSheet.getCellRangeByName("B1:B5")
oRange.setArrayFormula("=ROW(A1:A5)")

Regards

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-05-29 13:51:43 +0200

Seen: 220 times

Last updated: May 29 '15