com.aspose.cells
Classes 
AboveAverage
AbstractCalculationEngine
AbstractCalculationMonitor
AbstractGlobalizationSettings
AbstractInterruptMonitor
AbstractTextLoadOptions
ActiveXControl
ActiveXControlBase
ArcShape
Area
AutoFilter
AutoFitterOptions
AutomaticFill
AutoNumberedBulletValue
Axis
AxisBins
BaseShapeGuide
Bevel
Border
BorderCollection
BuiltInDocumentPropertyCollection
Bullet
BulletValue
Button
CalculationCell
CalculationData
CalculationOptions
Cell
CellArea
Cells
CellsColor
CellsDataTableFactory
CellsDrawing
CellsException
CellsFactory
CellsHelper
CellWatch
CellWatchCollection
CharacterBulletValue
Chart
ChartArea
ChartCollection
ChartDataTable
ChartFrame
ChartGlobalizationSettings
ChartPoint
ChartPointCollection
ChartShape
ChartTextFrame
CheckBox
CheckBoxActiveXControl
CheckBoxCollection
CollectionBase
Color
ColorFilter
ColorHelper
ColorScale
Column
ColumnCollection
ComboBox
ComboBoxActiveXControl
CommandButtonActiveXControl
Comment
CommentCollection
CommentShape
ConditionalFormattingCollection
ConditionalFormattingIcon
ConditionalFormattingIconCollection
ConditionalFormattingResult
ConditionalFormattingValue
ConditionalFormattingValueCollection
ConnectionParameter
ConnectionParameterCollection
ContentTypeProperty
ContentTypePropertyCollection
CopyOptions
CustomDocumentPropertyCollection
CustomFilter
CustomFilterCollection
CustomGeometry
CustomImplementationFactory
CustomProperty
CustomPropertyCollection
CustomXmlPart
CustomXmlPartCollection
CustomXmlShape
DataBar
DataBarBorder
DataLabels
DataSorter
DataSorterKey
DataSorterKeyCollection
DateTime
DateTimeGroupItem
DBConnection
DefaultStyleSettings
DeleteOptions
DialogBox
DifSaveOptions
DigitalSignature
DigitalSignatureCollection
DisplayUnitLabel
DocumentProperty
DocumentPropertyCollection
DocxSaveOptions
DrawObject
DrawObjectEventHandler
DropBars
DxfCollection
DynamicFilter
Encoding
ErrorBar
ErrorCheckOption
ErrorCheckOptionCollection
ExportObjectEvent
ExportRangeToJsonOptions
ExportTableOptions
ExternalConnection
ExternalConnectionCollection
ExternalLink
ExternalLinkCollection
FileFontSource
FileFormatInfo
FileFormatUtil
Fill
FillFormat
FilterColumn
FilterColumnCollection
FindOptions
Floor
FolderFontSource
Font
FontConfigs
FontSetting
FontSettingCollection
FontSourceBase
Format3D
FormatCondition
FormatConditionCollection
FormulaParseOptions
FormulaSettings
Geometry
GlobalizationSettings
GlowEffect
GradientFill
GradientStop
GradientStopCollection
GroupBox
GroupFill
GroupShape
HeaderFooterCommand
HorizontalPageBreak
HorizontalPageBreakCollection
HtmlLoadOptions
HtmlSaveOptions
Hyperlink
HyperlinkCollection
IconFilter
IconSet
ImageActiveXControl
ImageFormat
ImageOrPrintOptions
ImageSaveOptions
ImportTableOptions
IndividualFontConfigs
InsertOptions
InterruptMonitor
JsonLayoutOptions
JsonLoadOptions
JsonSaveOptions
JsonUtility
Label
LabelActiveXControl
Legend
LegendEntry
LegendEntryCollection
License
Line
LineFormat
LineShape
ListBox
ListBoxActiveXControl
ListColumn
ListColumnCollection
ListObject
ListObjectCollection
LoadFilter
LoadOptions
MarkdownSaveOptions
Marker
MemoryFontSource
MetadataOptions
Metered
MsoFillFormat
MsoFillFormatHelper
MsoFormatPicture
MsoLineFormat
MsoLineFormatHelper
MsoTextFrame
MultipleFilterCollection
Name
NameCollection
NegativeBarFormat
NoneBulletValue
NoneFill
OdsCellField
OdsCellFieldCollection
OdsLoadOptions
OdsPageBackground
OdsSaveOptions
OleObject
OleObjectCollection
OoxmlSaveOptions
Outline
Oval
PageEndSavingArgs
PageSavingArgs
PageSetup
PageStartSavingArgs
PaginatedSaveOptions
PaneCollection
PasteOptions
PatternFill
PdfBookmarkEntry
PdfSaveOptions
PdfSecurityOptions
PicFormatOption
Picture
PictureBulletValue
PictureCollection
PivotField
PivotFieldCollection
PivotFilter
PivotFilterCollection
PivotFormatCondition
PivotFormatConditionCollection
PivotItem
PivotItemCollection
PivotOptions
PivotPageFields
PivotTable
PivotTableCollection
PlotArea
PptxSaveOptions
ProtectedRange
ProtectedRangeCollection
Protection
QueryTable
QueryTableCollection
RadioButton
RadioButtonActiveXControl
Range
RangeCollection
RectangleShape
ReferredArea
ReferredAreaCollection
ReflectionEffect
ReplaceOptions
Revision
RevisionAutoFormat
RevisionCellChange
RevisionCellComment
RevisionCellMove
RevisionCollection
RevisionCustomView
RevisionDefinedName
RevisionFormat
RevisionInsertDelete
RevisionInsertSheet
RevisionLog
RevisionLogCollection
RevisionMergeConflict
RevisionQueryTable
RevisionRenameSheet
Row
RowCollection
SaveOptions
Scenario
ScenarioCollection
ScenarioInputCell
ScenarioInputCellCollection
ScrollBar
ScrollBarActiveXControl
Series
SeriesCollection
SeriesLayoutProperties
ShadowEffect
Shape
ShapeCollection
ShapeFormat
ShapeGuide
ShapeGuideCollection
ShapePath
ShapePathCollection
ShapePathPoint
ShapePathPointCollection
ShapePropertyCollection
ShapeSegmentPath
ShapeSegmentPathCollection
ShapeTextAlignment
SheetPrintingPreview
SheetRender
SheetSet
SignatureLine
Slicer
SlicerCache
SlicerCacheItem
SlicerCacheItemCollection
SlicerCollection
SmartArtShape
SmartTag
SmartTagCollection
SmartTagOptions
SmartTagProperty
SmartTagPropertyCollection
SmartTagSetting
SolidFill
Sparkline
SparklineCollection
SparklineGroup
SparklineGroupCollection
SpinButtonActiveXControl
Spinner
SpreadsheetML2003SaveOptions
StreamProviderOptions
Style
StyleFlag
SubtotalSetting
SvgSaveOptions
SxRng
TableStyle
TableStyleCollection
TableStyleElement
TableStyleElementCollection
TableToRangeOptions
TextBox
TextBoxActiveXControl
TextBoxCollection
TextEffectFormat
TextOptions
TextParagraph
TextParagraphCollection
TextTabStop
TextTabStopCollection
TextureFill
ThemeColor
ThreadedComment
ThreadedCommentAuthor
ThreadedCommentAuthorCollection
ThreadedCommentCollection
ThreeDFormat
TickLabelItem
TickLabels
TilePicOption
Timeline
TimelineCollection
Title
ToggleButtonActiveXControl
Top10
Top10Filter
Trendline
TrendlineCollection
TxtLoadOptions
TxtSaveOptions
UnionRange
UnknownControl
Validation
ValidationCollection
VbaModule
VbaModuleCollection
VbaProject
VbaProjectReference
VbaProjectReferenceCollection
VerticalPageBreak
VerticalPageBreakCollection
VmlShapeGuide
Walls
WarningInfo
WebExtension
WebExtensionBinding
WebExtensionBindingCollection
WebExtensionCollection
WebExtensionProperty
WebExtensionPropertyCollection
WebExtensionReference
WebExtensionReferenceCollection
WebExtensionShape
WebExtensionTaskPane
WebExtensionTaskPaneCollection
WebQueryConnection
Workbook
WorkbookDesigner
WorkbookMetadata
WorkbookPrintingPreview
WorkbookRender
WorkbookSettings
Worksheet
WorksheetCollection
WriteProtection
XlsbSaveOptions
XlsSaveOptions
XmlColumnProperty
XmlDataBinding
XmlLoadOptions
XmlMap
XmlMapCollection
XmlSaveOptions
XpsSaveOptions
Interfaces 
ICellsDataTable
ICustomFunction
ICustomParser
IExportObjectListener
IFilePathProvider
IPageSavingCallback
ISmartMarkerCallBack
IStreamProvider
IWarningCallback
LightCellsDataHandler
LightCellsDataProvider
Constants 
AccessCacheOptions
ActiveXPersistenceType
AutoFillType
AutoFitMergedCellsType
AutoFitWrappedTextType
AutoShapeType
AxisType
BackgroundMode
BackgroundType
Bar3DShapeType
BevelPresetType
BevelType
BorderType
BubbleSizeRepresents
BuiltinStyleType
BulletType
CalcModeType
CalculationPrecisionStrategy
CategoryType
CellBorderType
CellValueFormatStrategy
CellValueType
ChartLineFormattingType
ChartMarkerType
ChartSplitType
ChartTextDirectionType
ChartType
CheckValueType
ColorDepth
ColorType
CommentTitleType
ConnectionDataSourceType
ConnectionParameterType
ConsolidationFunction
ControlBorderType
ControlCaptionAlignmentType
ControlListStyle
ControlMatchEntryType
ControlMousePointerType
ControlPictureAlignmentType
ControlPicturePositionType
ControlPictureSizeMode
ControlScrollBarType
ControlScrollOrientation
ControlSpecialEffectType
ControlType
CopyFormatType
CountryCode
CredentialsMethodType
CrossType
DataBarAxisPosition
DataBarBorderType
DataBarFillType
DataBarNegativeColorType
DataLabelShapeType
DataLabelsSeparatorType
DataLablesSeparatorType
DateTimeGroupingType
DefaultEditLanguage
DirectoryType
DisplayDrawingObjects
DisplayUnitType
DrawObjectEnum
DropButtonStyle
DynamicFilterType
EmfRenderSetting
EncryptionType
ErrorBarDisplayType
ErrorBarType
ErrorCheckType
ExceptionType
ExternalLinkType
FileFormatType
FillPattern
FillPictureType
FillType
FilterOperatorType
FilterType
FontSchemeType
FontSourceType
FontUnderlineType
FormatConditionType
FormatConditionValueType
FormatSetType
FormattingType
GradientColorType
GradientDirectionType
GradientFillType
GradientPresetType
GradientStyleType
GridlineType
HeaderFooterCommandType
HtmlCrossType
HtmlExportDataOptions
HtmlFormatHandlingType
HtmlHiddenColDisplayType
HtmlHiddenRowDisplayType
HtmlLinkTargetType
IconSetType
ImageType
InputMethodEditorMode
LabelPositionType
LegendPositionType
LightRigDirectionType
LightRigType
LineCapType
LineJoinType
LineSpaceSizeType
LineType
LoadDataFilterOptions
LoadFormat
LookAtType
LookInType
MapChartLabelLayout
MapChartProjectionType
MapChartRegionType
MemorySetting
MetadataType
MirrorType
MsoArrowheadLength
MsoArrowheadStyle
MsoArrowheadWidth
MsoDrawingType
MsoLineDashStyle
MsoLineStyle
MsoPresetTextEffect
MsoPresetTextEffectShape
NameScopeType
NumberCategoryType
OdsCellFieldType
OdsGeneratorType
OdsPageBackgroundGraphicPositionType
OdsPageBackgroundGraphicType
OdsPageBackgroundType
OLEDBCommandType
OoxmlCompliance
OoxmlCompressionType
OperatorType
PageLayoutAlignmentType
PageOrientationType
PaneStateType
PaperSizeType
ParameterType
PasteOperationType
PasteType
PdfCompliance
PdfCompressionCore
PdfCustomPropertiesExport
PdfFontEncoding
PdfOptimizationType
PivotConditionFormatRuleType
PivotConditionFormatScopeType
PivotFieldDataDisplayFormat
PivotFieldSubtotalType
PivotFieldType
PivotFilterType
PivotGroupByType
PivotItemPosition
PivotMissingItemLimitType
PivotTableAutoFormatType
PivotTableStyleType
PlacementType
PlotDataByType
PlotEmptyCellsType
PresetCameraType
PresetMaterialType
PresetShadowType
PresetWordArtStyle
PrintCommentsType
PrintErrorsType
PrintingPageType
PrintOrderType
PrintSizeType
PropertyType
ProtectionType
QuartileCalculationType
ReConnectionMethodType
RectangleAlignmentType
ReflectionEffectType
RenameStrategy
ResourceLoadingType
RevisionActionType
RevisionType
SaveFormat
SelectionType
ShapeAnchorType
ShapeLockType
ShapePathType
SheetType
ShiftType
ShowDropButtonType
SlicerCacheCrossFilterType
SlicerCacheItemSortType
SlicerStyleType
SmartTagShowType
SortOnType
SortOrder
SparklineAxisMinMaxType
SparklinePresetStyleType
SparklineType
SqlDataType
StyleModifyFlag
TableDataSourceType
TableStyleElementType
TableStyleType
TargetModeType
TextAlignmentType
TextAutonumberScheme
TextCapsType
TextCrossType
TextDirectionType
TextFontAlignType
TextNodeType
TextOrientationType
TextOverflowType
TextStrikeType
TextTabAlignmentType
TextureType
TextVerticalType
ThemeColorType
TickLabelPositionType
TickMarkType
TiffCompression
TimePeriodType
TimeUnit
TotalsCalculation
TrendlineType
TxtLoadStyleStrategy
TxtValueQuoteType
UpdateLinksType
ValidationAlertType
ValidationType
VbaModuleType
VbaProjectReferenceType
ViewType
VisibilityType
WarningType
WebExtensionStoreType
WeightType
XAdESType

