Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

f you actually need something like GetCellByPosition(4,12), you must first get access to the sheet containingf the respective cell. Getting sheets as objects is done by methods of the .Sheets property of the spreadsheet document.
mySheet = ThisComponent.Shets.GetByName("myCollection") is an example.
The cell E13 of that sheet you can get then either by
cellE13 = mySheet.GetCellByPosition(4, 12) or by cellE13 = mySheet.GetCellRangeByName("E13") ...

Try to avoid "macros". If you feel sure you will need some, start reading the guide and the famous texts by Andrew Pitonyak.
See this link and this one to start off.

f you actually need something like GetCellByPosition(4,12), you must first get access to the sheet containingf the respective cell. Getting sheets as objects is done by methods of the .Sheets property of the spreadsheet document.
mySheet = ThisComponent.Shets.GetByName("myCollection")ThisComponent.Sheets.GetByName("myCollection") is an example.
The cell E13 of that sheet you can get then either by
cellE13 = mySheet.GetCellByPosition(4, 12) or by cellE13 = mySheet.GetCellRangeByName("E13") ...

Try to avoid "macros". If you feel sure you will need some, start reading the guide and the famous texts by Andrew Pitonyak.
See this link and this one to start off.

f you actually need something like GetCellByPosition(4,12), you must first get access to the sheet containingf the respective cell. Getting sheets as objects is done by methods of the .Sheets property of the spreadsheet document.
mySheet = ThisComponent.Sheets.GetByName("myCollection") is an example.
The cell E13 of that sheet you can get then either by
cellE13 = mySheet.GetCellByPosition(4, 12) or by
cellE13 = mySheet.GetCellRangeByName("E13") ...

Try to avoid "macros". If you feel sure you will need some, start reading the guide and the famous texts by Andrew Pitonyak.
See this link and this one to start off.

f you actually need something like GetCellByPosition(4,12), you must first get access to the sheet containingf the respective cell. Getting sheets as objects is done by methods of the .Sheets property of the spreadsheet document.
mySheet = ThisComponent.Sheets.GetByName("myCollection") is an example.
The cell E13 of that sheet you can get then either by
cellE13 = mySheet.GetCellByPosition(4, 12) or by
cellE13 = mySheet.GetCellRangeByName("E13") ...

Try to avoid "macros". If you feel sure you will need some, start reading the guide and the famous texts by Andrew Pitonyak.
See this link and this one to start off.off.

==Edit1 2018-11-22 14:55 CET===
The announced example.