LibreOffice
LibreOffice 24.2 SDK API Reference
|
contributes properties to control the configuration which is global for all views of a spreadsheet document. More...
import <SpreadsheetDocumentSettings.idl;
Exported Interfaces | |
interface | com::sun::star::beans::XPropertySet |
published service PropertySet | |
Public Attributes | |
boolean | IsIterationEnabled |
enables iterated calculation of circular references. | |
long | IterationCount |
specifies how many iterations are carried out. | |
double | IterationEpsilon |
specifies the point at which a change in results will stop the iteration. | |
short | StandardDecimals |
specifies the number of decimals in the default number format. | |
com::sun::star::util::Date | NullDate |
specifies the date that is represented by the value zero. | |
short | DefaultTabStop |
specifies the width of default tabulators. | |
boolean | IgnoreCase |
specifies whether upper and lower cases are treated as equal when comparing cells. | |
boolean | CalcAsShown |
specifies whether calculations are performed with the rounded values displayed in cells (set to TRUE ) instead of the internal values (set to FALSE ). | |
boolean | MatchWholeCell |
specifies whether filter criteria must match entire cell contents. | |
boolean | SpellOnline |
enables online spell checking. | |
boolean | LookUpLabels |
specifies whether column or row labels are looked up from anywhere on the sheet. | |
boolean | RegularExpressions |
specifies whether regular expressions in formulas are enabled, e.g., for functions which look up spreadsheet contents. | |
com::sun::star::i18n::XForbiddenCharacters | ForbiddenCharacters |
contains the interface XForbiddenCharacters. | |
boolean | HasDrawPages |
If this property is set the document has DrawPages. | |
com::sun::star::lang::Locale | CharLocale |
contains the standard document language for Western text. | |
com::sun::star::lang::Locale | CharLocaleAsian |
contains the standard document language for Asian text. | |
com::sun::star::lang::Locale | CharLocaleComplex |
contains the standard document language for Complex text. | |
boolean | IsLoaded |
specifies whether the document data are already loaded. | |
boolean | IsUndoEnabled |
specifies whether the undo command is enabled. | |
boolean | IsAdjustHeightEnabled |
specifies whether the automatic adjustment of the row height is enabled. | |
boolean | IsExecuteLinkEnabled |
specifies whether the automatic execution of links is enabled. | |
com::sun::star::awt::XDevice | ReferenceDevice |
contains the reference device used for formatting the document. | |
boolean | RecordChanges |
specifies whether changes record is enabled. | |
boolean | IsRecordChangesProtected |
specifies whether changes record is protected. | |
boolean | Wildcards |
specifies whether wildcards in formulas are enabled, e.g., for functions which look up spreadsheet contents. | |
contributes properties to control the configuration which is global for all views of a spreadsheet document.
interface com::sun::star::beans::XPropertySet |
published service PropertySet
provides access to the properties.
|
property |
specifies whether calculations are performed with the rounded values displayed in cells (set to TRUE
) instead of the internal values (set to FALSE
).
|
optionalproperty |
contains the standard document language for Western text.
|
optionalproperty |
contains the standard document language for Asian text.
|
optionalproperty |
contains the standard document language for Complex text.
|
property |
specifies the width of default tabulators.
|
optionalpropertyreadonly |
contains the interface XForbiddenCharacters.
|
optionalpropertyreadonly |
If this property is set the document has DrawPages.
Use this property to find out, whether the document has DrawPages or not, because the getDrawPage method on the XDrawPageSupplier and the getDrawPages method on the XDrawPagesSupplier always creates the DrawPages if there are none; and this is very slow and needs more memory.
|
property |
specifies whether upper and lower cases are treated as equal when comparing cells.
|
optionalproperty |
specifies whether the automatic adjustment of the row height is enabled.
This boolean is actually a counter internally, of the number of times something has locked the height, so setting it to false will only perform one unlock operation, and might leave it still locked
|
optionalproperty |
specifies whether the automatic execution of links is enabled.
|
property |
enables iterated calculation of circular references.
|
optionalproperty |
specifies whether the document data are already loaded.
|
optionalpropertyreadonly |
specifies whether changes record is protected.
|
optionalproperty |
specifies whether the undo command is enabled.
|
property |
specifies how many iterations are carried out.
This setting is only used, if iteration is enabled using SpreadsheetDocumentSettings::IsIterationEnabled.
|
property |
specifies the point at which a change in results will stop the iteration.
More exactly it specifies a difference in the change of the result between two iterations. If the result difference is less than or equal to this epsilon-value, the iteration is stopped.
This setting is only used, if iteration is enabled using SpreadsheetDocumentSettings::IsIterationEnabled.
|
property |
specifies whether column or row labels are looked up from anywhere on the sheet.
Explicitly defined label ranges are used even if this property is set to FALSE
.
|
property |
specifies whether filter criteria must match entire cell contents.
|
property |
specifies the date that is represented by the value zero.
|
optionalproperty |
specifies whether changes record is enabled.
No modification applied if the record changes protection is activated information given by SpreadsheetDocumentSettings::IsRecordChangesProtected
|
optionalpropertyreadonly |
contains the reference device used for formatting the document.
|
property |
specifies whether regular expressions in formulas are enabled, e.g., for functions which look up spreadsheet contents.
RegularExpressions and Wildcards are mutually exclusive, only one can have the value TRUE
. If both are set to TRUE
via API calls then the last one set takes precedence.
|
property |
enables online spell checking.
|
property |
specifies the number of decimals in the default number format.
|
optionalproperty |
specifies whether wildcards in formulas are enabled, e.g., for functions which look up spreadsheet contents.
Wildcards and RegularExpressions are mutually exclusive, only one can have the value TRUE
. If both are set to TRUE
via API calls then the last one set takes precedence.