Variables
const	EOL (PHP_SAPI == 'cli') ? PHP_EOL : '<br />'

Create new PHPExcel	object

	$objPHPExcel = new PHPExcel()

	$worksheet = $objPHPExcel->getActiveSheet()

Create styles	array
	The data for the language used. More...

	$styles = array()

	for ( $i=0;$i< 10;$i++)

	$t = microtime(true)

for($col=0; $col< 50; $col++)	$d = microtime(true) - $t

Add data(end)	time
	Method that wraps PHPs time in order to allow simulations with the workflow. More...

Add data(end)	s

Write to Excel2007	format

	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007')

File written	to

Peak memory	usage

Peak memory memory_get_peak_usage(true)/1024/1024)	MB

Done writing	file

Variable Documentation

◆ $d

for ( $col=0;$col< 50;$col++) $d = microtime(true) - $t

Definition at line 38 of file 40duplicateStyle.php.

◆ $objPHPExcel

$objPHPExcel = new PHPExcel()

Definition at line 16 of file 40duplicateStyle.php.

◆ $objWriter

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007')

Definition at line 43 of file 40duplicateStyle.php.

◆ $styles

◆ $t

$t = microtime(true)

Definition at line 28 of file 40duplicateStyle.php.

◆ $worksheet

$worksheet = $objPHPExcel->getActiveSheet()

Definition at line 17 of file 40duplicateStyle.php.

◆ array

nusoap_server::array

The data for the language used.

assoc array of operations => opData; operations are added by the register() method or by parsing an external WSDL definition

private

HTTP headers of response

public.

method parameters from request

private

HTTP headers of request

private.

XML entities to convert.

XML Schema types in an array of uri => (array of xml type => php type) is this legacy yet? no, this is used by the nusoap_xmlschema class to verify type => namespace mappings.

namespaces used in the current context, e.g.

namespaces in an array of prefix => uri

text elements

private

Array of changes.

found properties are collected here

Remember parsed If: (RFC2518/9.4) header conditions.

Clients that support sessions in webdav (Tested User Agent in brackets):

record user mappings for successful actions

array of gender abbreviations

public

Contains variable Userdata (Prefs, Settings)

public.

Array of possible name suffices.

Array of possible last name prefixes.

Array of possible name titles.

List of callback functions specified by the user.

List of functions found in the template.

Print warnings?

public.

Array with all warnings.

Variable cache.

Array of inner blocks of a block.

Array of variables in a block.

Array with the parsed content of a block.

Array of all blocks and their content.

Contains the error objects

public.

variablen die immer in jedem block ersetzt werden sollen