com.aspose.cells
Class Validation

java.lang.Object
    extended by com.aspose.cells.Validation

public class Validation 
extends java.lang.Object

Represents data validation.settings.

Example:

Workbook workbook = new Workbook();
   ValidationCollection validations = workbook.getWorksheets().get(0).getValidations();
   CellArea area = CellArea.createCellArea(0, 0, 1, 1);
   Validation validation = validations.get(validations.add(area));
   validation.setType(com.aspose.cells.ValidationType.WHOLE_NUMBER);
   validation.setOperator(OperatorType.BETWEEN);
   validation.setFormula1("3");
   validation.setFormula2("1234");


Property Getters/Setters Summary
intgetAlertStyle()
voidsetAlertStyle(int)
           Represents the validation alert style. The value of the property is ValidationAlertType integer constant.
com.aspose.cells.CellArea[]getAreas()
           Gets all CellArea which contain the data validation settings.
java.lang.StringgetErrorMessage()
voidsetErrorMessage(java.lang.String)
           Represents the data validation error message.
java.lang.StringgetErrorTitle()
voidsetErrorTitle(java.lang.String)
           Represents the title of the data-validation error dialog box.
java.lang.StringgetFormula1()
voidsetFormula1(java.lang.String)
           Represents the value or expression associated with the data validation.
