Properties' Details |
Position
[ readonly ] ::com::sun::star::awt::Point Position;
- Description
- contains the position of this cell in the sheet (in 1/100 mm).
This property contains the absolute position in the whole
sheet, not the position in the visible area.
|
|
Size
[ readonly ] ::com::sun::star::awt::Size Size;
- Description
- contains the size of this cell (in 1/100 mm).
|
|
FormulaLocal
string FormulaLocal;
- Usage Restrictions
- optional
- Description
- contains the formula string with localized function names.
This property can also be used to set a new localized formula.
|
|
FormulaResultType
[ readonly ] long FormulaResultType;
- Description
- contains the content type of the cell.
This property returns not com::sun::star::sheet::FormulaResult
but instead com::sun::star::table::CellContentType. Use FormulaResult2
if the correct property is needed.
|
|
ConditionalFormat
XSheetConditionalEntries ConditionalFormat;
- Description
- contains the conditional formatting settings for this cell.
After a conditional format has been changed it has to be
reinserted into the property set.
- See also
- TableConditionalFormat
|
|
ConditionalFormatLocal
XSheetConditionalEntries ConditionalFormatLocal;
- Usage Restrictions
- optional
- Description
- contains the conditional formatting settings for this cell,
using localized formulas.
After a conditional format has been changed it has to be
reinserted into the property set.
- See also
- TableConditionalFormat
|
|
Validation
::com::sun::star::beans::XPropertySet Validation;
- Description
- contains the data validation settings for this cell.
After the data validation settings have been changed the
validation has to be reinserted into the property set.
- See also
- TableValidation
|
|
ValidationLocal
::com::sun::star::beans::XPropertySet ValidationLocal;
- Usage Restrictions
- optional
- Description
- contains the data validation settings for this cell,
using localized formulas.
After the data validation settings have been changed the
validation has to be reinserted into the property set.
- See also
- TableValidation
|
|
AbsoluteName
[ readonly ] string AbsoluteName;
- Usage Restrictions
- optional
- Description
- Returns the absolute address of the range as string, e.g. "$Sheet1.$B$2".
|
|
CellContentType
[ readonly ] ::com::sun::star::table::CellContentType CellContentType;
- Usage Restrictions
- optional
- Description
- contains the content type of the cell.
- See also
- ::com::sun::star::table::CellContentType
Since LibreOffice 6.1
|
|
FormulaResultType2
[ readonly ] long FormulaResultType2;
- Usage Restrictions
- optional
- Description
- contains the result type of a formula.
- See also
- FormulaResult
Since LibreOffice 6.1
|
|
Copyright © 2020, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.