Basically what I want to do is:
Code: Select all
oCell = ThisComponent.getCellByName("A4")
oCell.String = "Value"
oCell.Column = oCell.Coumn+1
oCell.Formula = "=0"[Solved] Modify cell address
[Solved] Modify cell address
Seems like a simple thing but couldn't find any documentation how to access a cell's col and row number. I got a cell that I've given a string to and now I would like to move one column over and input a specific formula.
Basically what I want to do is:
Basically what I want to do is:
Last edited by kebab4you on Wed Aug 05, 2015 7:54 pm, edited 1 time in total.
OpenOffice 4.1.1
Windows 7
Windows 7
Re: Modify cell address
This macro acts on the currently active sheet.
Code: Select all
oSheet = ThisComponent.CurrentController.ActiveSheet
oCellA4 =oSheet.getCellRangeByName("A4")
oCellA4.String = "Value"
CellAddr = oCellA4.CellAddress
oNeighbor = oSheet.getCellByPosition(CellAddr.Column + 1, CellAddr.Row)
oNeighbor.Formula = "=0"OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Modify cell address
Perfect, thanks a lot!FJCC wrote:This macro acts on the currently active sheet.Code: Select all
oSheet = ThisComponent.CurrentController.ActiveSheet oCellA4 =oSheet.getCellRangeByName("A4") oCellA4.String = "Value" CellAddr = oCellA4.CellAddress oNeighbor = oSheet.getCellByPosition(CellAddr.Column + 1, CellAddr.Row) oNeighbor.Formula = "=0"
OpenOffice 4.1.1
Windows 7
Windows 7