[Solved] Get cell contents (value, text, formula)

[namar]

Welcome beginner. Please answer all of the questions below which may provide information necessary to answer your question.
-----------------------------------------------------------------------------------------------------------
Which version of OpenOffice.org are you using?
2.2
What Operating System (version) are you using?
windows xp/2000
What is your question or comment?

Hi,
I am beginer in the office application
I have tried to ran the below mentioned script
in openoffice calc...
It's not working....
Even if I am putting any values in the cell,it alsways shows Zereo..
Could u please help me....


Sub getCellInfo
'get the first sheet of the spreadsheet doc
xSheet = ThisComponent.Sheets(0)

'Get value of Cell A1
A1_value = xSheet.getCellByPosition(0,0).value

print A1_value

End Sub

[Villeroy]

Hi and welcome to the forum. There is a separate forum for this type of questions.

Code: Select all

Sub getCellInfo
'get the first sheet of the spreadsheet doc
xSheet = ThisComponent.Sheets(0)

'Get  Cell A1
oCell = xSheet.getCellByPosition(0,0)

'It has a numeric value, a string 2 versions of a formula and an error:
print oCell.value, oCell.string,oCell.formula, oCell.FormulaLocal, oCell.Error

End Sub

[namar]

Thanks for this information...yes it's working now...

Meanwhile Could you please let me know the forum in which I should log these type of Queries...
I have some more doubts to be clarified....

[Villeroy]

I changed location and subject of this thread.