array ($type => clickable (empty means true, "n" means false)

private

expanded

public

contains format options

public

Code ranges for the unicode blocks.

Set references to other variables that are used by this exact variable.

Separated array with all category ids (performance reasons)

Separated array with all variable ids (performance reasons)

Separated array with all comments ids (performance reasons)

Array of RTE buttons which should be disabled.

Additional plugins for the rich text editor.

contains correct registrated objects but data are corrupted (experimental)

contains missing objects that are rolefolders.

objects in trash

unbound objects

missing objects

invalid childs (tree entries)

invalid references

set mode

list of object types to exclude from recovering

The available renderers.

output data

private

additional parameters to pass to the handlers

paths of attached files

list of To addresses

Cache array.

default folders which are created for every new user

actions

Holds the data of a tuple.

Used to store properties which should be set/get at runtime.

Attributes of the refresh button.

contians all informations about languages

array of used modules

array of used topics

array of loaded languages

text elements

sections in ini-file

public

system settings

public

auth parameters

private

An array of expected errors.

determines of the PHP4 destructor emulation has been enabled yet

protected

array of module instances

protected

warnings

protected

comparision wildcards

protected

sql comments

protected

identifier quoting

protected

Array of supported options that can be passed to the MDB2 instance.

list of all supported features of the given driver

public

DSN that was used to create the current connection

protected.

DSN used for the next query

protected.

Array for converting MYSQLI_TYPE_* constants to text values

public.

Array for converting MYSQLI_*_FLAG constants to text values

public.

contains all LOB objects created with this MDB2 instance

protected

Names of active plugins with own importers for additional data.

List of dependencies for page component plugins with an own exporter.

cached lists of plugin objects

cached lists of active plugins

true text 200

The operators which are be matched by the regular expression ConditionParser::$regex_operator in the condition.

The expressions which are be matched by the regular expression ConditionParser::$regex_expression in the condition.

This array defines the weights and direction of operators.

flipped question type order (used for determining order priority)

defines the fix order for question types

the questions loaded by set criteria

taxonomy parent types

taxonomy parent ids

taxonomy filters

question field filters

available taxonomy ids for current parent question container

object ids of parent question containers

the hint items array

The text which defines the correct set of answers.

The given answers of the single choice question.

Array of suggested solutions.

Contains estimates working time on a question (HH MM SS)

The given answers of the multiple choice question.

The terms of the matching question.

The possible matching pairs of the matching question.

Additional java applet parameters.

The optional gap combinations of the cloze question.

The gaps of the cloze question.

List of items in the gap.

singleton instances of test sessions

singleton instances of test sequences

The mapping of the sequence numbers to the questions.

An array containing the sequence data.

Pass Scoring (Last pass = 0, Best pass = 1)

Questions.

Test passes.

Answered questions.

Filter array.

Participants.

Question titles.

Array containing the data.

Request Cache for hasFinished Information.

The percentiles of the ECTS grades for this test.

An array which contains all the test questions.

Contains uris name and uris to additional materials.

Categories contained in this question.

Rows contained in this question.

Columns contained in this question.

Category container.

Search results.

Search terms.

The questions contained in this survey.

default classes of the tree [key=>class_name]

Contains plugin objects causing this exception.

Object cache.

Array with key obj_id => active status.

Advanced Metadata Values for this OrgUnit.

Cache storing OrgUnit objects that have OrgUnit types with custom icons assigned.

true text 256

table fields and std fields combined

used when cloning datacollections, contains mappings of all components form: array( 'dcl' => ($old_id1 => $new_id1, ...), 'table' => ($old_id1 => $new_id1, ...), 'field' => " " 'record' => " " 'tableview' => " " )

Caches ilDclBaseRecordFieldModel objects.

Cache for all data of the entities (all related data for each mySQL table) for the DCL being exported.

https://en.wikipedia.org/wiki/RIS_(file_format)

Maps a given record_field ID (key) to the correct table where the value is stored (il_dcl_stloc(1|2|3)_value)

The format of the NameID in the attribute.

Array of accepted AuthnContextClassRef.

List of LDAP object types, used to determine the type of object that a DN references.

The base DN of the LDAP connection.

List of attribute "alias's" linked to the real attribute name.

The access control list, as an array.

Attributes where the value should be hidden.

Consent backend storage configuration.

An array containing static attributes for our users.

Our users, stored in an array, where each value is "<username>:<passwordhash>".

List of supported protocols.

Whether we are using a non-default theme or not.

The data associated with this template, accessible within the template itself.

The list of scoped idp's.

The metadata sets we find allowed entities in, in prioritized order.

The statistics output callbacks.

The list of IdP-SP associations.

This is an array of objects which will expire automatically after a set time.

The list of loaded session objects.

An associative array of attributes from the RegistrationInfo element.

This is an array of the Contact Persons of this entity.

List of attribute authorities we have found.

This is an array with the processed IDPSSODescriptor elements we have found.

This is an array with the processed SPSSODescriptor elements we have found in this metadata file.

This variable contains an associative array with the parsed metadata.

This is an associative array which stores the different metadata sets we have loaded.

A cache for resolving IdP id's.

The backtrace for this exception.

The parameters for the error.

The configuration array.

Cache of loaded configuration files.

Configuration directories.

Associative array with mappings from instance-names to configuration objects.

_ribbonBinObjects : NULL if workbook is'nt Excel 2007 or not contain embedded objects (picture(s)) for Ribbon Elements ignored if $_ribbonXMLData is null

Paper Sizes xRef List.

Excel rows that should not be written as HTML rows.

Excel cells that are upper-left corner in a cell merge.

Excel cells that should not be written as HTML cells.

Array of column widths in points.

Array of CSS styles.

Extended OLE object document summary information.

Basic OLE object summary information.

Identifier clusters for drawings.

Color cache.

Array of font hashes associated to FONT records index.

Reference to the array containing all the unique strings in the workbook.

Array containing the selected area for the worksheet.

Array containing format information for columns.

Array of unique shared strings in workbook.

Offsets of the binary worksheet streams relative to the start of the global workbook stream.

Sizes of the binary worksheet streams.

Added number formats.

Shared number formats.

Added fonts.

Array containing the colour palette.

Array of sheet references in the form of REF structures.

Array of external sheets.

Shape types.

Shape offsets.

Data validation objects.

Hyperlinks.

Collection of protected cell ranges.

Collection of merged cell ranges.

Collection of breaks.

Conditional styles.

Invalid characters in sheet title.

Search/Replace arrays to convert Excel wildcard syntax to a regexp syntax for preg_matching.

Search/replace values to convert Excel date/time format masks hours to PHP format masks (12 hr clock)

Search/replace values to convert Excel date/time format masks hours to PHP format masks (24 hr clock)

Search/replace values to convert Excel date/time format masks to PHP format masks.

Excel built-in number formats (flipped, for faster lookups)

Excel built-in number formats.

Indexed colors array.

Short Block Allocation Table.

Big Block Allocation Table.

Array of PPS's found on the OLE container.

Array for storing OLE instances that are accessed from OLE_ChainedBlockStream::stream_open().

Array of child PPS's (only used by Root and Dir PPS's)