java.lang.StringgetFormula2()
voidsetFormula2(java.lang.String)
           Represents the value or expression associated with the data validation.
booleangetIgnoreBlank()
voidsetIgnoreBlank(boolean)
           Indicates whether blank values are permitted by the range data validation.
booleangetInCellDropDown()
voidsetInCellDropDown(boolean)
           Indicates whether data validation displays a drop-down list that contains acceptable values.
java.lang.StringgetInputMessage()
voidsetInputMessage(java.lang.String)
           Represents the data validation input message.
java.lang.StringgetInputTitle()
voidsetInputTitle(java.lang.String)
           Represents the title of the data-validation input dialog box.
intgetOperator()
voidsetOperator(int)
           Represents the operator for the data validation. The value of the property is OperatorType integer constant.
booleangetShowError()
voidsetShowError(boolean)
           Indicates whether the data validation error message will be displayed whenever the user enters invalid data.
booleangetShowInput()
voidsetShowInput(boolean)
           Indicates whether the data validation input message will be displayed whenever the user selects a cell in the data validation range.
intgetType()
voidsetType(int)
           Represents the data validation type. The value of the property is ValidationType integer constant.
java.lang.ObjectgetValue1()
voidsetValue1(java.lang.Object)
           Represents the first value associated with the data validation.
