Calc macro equivalent of VBA Range("...")

[polczynskim]

I am totally new to OpenOffice macros, but have some experience with Excel VBA. What is the OpenOffice macro equivalent of this VBA statement to read the contents of a spreadsheet cell named "ABC"?

x = Range("ABC")

Also, what is the equivalent of this statement to read the contents of cell 1,1?

x = Cells(1,1)

Thanks for helping newbie!

[FJCC]

To answer your two specific questions

Code: Select all

oSheet = ThisComponent.Sheets.getByName("Sheet1")
x= oSheet.getCellRangeByName("ABC")
y= oSheet.getCellByPosition(Column, Row)

There is a lot of good macro information at http://www.pitonyak.org/oo.php. There are also object inspectors call XRay and MRI, and you should get one of them if you want to write macros.

[Zizi64]

What is the OpenOffice macro equivalent of this VBA statement to read the contents of a spreadsheet cell named "ABC"?

The NAMED cell(range) and the Absolut name of a cell is not equivalent. For example: $A$1 is an absolut name, but "ABC" is an user defined name of a specific cell.

Code: Select all

	
 oDoc = ThisComponent ' get the actual document object
 oRange = oDoc.NamedRanges.getByName("ABC") ' get a global named range object from the document
 oCell = oRange.ReferredCells.getCellByPosition(0,0)	' get the top-left cell object from the named range
 floatMyValue = oCell.Value
 'stringMyString = oCell.String
 'stringMyFormula = oCell.Formula
 'stringMyFormulaLocal = oCell.FormulaLocal