English:

The Free and Open Productivity Suite
Help us Help the World

Developer's Guide

API

SDK

Tips 'n' Tricks

Miscellaneous


:: com :: sun :: star :: sheet ::

service TableValidation
Description
represents the data validation settings for a cell or cell range.
Developers Guide
Spreadsheets - Other Table Operations - Data Validation

Exported Interfaces - Summary
::com::sun::star::beans::XPropertySet
(referenced entity's summary:)
provides information about and access to the properties from an implementation.
XSheetCondition
(referenced entity's summary:)
provides methods to access the settings of a condition in a conditional format or data validation.
Properties' Summary
ValidationType
Type
specifies the type of validation.  
boolean
ShowInputMessage
specifies if an input message is shown when the cursor is in a cell with these validation settings.  
string
InputTitle
specifies the title of the window showing the input message.  
string
InputMessage
specifies the text of the input message.  
boolean
ShowErrorMessage
specifies if an error message is displayed when invalid data is entered.  
string
ErrorTitle
specifies the title of the window showing the error message.  
string
ErrorMessage
specifies the text of the error message.  
boolean
IgnoreBlankCells
specifies if blank cells should be allowed.  
ValidationAlertStyle
ErrorAlertStyle
specifies the style of the error message.  
short
ShowList
[ OPTIONAL ]
specifies if the list of possible values should be shown on the cell and how. See also TableValidationVisibility  
Exported Interfaces - Details
::com::sun::star::beans::XPropertySet
(referenced entity's summary:)
provides information about and access to the properties from an implementation.
XSheetCondition
(referenced entity's summary:)
provides methods to access the settings of a condition in a conditional format or data validation.
Properties' Details
Type
ValidationType Type;
Description
specifies the type of validation.
ShowInputMessage
boolean ShowInputMessage;
Description
specifies if an input message is shown when the cursor is in a cell with these validation settings.
InputTitle
string InputTitle;
Description
specifies the title of the window showing the input message.

This is only used if TableValidation::ShowInputMessage is set to true.

InputMessage
string InputMessage;
Description
specifies the text of the input message.

This is only used if TableValidation::ShowInputMessage is set to true.

ShowErrorMessage
boolean ShowErrorMessage;
Description
specifies if an error message is displayed when invalid data is entered.
ErrorTitle
string ErrorTitle;
Description
specifies the title of the window showing the error message.

This is only used if TableValidation::ShowErrorMessage is set to true.

ErrorMessage
string ErrorMessage;
Description
specifies the text of the error message.

This is only used if TableValidation::ShowErrorMessage is set to true.

IgnoreBlankCells
boolean IgnoreBlankCells;
Description
specifies if blank cells should be allowed.
ErrorAlertStyle
ValidationAlertStyle ErrorAlertStyle;
Description
specifies the style of the error message.

This is used only if TableValidation::ShowErrorMessage is set to true.

ShowList
short ShowList;
Usage Restrictions
optional
Description
specifies if the list of possible values should be shown on the cell and how. See also TableValidationVisibility

 
Top of Page

Logo ApacheCon Europe 2014

Apache Feather

Copyright & License | Privacy | Website Feedback | Contact Us | Donate | Thanks

Apache, the Apache feather logo, and OpenOffice are trademarks of The Apache Software Foundation. OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.