Overview

Packages

  • JAMA
  • None
  • PHP
  • PHPExcel
    • CachedObjectStorage
    • Calculation
    • Cell
    • Chart
      • Renderer
    • Reader
      • Excel2007
      • Excel5
    • RichText
    • Settings
    • Shared
      • Escher
      • OLE
      • Trend
      • ZipArchive
    • Style
    • Worksheet
      • Drawing
    • Writer
      • 2007
      • CSV
      • Excel2007
      • Excel5
      • HTML
      • PDF

Classes

  • PHPExcel_Cell
  • PHPExcel_Cell_AdvancedValueBinder
  • PHPExcel_Cell_DataType
  • PHPExcel_Cell_DataValidation
  • PHPExcel_Cell_DefaultValueBinder
  • PHPExcel_Cell_Hyperlink

Interfaces

  • PHPExcel_Cell_IValueBinder
  • Overview
  • Package
  • Class
  • Tree
  • Deprecated
  • Todo
  • Download

Class PHPExcel_Cell_DataValidation

PHPExcel_Cell_DataValidation

Package: PHPExcel\Cell
Category: PHPExcel
Copyright: Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
License: LGPL
Located at controlador/include/phpexcel/PHPExcel/Cell/DataValidation.php
Methods summary
public
# __construct( )

Create a new PHPExcel_Cell_DataValidation

Create a new PHPExcel_Cell_DataValidation

public string
# getFormula1( )

Get Formula 1

Get Formula 1

Returns

string
public PHPExcel_Cell_DataValidation
# setFormula1( string $value = '' )

Set Formula 1

Set Formula 1

Parameters

$value

Returns

PHPExcel_Cell_DataValidation
public string
# getFormula2( )

Get Formula 2

Get Formula 2

Returns

string
public PHPExcel_Cell_DataValidation
# setFormula2( string $value = '' )

Set Formula 2

Set Formula 2

Parameters

$value

Returns

PHPExcel_Cell_DataValidation
public string
# getType( )

Get Type

Get Type

Returns

string
public PHPExcel_Cell_DataValidation
# setType( string $value = PHPExcel_Cell_DataValidation::TYPE_NONE )

Set Type

Set Type

Parameters

$value

Returns

PHPExcel_Cell_DataValidation
public string
# getErrorStyle( )

Get Error style

Get Error style

Returns

string
public PHPExcel_Cell_DataValidation
# setErrorStyle( string $value = PHPExcel_Cell_DataValidation::STYLE_STOP )

Set Error style

Set Error style

Parameters

$value

Returns

PHPExcel_Cell_DataValidation
public string
# getOperator( )

Get Operator

Get Operator

Returns

string
public PHPExcel_Cell_DataValidation
# setOperator( string $value = '' )

Set Operator

Set Operator

Parameters

$value

Returns

PHPExcel_Cell_DataValidation
public boolean
# getAllowBlank( )

Get Allow Blank

Get Allow Blank

Returns

boolean
public PHPExcel_Cell_DataValidation
# setAllowBlank( boolean $value = false )

Set Allow Blank

Set Allow Blank

Parameters

$value

Returns

PHPExcel_Cell_DataValidation
public boolean
# getShowDropDown( )

Get Show DropDown

Get Show DropDown

Returns

boolean
public PHPExcel_Cell_DataValidation
# setShowDropDown( boolean $value = false )

Set Show DropDown

Set Show DropDown

Parameters

$value

Returns

PHPExcel_Cell_DataValidation
public boolean
# getShowInputMessage( )

Get Show InputMessage

Get Show InputMessage

Returns

boolean
public PHPExcel_Cell_DataValidation
# setShowInputMessage( boolean $value = false )

Set Show InputMessage

Set Show InputMessage

Parameters

$value

Returns

PHPExcel_Cell_DataValidation
public boolean
# getShowErrorMessage( )

Get Show ErrorMessage

Get Show ErrorMessage

Returns

boolean
public PHPExcel_Cell_DataValidation
# setShowErrorMessage( boolean $value = false )

Set Show ErrorMessage

Set Show ErrorMessage

Parameters

$value

Returns

PHPExcel_Cell_DataValidation
public string
# getErrorTitle( )

Get Error title

Get Error title

Returns

string
public PHPExcel_Cell_DataValidation
# setErrorTitle( string $value = '' )

Set Error title

Set Error title

Parameters

$value

Returns

PHPExcel_Cell_DataValidation
public string
# getError( )

Get Error

Get Error

Returns

string
public PHPExcel_Cell_DataValidation
# setError( string $value = '' )

Set Error

Set Error

Parameters

$value

Returns

PHPExcel_Cell_DataValidation
public string
# getPromptTitle( )

Get Prompt title

Get Prompt title

Returns

string
public PHPExcel_Cell_DataValidation
# setPromptTitle( string $value = '' )

Set Prompt title

Set Prompt title

Parameters

$value

Returns

PHPExcel_Cell_DataValidation
public string
# getPrompt( )

Get Prompt

Get Prompt

Returns

string
public PHPExcel_Cell_DataValidation
# setPrompt( string $value = '' )

Set Prompt

Set Prompt

Parameters

$value

Returns

PHPExcel_Cell_DataValidation
public string
# getHashCode( )

Get hash code

Get hash code

Returns

string
Hash code
public
# __clone( )

Implement PHP __clone to create a deep clone, not just a shallow copy.

Implement PHP __clone to create a deep clone, not just a shallow copy.

Constants summary
string TYPE_NONE
# 'none'
string TYPE_CUSTOM
# 'custom'
string TYPE_DATE
# 'date'
string TYPE_DECIMAL
# 'decimal'
string TYPE_LIST
# 'list'
string TYPE_TEXTLENGTH
# 'textLength'
string TYPE_TIME
# 'time'
string TYPE_WHOLE
# 'whole'
string STYLE_STOP
# 'stop'
string STYLE_WARNING
# 'warning'
string STYLE_INFORMATION
# 'information'
string OPERATOR_BETWEEN
# 'between'
string OPERATOR_EQUAL
# 'equal'
string OPERATOR_GREATERTHAN
# 'greaterThan'
string OPERATOR_GREATERTHANOREQUAL
# 'greaterThanOrEqual'
string OPERATOR_LESSTHAN
# 'lessThan'
string OPERATOR_LESSTHANOREQUAL
# 'lessThanOrEqual'
string OPERATOR_NOTBETWEEN
# 'notBetween'
string OPERATOR_NOTEQUAL
# 'notEqual'
Properties summary
private string $_formula1

Formula 1

Formula 1

#
private string $_formula2

Formula 2

Formula 2

#
private string $_type

Type

Type

# PHPExcel_Cell_DataValidation::TYPE_NONE
private string $_errorStyle

Error style

Error style

# PHPExcel_Cell_DataValidation::STYLE_STOP
private string $_operator

Operator

Operator

#
private boolean $_allowBlank

Allow Blank

Allow Blank

#
private boolean $_showDropDown

Show DropDown

Show DropDown

#
private boolean $_showInputMessage

Show InputMessage

Show InputMessage

#
private boolean $_showErrorMessage

Show ErrorMessage

Show ErrorMessage

#
private string $_errorTitle

Error title

Error title

#
private string $_error

Error

Error

#
private string $_promptTitle

Prompt title

Prompt title

#
private string $_prompt

Prompt

Prompt

#
Autene API documentation generated by ApiGen