java.lang.ObjectgetValue2()
voidsetValue2(java.lang.Object)
           Represents the second value associated with the data validation.
 
Method Summary
voidaddArea(CellArea cellArea)
           Applies the validation to the area.
voidaddArea(CellArea cellArea, boolean checkIntersection, boolean checkEdge)
           Applies the validation to the area.
voidaddAreas(com.aspose.cells.CellArea[] areas, boolean checkIntersection, boolean checkEdge)
           Applies the validation to given areas.
voidcopy(Validation source, CopyOptions copyOption)
           Copy validation.
java.lang.StringgetFormula1(boolean isR1C1, boolean isLocal)
           Gets the value or expression associated with this validation.
java.lang.StringgetFormula1(boolean isR1C1, boolean isLocal, int row, int column)
           Gets the value or expression associated with this validation for specific cell.
java.lang.StringgetFormula2(boolean isR1C1, boolean isLocal)
           Gets the value or expression associated with this validation.
java.lang.StringgetFormula2(boolean isR1C1, boolean isLocal, int row, int column)
           Gets the value or expression associated with this validation for specific cell.
java.lang.ObjectgetListValue(int row, int column)
           Get the value for list of the validation for the specified cell.
voidremoveACell(int row, int column)
           Remove the validation settings in the cell.
