\PHPExcel_Calculation_TextData

PHPExcel_Calculation_TextData

Summary

Methods

Properties

Constants

CHARACTER()
TRIMNONPRINTABLE()
TRIMSPACES()
ASCIICODE()
CONCATENATE()
DOLLAR()
SEARCHSENSITIVE()
SEARCHINSENSITIVE()
FIXEDFORMAT()
LEFT()
MID()
RIGHT()
STRINGLENGTH()
LOWERCASE()
UPPERCASE()
PROPERCASE()
REPLACE()
SUBSTITUTE()
RETURNSTRING()
TEXTFORMAT()

No public properties found

No constants found

No protected methods found

No protected properties found

N/A

_uniord()

$_invalidChars

N/A

File: core/class/PHPExcel/Calculation/TextData.php
Package: PHPExcel\Calculation
Class hierarchy: \PHPExcel_Calculation_TextData
Uses

Properties

$_invalidChars

$_invalidChars

Methods

CHARACTER()

CHARACTER(string  $character) : int

CHARACTER

Parameters

string

$character

Value

Returns

int —

TRIMNONPRINTABLE()

TRIMNONPRINTABLE(mixed  $stringValue = '') : string

TRIMNONPRINTABLE

Parameters

mixed

$stringValue

Value to check

Returns

string —

TRIMSPACES()

TRIMSPACES(mixed  $stringValue = '') : string

TRIMSPACES

Parameters

mixed

$stringValue

Value to check

Returns

string —

ASCIICODE()

ASCIICODE(string  $characters) : int

ASCIICODE

Parameters

string

$characters

Value

Returns

int —

CONCATENATE()

CONCATENATE() : string

CONCATENATE

Returns

string —

DOLLAR()

DOLLAR(float  $value, int  $decimals = 2) : string

DOLLAR

This function converts a number to text using currency format, with the decimals rounded to the specified place. The format used is $#,##0.00_);($#,##0.00)..

Parameters

float	$value	The value to format
int	$decimals	The number of digits to display to the right of the decimal point. If decimals is negative, number is rounded to the left of the decimal point. If you omit decimals, it is assumed to be 2

Returns

string —

SEARCHSENSITIVE()

SEARCHSENSITIVE(string  $needle, string  $haystack, int  $offset = 1) : string

SEARCHSENSITIVE

Parameters

string	$needle	The string to look for
string	$haystack	The string in which to look
int	$offset	Offset within $haystack

Returns

string —

SEARCHINSENSITIVE()

SEARCHINSENSITIVE(string  $needle, string  $haystack, int  $offset = 1) : string

SEARCHINSENSITIVE

Parameters

string	$needle	The string to look for
string	$haystack	The string in which to look
int	$offset	Offset within $haystack

Returns

string —

FIXEDFORMAT()

FIXEDFORMAT(mixed  $value, int  $decimals = 2, bool  $no_commas = FALSE) : bool

FIXEDFORMAT

Parameters

mixed	$value	Value to check
int	$decimals
bool	$no_commas

Returns

bool —

LEFT()

LEFT(string  $value = '', int  $chars = 1) : string

LEFT

Parameters

string	$value	Value
int	$chars	Number of characters

Returns

string —

MID()

MID(string  $value = '', int  $start = 1, int  $chars = null) : string

MID

Parameters

string	$value	Value
int	$start	Start character
int	$chars	Number of characters

Returns

string —

RIGHT()

RIGHT(string  $value = '', int  $chars = 1) : string

RIGHT

Parameters

string	$value	Value
int	$chars	Number of characters

Returns

string —

STRINGLENGTH()

STRINGLENGTH(string  $value = '') : string

STRINGLENGTH

Parameters

string

$value

Value

Returns

string —

LOWERCASE()

LOWERCASE(string  $mixedCaseString) : string

LOWERCASE

Converts a string value to upper case.

Parameters

string

$mixedCaseString

Returns

string —

UPPERCASE()

UPPERCASE(string  $mixedCaseString) : string

UPPERCASE

Converts a string value to upper case.

Parameters

string

$mixedCaseString

Returns

string —

PROPERCASE()

PROPERCASE(string  $mixedCaseString) : string

PROPERCASE

Converts a string value to upper case.

Parameters

string

$mixedCaseString

Returns

string —

REPLACE()

REPLACE(string  $oldText = '', int  $start = 1, int  $chars = null, string  $newText) : string

REPLACE

Parameters

string	$oldText	String to modify
int	$start	Start character
int	$chars	Number of characters
string	$newText	String to replace in defined position

Returns

string —

SUBSTITUTE()

SUBSTITUTE(string  $text = '', string  $fromText = '', string  $toText = '', int  $instance) : string

SUBSTITUTE

Parameters

string	$text	Value
string	$fromText	From Value
string	$toText	To Value
int	$instance	Instance Number

Returns

string —

RETURNSTRING()

RETURNSTRING(mixed  $testValue = '') : bool

RETURNSTRING

Parameters

mixed

$testValue

Value to check

Returns

bool —

TEXTFORMAT()

TEXTFORMAT(mixed  $value, string  $format) : bool

TEXTFORMAT

Parameters

mixed	$value	Value to check
string	$format	Format mask to use

Returns

bool —

_uniord()

_uniord(mixed  $c) : mixed

Parameters

mixed

Returns

mixed —

category	PHPExcel
copyright	Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)