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_CalcEngine_CyclicReferenceStack
  • PHPExcel_CalcEngine_Logger
  • PHPExcel_Calculation
  • PHPExcel_Calculation_Database
  • PHPExcel_Calculation_DateTime
  • PHPExcel_Calculation_Engineering
  • PHPExcel_Calculation_ExceptionHandler
  • PHPExcel_Calculation_Financial
  • PHPExcel_Calculation_FormulaParser
  • PHPExcel_Calculation_FormulaToken
  • PHPExcel_Calculation_Function
  • PHPExcel_Calculation_Functions
  • PHPExcel_Calculation_Logical
  • PHPExcel_Calculation_LookupRef
  • PHPExcel_Calculation_MathTrig
  • PHPExcel_Calculation_Statistical
  • PHPExcel_Calculation_TextData
  • PHPExcel_Calculation_Token_Stack

Exceptions

  • PHPExcel_Calculation_Exception

Functions

  • acosh
  • asinh
  • atanh
  • mb_str_replace
  • Overview
  • Package
  • Class
  • Tree
  • Deprecated
  • Todo
  • Download

Class PHPExcel_Calculation_TextData

PHPExcel_Calculation_TextData

Package: PHPExcel\Calculation
Category: PHPExcel
Copyright: Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
License: LGPL
Located at controlador/include/phpexcel/PHPExcel/Calculation/TextData.php
Methods summary
private static
# _uniord( $c )
public static integer
# CHARACTER( string $character )

CHARACTER

CHARACTER

Parameters

$character
Value

Returns

integer
public static string
# TRIMNONPRINTABLE( mixed $stringValue = '' )

TRIMNONPRINTABLE

TRIMNONPRINTABLE

Parameters

$stringValue
Value to check

Returns

string
public static string
# TRIMSPACES( mixed $stringValue = '' )

TRIMSPACES

TRIMSPACES

Parameters

$stringValue
Value to check

Returns

string
public static integer
# ASCIICODE( string $characters )

ASCIICODE

ASCIICODE

Parameters

$characters
Value

Returns

integer
public static string
# CONCATENATE( )

CONCATENATE

CONCATENATE

Returns

string
public static string
# DOLLAR( float $value = 0, integer $decimals = 2 )

DOLLAR

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

$value
The value to format
$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
public static string
# SEARCHSENSITIVE( string $needle, string $haystack, integer $offset = 1 )

SEARCHSENSITIVE

SEARCHSENSITIVE

Parameters

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

Returns

string
public static string
# SEARCHINSENSITIVE( string $needle, string $haystack, integer $offset = 1 )

SEARCHINSENSITIVE

SEARCHINSENSITIVE

Parameters

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

Returns

string
public static boolean
# FIXEDFORMAT( mixed $value, integer $decimals = 2, boolean $no_commas = FALSE )

FIXEDFORMAT

FIXEDFORMAT

Parameters

$value
Value to check
$decimals
$no_commas

Returns

boolean
public static string
# LEFT( string $value = '', integer $chars = 1 )

LEFT

LEFT

Parameters

$value
Value
$chars
Number of characters

Returns

string
public static string
# MID( string $value = '', integer $start = 1, integer $chars = null )

MID

MID

Parameters

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

Returns

string
public static string
# RIGHT( string $value = '', integer $chars = 1 )

RIGHT

RIGHT

Parameters

$value
Value
$chars
Number of characters

Returns

string
public static string
# STRINGLENGTH( string $value = '' )

STRINGLENGTH

STRINGLENGTH

Parameters

$value
Value

Returns

string
public static string
# LOWERCASE( string $mixedCaseString )

LOWERCASE

LOWERCASE

Converts a string value to upper case.

Parameters

$mixedCaseString

Returns

string
public static string
# UPPERCASE( string $mixedCaseString )

UPPERCASE

UPPERCASE

Converts a string value to upper case.

Parameters

$mixedCaseString

Returns

string
public static string
# PROPERCASE( string $mixedCaseString )

PROPERCASE

PROPERCASE

Converts a string value to upper case.

Parameters

$mixedCaseString

Returns

string
public static string
# REPLACE( string $oldText, integer $start, integer $chars, string $newText )

REPLACE

REPLACE

Parameters

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

Returns

string
public static string
# SUBSTITUTE( string $text = '', string $fromText = '', string $toText = '', integer $instance = 0 )

SUBSTITUTE

SUBSTITUTE

Parameters

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

Returns

string
public static boolean
# RETURNSTRING( mixed $testValue = '' )

RETURNSTRING

RETURNSTRING

Parameters

$testValue
Value to check

Returns

boolean
public static boolean
# TEXTFORMAT( mixed $value, string $format )

TEXTFORMAT

TEXTFORMAT

Parameters

$value
Value to check
$format
Format mask to use

Returns

boolean
Properties summary
private static $_invalidChars
# Null
Autene API documentation generated by ApiGen