Overview | Module | Use | Devguide | Index

Included Services | Exported Interfaces | Properties' Summary | Properties' Details

:: com :: sun :: star :: sheet ::
service TableValidation
Description represents the data validation settings for a cell or cell range. Developers Guide 8.3.11 Spreadsheet Documents - Working with Spreadsheet Documents - Other Table Operations - Data Validation

Exported Interfaces
::com::sun::star::beans::XPropertySet | Description provides access to the properties.
XSheetCondition | Description provides access to the settings of the condition.

Properties' Summary
Type | specifies the type of validation.
ShowInputMessage | specifies if an input message is shown when the cursor is in a cell with these validation settings.
InputTitle | specifies the title of the window showing the input message.
InputMessage | specifies the text of the input message.
ShowErrorMessage | specifies if an error message is displayed when invalid data is entered.
ErrorTitle | specifies the title of the window showing the error message.
ErrorMessage | specifies the text of the error message.
IgnoreBlankCells | specifies if blank cells should be allowed.
ErrorAlertStyle | specifies the style of the error message.

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 .

Top of Page

Copyright © 2003 Sun Microsystems, Inc.