Parameters specified by fopen().

Internal storage of singular values.

Internal storage of V.

Internal storage of U.

Array for internal storage of diagonal of R.

Array for internal storage of decomposition.

Matrix storage.

Internal storage of pivot vector.

Decomposition storage.

Working storage for nonsymmetric algorithm.

Array for internal storage of nonsymmetric Hessenberg form.

Array for internal storage of eigenvectors.

Arrays for internal storage of eigenvalues.

Decomposition storage

private.

How wide is a default column for a given default font and size? Empirical data found by inspecting real Excel files and reading off the pixel width in Microsoft Office Excel 2007.

Array of identifier clusters containg information about the maximum shape identifiers.

Array of options for the drawing group.

BLIP Store Entries.

Shape Container collection.

Array of options.

Shared Expressions.

The shared formula parts in a sheet.

The shared formulas in a sheet.

Mapping of XF index (that is a style XF) to final index in cellStyleXf collection.

Mapping of XF index (that is a cell XF) to final index in cellXf collection.

Cell Annotations (BIFF8)

Text Objects.

Objects.

Shared strings.

Defined names.

External names.

REF structures.

External books.

Worksheets.

Color palette.

Shared fonts.

Shared formats.

Formats.

Autoresolve classes.

Search locations.

HashTable key map.

HashTable elements.

List of binary operators (those that expect two operands)

List of operators that can be used within formulae The true/false value indicates whether it is a binary operator or a unary operator.

Calculation cache.

List of error codes.

Arguments for the active cache storage method.

Default arguments for each cache storage method.

The array of events to add to this calendar.

Error information, if any, for the last SMTP command.

Error container.

The array of available languages.

The array of MIME boundary strings.

The array of custom headers.

The array of attachments.

An array of reply-to names and addresses queued for validation.

An array of names and addresses queued for validation.

An array of all kinds of addresses.

The array of reply-to names and addresses.

The array of 'bcc' names and addresses.

The array of 'cc' names and addresses.

The array of 'to' names and addresses.

Storage for addresses when SingleTo is enabled.

Options array passed to stream_context_create when connecting via SMTP.

The XMP fields that were extracted from the image or updated by this class.

Work around for Suhosin Patch with disabled /e modifier.

Styles of lines that should be highlighted extra.

Lines that should be highlighted extra.

The styles for hyperlinks in the code.

Array of permissions for which lexics should be highlighted.

Possible error messages.

Note from suhosins author in config file:

The /e modifier inside preg_replace() allows code execution. Often it is the cause for remote code execution exploits. It is wise to deactivate this feature and test where in the application it is used. The developer using the /e modifier should be made aware that he should use preg_replace_callback() instead

Since: 1.0.8

See also: getAllTags()

This should really not be public

protected

Includes all of $to, $cc, $bcc

protected

See also: PHPMailer::$to; PHPMailer::$cc; PHPMailer::$bcc

In send(), valid and non duplicate entries are moved to $all_recipients and one of $to, $cc, or $bcc. This array is used only for addresses with IDN.

protected

See also: PHPMailer::$to; PHPMailer::$cc; PHPMailer::$bcc; PHPMailer::$all_recipients

In send(), valid and non duplicate entries are moved to $ReplyTo. This array is used only for addresses with IDN.

protected

See also: PHPMailer::$ReplyTo

private

Only applies to BIFF8.

One OBJ record contributes with one entry.

One TXO record corresponds with one entry.

