[Solved] Reading and writing to a cell

[Fraz627]

I know this sounds very basic but I'm new at Open Office

how does this translate to Open Office

Mrow=3 ' row number
mcol =4 "column number
mystring="testing"

cells(mrow,mcol)=mystring

also

mystring=cells(mrow,mcol).value

[FJCC]

Code: Select all

oSheet = ThisComponent.CurrentController.ActiveSheet
Mrow=3 ' row number
mcol =4 'column number
mystring="testing"
oCell = oSheet.getCellByPosition(mcol,Mrow)
'cells(mrow,mcol)=mystring
oCell.String = mystring

mystring2 = oCell.String
'mystring=cells(mrow,mcol).value

Rows and columns are indexed from zero, so that code puts text in E4 of the active sheet. Note that the String and the Value of a cell are different things. The String is the text you see, the Value is the underlying numeric value.

[Fraz627]

Thanks, I'm just learning Star basic.