ILIAS
eassessment Revision 61809
|
Static Public Member Functions | |
static | CHARACTER ($character) |
CHARACTER. | |
static | TRIMNONPRINTABLE ($stringValue= '') |
TRIMNONPRINTABLE. | |
static | TRIMSPACES ($stringValue= '') |
TRIMSPACES. | |
static | ASCIICODE ($characters) |
ASCIICODE. | |
static | CONCATENATE () |
CONCATENATE. | |
static | DOLLAR ($value=0, $decimals=2) |
DOLLAR. | |
static | SEARCHSENSITIVE ($needle, $haystack, $offset=1) |
SEARCHSENSITIVE. | |
static | SEARCHINSENSITIVE ($needle, $haystack, $offset=1) |
SEARCHINSENSITIVE. | |
static | FIXEDFORMAT ($value, $decimals=2, $no_commas=false) |
FIXEDFORMAT. | |
static | LEFT ($value= '', $chars=1) |
LEFT. | |
static | MID ($value= '', $start=1, $chars=null) |
MID. | |
static | RIGHT ($value= '', $chars=1) |
RIGHT. | |
static | STRINGLENGTH ($value= '') |
STRINGLENGTH. | |
static | LOWERCASE ($mixedCaseString) |
LOWERCASE. | |
static | UPPERCASE ($mixedCaseString) |
UPPERCASE. | |
static | PROPERCASE ($mixedCaseString) |
PROPERCASE. | |
static | REPLACE ($oldText= '', $start=1, $chars=null, $newText) |
REPLACE. | |
static | SUBSTITUTE ($text= '', $fromText= '', $toText= '', $instance=0) |
SUBSTITUTE. | |
static | RETURNSTRING ($testValue= '') |
RETURNSTRING. | |
static | TEXTFORMAT ($value, $format) |
TEXTFORMAT. |
Static Private Member Functions | |
static | _uniord ($c) |
Static Private Attributes | |
static | $_invalidChars = Null |
Definition at line 46 of file TextData.php.
|
staticprivate |
Definition at line 50 of file TextData.php.
References PHPExcel_Calculation_Functions\VALUE().
Referenced by ASCIICODE().
|
static |
ASCIICODE.
string | $character | Value |
Definition at line 135 of file TextData.php.
References _uniord(), PHPExcel_Calculation_Functions\COMPATIBILITY_OPENOFFICE, PHPExcel_Calculation_Functions\flattenSingleValue(), and PHPExcel_Calculation_Functions\getCompatibilityMode().
|
static |
CHARACTER.
string | $character | Value |
Definition at line 74 of file TextData.php.
References PHPExcel_Calculation_Functions\flattenSingleValue(), and PHPExcel_Calculation_Functions\VALUE().
|
static |
CONCATENATE.
Definition at line 165 of file TextData.php.
References $arg, PHPExcel_Calculation_Functions\COMPATIBILITY_OPENOFFICE, PHPExcel_Calculation_Functions\flattenArray(), and PHPExcel_Calculation_Functions\getCompatibilityMode().
|
static |
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)..
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 |
Definition at line 203 of file TextData.php.
References PHPExcel_Calculation_Functions\flattenSingleValue(), PHPExcel_Calculation_MathTrig\MROUND(), and PHPExcel_Calculation_Functions\NaN().
|
static |
FIXEDFORMAT.
mixed | $value | Value to check |
Definition at line 298 of file TextData.php.
References PHPExcel_Calculation_Functions\flattenSingleValue().
|
static |
LEFT.
string | $value | Value |
int | $chars | Number of characters |
Definition at line 320 of file TextData.php.
References PHPExcel_Calculation_Functions\flattenSingleValue(), and PHPExcel_Calculation_Functions\VALUE().
Referenced by REPLACE().
|
static |
LOWERCASE.
Converts a string value to upper case.
string | $mixedCaseString |
Definition at line 426 of file TextData.php.
References PHPExcel_Calculation_Functions\flattenSingleValue().
|
static |
MID.
string | $value | Value |
int | $start | Start character |
int | $chars | Number of characters |
Definition at line 348 of file TextData.php.
References PHPExcel_Calculation_Functions\flattenSingleValue(), and PHPExcel_Calculation_Functions\VALUE().
|
static |
PROPERCASE.
Converts a string value to upper case.
string | $mixedCaseString |
Definition at line 472 of file TextData.php.
References PHPExcel_Calculation_Functions\flattenSingleValue().
|
static |
REPLACE.
string | $value | Value |
int | $start | Start character |
int | $chars | Number of characters |
Definition at line 495 of file TextData.php.
References PHPExcel_Calculation_Functions\flattenSingleValue(), LEFT(), and RIGHT().
Referenced by SUBSTITUTE().
|
static |
RETURNSTRING.
mixed | $value | Value to check |
Definition at line 561 of file TextData.php.
References PHPExcel_Calculation_Functions\flattenSingleValue().
|
static |
RIGHT.
string | $value | Value |
int | $chars | Number of characters |
Definition at line 376 of file TextData.php.
References PHPExcel_Calculation_Functions\flattenSingleValue(), and PHPExcel_Calculation_Functions\VALUE().
Referenced by REPLACE().
|
static |
SEARCHINSENSITIVE.
string | $needle | The string to look for |
string | $haystack | The string in which to look |
int | $offset | Offset within $haystack |
Definition at line 267 of file TextData.php.
References $pos, PHPExcel_Calculation_Functions\flattenSingleValue(), and PHPExcel_Calculation_Functions\VALUE().
|
static |
SEARCHSENSITIVE.
string | $needle | The string to look for |
string | $haystack | The string in which to look |
int | $offset | Offset within $haystack |
Definition at line 234 of file TextData.php.
References $pos, PHPExcel_Calculation_Functions\flattenSingleValue(), and PHPExcel_Calculation_Functions\VALUE().
|
static |
STRINGLENGTH.
string | $value | Value |
int | $chars | Number of characters |
Definition at line 403 of file TextData.php.
References PHPExcel_Calculation_Functions\flattenSingleValue().
|
static |
SUBSTITUTE.
string | $text | Value |
string | $fromText | From Value |
string | $toText | To Value |
integer | $instance | Instance Number |
Definition at line 517 of file TextData.php.
References $pos, PHPExcel_Calculation_Functions\flattenSingleValue(), and REPLACE().
|
static |
TEXTFORMAT.
mixed | $value | Value to check |
Definition at line 577 of file TextData.php.
References PHPExcel_Calculation_DateTime\DATEVALUE(), PHPExcel_Calculation_Functions\flattenSingleValue(), PHPExcel_Shared_Date\isDateTimeFormatCode(), and PHPExcel_Style_NumberFormat\toFormattedString().
|
static |
TRIMNONPRINTABLE.
mixed | $value | Value to check |
Definition at line 95 of file TextData.php.
References PHPExcel_Calculation_Functions\flattenSingleValue().
|
static |
TRIMSPACES.
mixed | $value | Value to check |
Definition at line 119 of file TextData.php.
References PHPExcel_Calculation_Functions\flattenSingleValue().
|
static |
UPPERCASE.
Converts a string value to upper case.
string | $mixedCaseString |
Definition at line 449 of file TextData.php.
References PHPExcel_Calculation_Functions\flattenSingleValue().
|
staticprivate |
Definition at line 48 of file TextData.php.