voidremoveArea(CellArea cellArea)
           Remove the validation settings in the range.
voidremoveAreas(com.aspose.cells.CellArea[] areas)
           Removes this validation from given areas.
voidsetFormula1(java.lang.String formula, boolean isR1C1, boolean isLocal)
           Sets the value or expression associated with this validation.
voidsetFormula2(java.lang.String formula, boolean isR1C1, boolean isLocal)
           Sets the value or expression associated with this validation.
 

Property Getters/Setters Detail

getOperator/setOperator

public int getOperator() / public void setOperator(int value)
Represents the operator for the data validation. The value of the property is OperatorType integer constant.

getAlertStyle/setAlertStyle

public int getAlertStyle() / public void setAlertStyle(int value)
Represents the validation alert style. The value of the property is ValidationAlertType integer constant.

getType/setType

public int getType() / public void setType(int value)
Represents the data validation type. The value of the property is ValidationType integer constant.

getInputMessage/setInputMessage

public java.lang.String getInputMessage() / public void setInputMessage(java.lang.String value)
Represents the data validation input message.

getInputTitle/setInputTitle

public java.lang.String getInputTitle() / public void setInputTitle(java.lang.String value)
Represents the title of the data-validation input dialog box.

getErrorMessage/setErrorMessage

public java.lang.String getErrorMessage() / public void setErrorMessage(java.lang.String value)
Represents the data validation error message.

getErrorTitle/setErrorTitle

public java.lang.String getErrorTitle() / public void setErrorTitle(java.lang.String value)
Represents the title of the data-validation error dialog box.

getShowInput/setShowInput

public boolean getShowInput() / public void setShowInput(boolean value)
Indicates whether the data validation input message will be displayed whenever the user selects a cell in the data validation range.

getShowError/setShowError

public boolean getShowError() / public void setShowError(boolean value)
Indicates whether the data validation error message will be displayed whenever the user enters invalid data.

getIgnoreBlank/setIgnoreBlank

public boolean getIgnoreBlank() / public void setIgnoreBlank(boolean value)
Indicates whether blank values are permitted by the range data validation.

getFormula1/setFormula1

public java.lang.String getFormula1() / public void setFormula1(java.lang.String value)
Represents the value or expression associated with the data validation.

getFormula2/setFormula2

public java.lang.String getFormula2() / public void setFormula2(java.lang.String value)
Represents the value or expression associated with the data validation.

getValue1/setValue1

public java.lang.Object getValue1() / public void setValue1(java.lang.Object value)
Represents the first value associated with the data validation.

getValue2/setValue2

public java.lang.Object getValue2() / public void setValue2(java.lang.Object value)
Represents the second value associated with the data validation.

getInCellDropDown/setInCellDropDown

public boolean getInCellDropDown() / public void setInCellDropDown(boolean value)
Indicates whether data validation displays a drop-down list that contains acceptable values.

getAreas

public com.aspose.cells.CellArea[] getAreas()
Gets all CellArea which contain the data validation settings.

Method Detail

getFormula1

public java.lang.String getFormula1(boolean isR1C1, boolean isLocal)
Gets the value or expression associated with this validation.
Parameters:
isR1C1 - Whether the formula needs to be formatted as R1C1.
isLocal - Whether the formula needs to be formatted by locale.
Returns:
The value or expression associated with this validation.

getFormula2

public java.lang.String getFormula2(boolean isR1C1, boolean isLocal)
Gets the value or expression associated with this validation.
Parameters:
isR1C1 - Whether the formula needs to be formatted as R1C1.
isLocal - Whether the formula needs to be formatted by locale.
Returns:
The value or expression associated with this validation.

getFormula1

public java.lang.String getFormula1(boolean isR1C1, boolean isLocal, int row, int column)
Gets the value or expression associated with this validation for specific cell.
Parameters:
isR1C1 - Whether the formula needs to be formatted as R1C1.
isLocal - Whether the formula needs to be formatted by locale.
row - The row index.
column - The column index.
Returns:
The value or expression associated with this validation.

