Hi Mikael,
I wonder where I can find a list of all property available for a
XCellRange object.
Actually I want to get the number of columns and the number of rows
of a
cell range. I've tried with the Size properties but that don't give
the
number of rows and columns, it gives the height and width of the cell
range.
Here's what I would :
----------------------------------------------
Reference< XCellRange > aCellRange =
pCalc->getCellRangebyString("A1:B4");
Reference< beans::XPropertySet > xPropSet (aCellRange,UNO_QUERY);
uno::Any nRow =
xPropSet->getPropertyValue(rtl::OUString::createFromAscii("NRow"));
sal_Int32 n;
nRow >>= n;
----------------------------------------------------
You could query the interface css.table.XColumnRowRange of your
CellRange.
This interface has the methods "getColumns()" and "getRows()", which
return css.table.XTableColumns and css.table.XTableRows respectively.
Both these Interfaces can be queried to an css.container.XIndexAccess
which has the method getCount().
Hope that helps
Regards
Stephan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
