Language Asturianu (ast) Català (ca) Čeština (cs) Dansk (da) Deutsch (de) English [US] (en-US) Español (es) Esperanto (eo) Eesti keel (et) Euskara (eu) Français (fr) Gàidhlig (gd) Galego (gl) Italiano (it) Lietuvių (lt) Magyar (hu) Nederlands (nl) Norsk (no) Polski (pl) Português [do Brasil] (pt-BR) Português [Europeu] (pt) Română (ro) Slovenčina (sk) Slovenščina (sl) Suomi (fi) Svenska (sv) Yкраїнська (uk) Tiếng Việt (vi) Türkçe (tr) ኦሮሚኛ (om) Հայերեն (hy) Ελληνικά (el) български език (bg) Русский (ru) Cрпски [ћирилицом] (sr) עברית (he) हिन्दी (hi) ភាសាខ្មែរ (km) தமிழ் (ta) ภาษาไทย (th) 简体中文 (zh-CN) 正體中文 (zh-TW) 日本語 (ja) 한국어 (ko)

The Free and Open Productivity Suite

• Product
• Download
• Support
• Blog
• Extensions & Templates
• Get Involved
• Focus Areas
• Native Languages

home » api » docs » common » ref » com » sun » star » sheet

Overview

Module

Use

Devguide

Index

Services' Summary

Interfaces' Summary

Properties' Summary

Services' Details

Interfaces' Details

Properties' Details

---

:: 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

---

Copyright © 2013, 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.

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

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