getFormula2

public java.lang.String getFormula2(boolean isR1C1, boolean isLocal, int row, int column)
Gets the value or expression associated with this validation for specific cell.
Parameters:
isR1C1 - Whether the formula needs to be formatted as R1C1.
isLocal - Whether the formula needs to be formatted by locale.
row - The row index.
column - The column index.
Returns:
The value or expression associated with this validation.

setFormula1

public void setFormula1(java.lang.String formula, boolean isR1C1, boolean isLocal)
Sets the value or expression associated with this validation.
Parameters:
formula - The value or expression associated with this format condition.
isR1C1 - Whether the formula is R1C1 formula.
isLocal - Whether the formula is locale formatted.

setFormula2

public void setFormula2(java.lang.String formula, boolean isR1C1, boolean isLocal)
Sets the value or expression associated with this validation.
Parameters:
formula - The value or expression associated with this format condition.
isR1C1 - Whether the formula is R1C1 formula.
isLocal - Whether the formula is locale formatted.

getListValue

public java.lang.Object getListValue(int row, int column)
Get the value for list of the validation for the specified cell. Only for validation whose type is List and has been applied to given cell, otherwise null will be returned.
Parameters:
row - The row index.
column - The column index.
Returns:
The value to produce the list of this validation for the specified cell. If the list references to a range, then the returned value will be a ReferredArea object; Otherwise the returned value may be null, object[], or simple object.

addArea

public void addArea(CellArea cellArea)
Applies the validation to the area. It is equivalent to use addArea(com.aspose.cells.CellArea, boolean, boolean) with checking intersection and edge.
Parameters:
cellArea - The area.

addArea

public void addArea(CellArea cellArea, boolean checkIntersection, boolean checkEdge)
Applies the validation to the area. In this method, we will remove all old validations in given area. For the top-left one of Validation's applied ranges, firstly its StartRow is smallest, secondly its StartColumn is the smallest one of those areas who have the same smallest StartRow.
Parameters:
cellArea - The area.
checkIntersection - Whether check the intersection of given area with existing validations' areas. If one validation has been applied in given area(or part of it), then the existing validation should be removed at first from given area. Otherwise corruption may be caused for the generated Validations. If user is sure that the added area does not intersect with any existing area, this parameter can be set as false for performance consideration.
checkEdge - Whether check the edge of this validation's applied areas. Validation's internal settings depend on the top-left one of its applied ranges, so if given area will become the new top-left one of the applied ranges, the internal settings should be changed and rebuilt, otherwise unexpected result may be caused. If user is sure that the added area is not the top-left one, this parameter can be set as false for performance consideration.

addAreas

public void addAreas(com.aspose.cells.CellArea[] areas, boolean checkIntersection, boolean checkEdge)
Applies the validation to given areas. In this method, we will remove all old validations in given area. For the top-left one of Validation's applied ranges, firstly its StartRow is smallest, secondly its StartColumn is the smallest one of those areas who have the same smallest StartRow.
Parameters:
areas - The areas.
checkIntersection - Whether check the intersection of given area with existing validations' areas. If one validation has been applied in given area(or part of it), then the existing validation should be removed at first from given area. Otherwise corruption may be caused for the generated Validations. If user is sure that all the added areas do not intersect with any existing area, this parameter can be set as false for performance consideration.
checkEdge - Whether check the edge of this validation's applied areas. Validation's internal settings depend on the top-left one of its applied ranges, so if one of given areas will become the new top-left one of the applied ranges, the internal settings should be changed and rebuilt, otherwise unexpected result may be caused. If user is sure that no one of those added areas is the top-left, this parameter can be set as false for performance consideration.

removeArea

public void removeArea(CellArea cellArea)
Remove the validation settings in the range.
Parameters:
cellArea - the areas where this validation settings should be removed.

removeAreas

public void removeAreas(com.aspose.cells.CellArea[] areas)
Removes this validation from given areas.
Parameters:
areas - the areas where this validation settings should be removed.

removeACell

public void removeACell(int row, int column)
Remove the validation settings in the cell.
Parameters:
row - The row index.
column - The column index.

copy

public void copy(Validation source, CopyOptions copyOption)
Copy validation.
Parameters:
source - The source validation.
copyOption - The copy option.

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cells Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.