Stephan Wunderlich wrote:
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]
Mikael,
What you need is Bernard Marcelly's X-Ray tool. You can find all
properties of any object.
Try this link
http://www.ooomacros.org/dev.php#101416
Sincerely,
Gerrit Jasper
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