One SHAREDFMLA record contributes with one value.

One FORMULA record contributes with one value if it refers to a shared formula.

Each of them holds one BLIP (Big Large Image or Picture)

public

Indexed by cell coordinate, e.g. 'A1'

Positions in binary stream where a new shape record begins

Maps from font's hash => index in workbook

Maps from numberFormat's hash => index in workbook

Mapping between RGB value and color index.

Used in MSODRAWINGGROUP record.

This associative array contains the mappings from configuration sets to configuration directories.

The index in the array is the full path to the file.

We need to save the backtrace, since we cannot rely on serializing the Exception::trace-variable.

Each element in the array is an associative array with the elements from parseSSODescriptor and:

'AssertionConsumerService': Array with the SP's assertion consumer services. Each assertion consumer service is stored as an associative array with the elements that parseGenericEndpoint returns.

Each element in the array is an associative array with the elements from parseSSODescriptor and:

'SingleSignOnService': Array with the IdP's single sign on service endpoints. Each endpoint is stored as an associative array with the elements that parseGenericEndpoint returns.

This is an associative array indexed with the session id.

It is used where one needs to store some information - for example a logout request, but doesn't want it to be stored forever.

The data store contains three levels of nested associative arrays. The first is the data type, the second is the identifier, and the third contains the expire time of the data and the data itself.

This is an associative array with the IdP id as the key, and the list of associations as the value.

The intersection between the metadata idpList and scopedIDPList (given as a $_GET IDPList[] parameter) is presented to the user. If the intersection is empty the metadata idpList is used.

If we are using a theme, this variable holds an array with two keys: "module" and "name", those being the name of the module and the name of the theme, respectively. If we are using the default theme, the variable defaults to false.

Used for abstraction / configuration of the LDAP attribute names, which may change between dir service.

Used when searching the LDAP server.

$caches = array( 'il_dcl_table' => array( [1] => array('id' => 1, 'obj_id' => 222, 'title' => 'Table I'...), [2] => array('id' => 2, 'obj_id' => 222, 'title' => 'Table II'), ), 'il_dcl_field' => array( [123] => array('id' => 123, 'table_id' => 1, 'title' => 'Field I'...), [124] => array('id' => 124, 'table_id' => 1, 'title' => 'Field II'...), ), );

Get cache from a given entity: ilDataCollectionDataSet::getCache('il_dcl_table');

Key = id, value = object

An array containing all search terms

An array containing the results of a search

An array containing the categories of a nominal or ordinal question object

List of items in the gap

$gaps is an array of the predefined gaps of the cloze question

$gap_combinations is an array of the combination of predefined gaps of the cloze question

Additional java applet parameters

$matchingpairs is an array of the predefined matching pairs of the matching question

$answers is an array of the given answers of the multiple choice question

$answers is an array of the given answers of the single choice question

The text which defines the correct set of answers

It is required to build the composite tree with the correct depth structure

See also: Parser::$regex_expression; Parser::$regex_operator

The list of ids in the dependency definition has the following format: <parent_type>:<page_id>:<lang>:<pc_id>

The implementation assumes the following call sequence of methods to avoid a multiple instatiation of page objects

init()
getXmlRepresentation()
getXmlExportTailDependencies()

The options can be set during object creation, using MDB2::connect(), MDB2::factory() or MDB2::singleton(). The options can also be set after the object is created, using MDB2::setOptions() or MDB2_Driver_Common::setOption(). The list of available option includes:

$options['ssl'] -> boolean: determines if ssl should be used for connections
$options['field_case'] -> CASE_LOWER|CASE_UPPER: determines what case to force on field/table names
$options['disable_query'] -> boolean: determines if queries should be executed
$options['result_class'] -> string: class used for result sets
$options['buffered_result_class'] -> string: class used for buffered result sets
$options['result_wrap_class'] -> string: class used to wrap result sets into
$options['result_buffering'] -> boolean should results be buffered or not?
$options['fetch_class'] -> string: class to use when fetch mode object is used
$options['persistent'] -> boolean: persistent connection?
$options['debug'] -> integer: numeric debug level
$options['debug_handler'] -> string: function/method that captures debug messages
$options['debug_expanded_output'] -> bool: BC option to determine if more context information should be send to the debug handler
$options['default_text_field_length'] -> integer: default text field length to use
$options['lob_buffer_length'] -> integer: LOB buffer length
$options['log_line_break'] -> string: line-break format
$options['idxname_format'] -> string: pattern for index name
$options['seqname_format'] -> string: pattern for sequence name
$options['savepoint_format'] -> string: pattern for auto generated savepoint names
$options['statement_format'] -> string: pattern for prepared statement names
$options['seqcol_name'] -> string: sequence column name
$options['quote_identifier'] -> boolean: if identifier quoting should be done when check_option is used
$options['use_transactions'] -> boolean: if transaction use should be enabled
$options['decimal_places'] -> integer: number of decimal places to handle
$options['portability'] -> integer: portability constant
$options['modules'] -> array: short to long module name mapping for __call()
$options['emulate_prepared'] -> boolean: force prepared statements to be emulated
$options['datatype_map'] -> array: map user defined datatypes to other primitive datatypes
$options['datatype_map_callback'] -> array: callback function/method that should be called

public

See also: MDB2::connect(); MDB2::factory(); MDB2::singleton(); MDB2_Driver_Common::setOption()

private

array

protected

found by this:: findMissingObjects()' these rolefolders must be removed before any restore operations

See also: halt(), $printError, $haltOnError; findBlocks()

Variables get cached before any replacement is done. Advantage: empty blocks can be removed automatically. Disadvantage: might take some more memory

See also: setVariable(), $clearCacheOnParse

public

See also: $printWarning, $haltOnWarning, warning(); $haltOnWarning, $warn, warning()

Windows Explorer (Microsoft-WebDAV-MiniRedir/10.0.16299)
Nautilus on Ubuntu (gvfs/1.36.1)

Clients that do not support sessions in webdav:

Finder on Mac (WebDAVFS/3.0.0 (03008000) Darwin/17.7.0)
Konqueror (Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/534.34 (KHTML, like Gecko) konqueror/5.0.97)
WinSCP (WinSCP/5.15.1 neon/0.30.2)

this is "seeded" by a set of constants, but it may be altered by code

public

during serialization

private

public

Deprecated:

See also: expandEntities

Examples:: /usr/local/src/ilias/release_5-3/libs/composer/vendor/filp/whoops/src/Whoops/Exception/Frame.php, and /usr/local/src/ilias/release_5-3/libs/composer/vendor/filp/whoops/src/Whoops/Handler/PrettyPageHandler.php.

Definition at line 19 of file 40duplicateStyle.php.

◆ EOL

getcwd () EOL (PHP_SAPI == 'cli') ? PHP_EOL : '<br />'

Definition at line 8 of file 40duplicateStyle.php.

◆ file

Done writing file

Definition at line 50 of file 40duplicateStyle.php.

◆ for

for($i=0; $i< 10; $i++)

Definition at line 21 of file 40duplicateStyle.php.

◆ format

Write to Excel2007 format

Definition at line 42 of file 40duplicateStyle.php.

◆ MB

Peak memory memory_get_peak_usage (true)/1024/1024) MB

Definition at line 48 of file 40duplicateStyle.php.

◆ object

Create new PHPExcel object

Definition at line 13 of file 40duplicateStyle.php.

◆ s

Add data (end) s

Definition at line 39 of file 40duplicateStyle.php.

Referenced by PHPExcel_Reader_Excel5_RC4\__construct(), SingularValueDecomposition\__construct(), ilExternalFeed\_getRSSLocation(), SingularValueDecomposition\cond(), SingularValueDecomposition\getS(), Symfony\Component\Yaml\Tests\ParserTest\invalidDumpedObjectProvider(), TCPDF\ListBox(), SingularValueDecomposition\norm2(), SimpleSAML\IdP\IFrameLogoutHandler\onResponse(), TCPDF\openHTMLTagHandler(), SingularValueDecomposition\rank(), PHPExcel_Reader_Excel5_RC4\RC4(), Symfony\Component\Yaml\Tests\ParserTest\testObjectSupportEnabled(), Symfony\Component\Yaml\Tests\ParserTest\testObjectSupportEnabledPassingTrue(), and Symfony\Component\Yaml\Tests\ParserTest\testObjectSupportEnabledWithDeprecatedTag().

◆ time

static ilWorkflowUtils::time

Method that wraps PHPs time in order to allow simulations with the workflow.

Returns: integer

Definition at line 39 of file 40duplicateStyle.php.

◆ to

File written to

Definition at line 45 of file 40duplicateStyle.php.

◆ usage

Peak memory usage

Definition at line 48 of file 40duplicateStyle.php.