PhpOffice\PhpSpreadsheet\Reader\Gnumeric Class Reference

Inheritance diagram for PhpOffice\PhpSpreadsheet\Reader\Gnumeric:

Collaboration diagram for PhpOffice\PhpSpreadsheet\Reader\Gnumeric:

Public Member Functions
	__construct ()
	Create a new Gnumeric. More...
	canRead ($pFilename)
	Can the current IReader read the file? More...
	listWorksheetNames ($pFilename)
	Reads names of the worksheets from a file, without parsing the whole file to a Spreadsheet object. More...
	listWorksheetInfo ($pFilename)
	Return worksheet info (Name, Last Column Letter, Last Column Index, Total Rows, Total Columns). More...
	load ($pFilename)
	Loads Spreadsheet from file. More...
	loadIntoExisting (string $pFilename, Spreadsheet $spreadsheet)
	Loads from file into Spreadsheet instance. More...
Public Member Functions inherited from PhpOffice\PhpSpreadsheet\Reader\BaseReader
	__construct ()
	IReader constructor. More...
	getReadDataOnly ()
	Read data only? If this is true, then the Reader will only read data values for cells, it will not read any formatting information. More...
	setReadDataOnly ($pValue)
	Set read data only Set to true, to advise the Reader only to read data values for cells, and to ignore any formatting information. More...
	getReadEmptyCells ()
	Read empty cells? If this is true (the default), then the Reader will read data values for all cells, irrespective of value. More...
	setReadEmptyCells ($pValue)
	Set read empty cells Set to true (the default) to advise the Reader read data values for all cells, irrespective of value. More...
	getIncludeCharts ()
	Read charts in workbook? If this is true, then the Reader will include any charts that exist in the workbook. More...
	setIncludeCharts ($pValue)
	Set read charts in workbook Set to true, to advise the Reader to include any charts that exist in the workbook. More...
	getLoadSheetsOnly ()
	Get which sheets to load Returns either an array of worksheet names (the list of worksheets that should be loaded), or a null indicating that all worksheets in the workbook should be loaded. More...
	setLoadSheetsOnly ($value)
	Set which sheets to load. More...
	setLoadAllSheets ()
	Set all sheets to load Tells the Reader to load all worksheets from the workbook. More...
	getReadFilter ()
	Read filter. More...
	setReadFilter (IReadFilter $pValue)
	Set read filter. More...
	getSecurityScanner ()
	__construct ()
	IReader constructor. More...
	canRead ($pFilename)
	Can the current IReader read the file? More...
	getReadDataOnly ()
	Read data only? If this is true, then the Reader will only read data values for cells, it will not read any formatting information. More...
	setReadDataOnly ($pValue)
	Set read data only Set to true, to advise the Reader only to read data values for cells, and to ignore any formatting information. More...
	getReadEmptyCells ()
	Read empty cells? If this is true (the default), then the Reader will read data values for all cells, irrespective of value. More...
	setReadEmptyCells ($pValue)
	Set read empty cells Set to true (the default) to advise the Reader read data values for all cells, irrespective of value. More...
	getIncludeCharts ()
	Read charts in workbook? If this is true, then the Reader will include any charts that exist in the workbook. More...
	setIncludeCharts ($pValue)
	Set read charts in workbook Set to true, to advise the Reader to include any charts that exist in the workbook. More...
	getLoadSheetsOnly ()
	Get which sheets to load Returns either an array of worksheet names (the list of worksheets that should be loaded), or a null indicating that all worksheets in the workbook should be loaded. More...
	setLoadSheetsOnly ($value)
	Set which sheets to load. More...
	setLoadAllSheets ()
	Set all sheets to load Tells the Reader to load all worksheets from the workbook. More...
	getReadFilter ()
	Read filter. More...
	setReadFilter (IReadFilter $pValue)
	Set read filter. More...
	load ($pFilename)
	Loads PhpSpreadsheet from file. More...

Static Public Member Functions
static	gnumericMappings ()

Data Fields
const	NAMESPACE_GNM = 'http://www.gnumeric.org/v10.dtd'
const	NAMESPACE_XSI = 'http://www.w3.org/2001/XMLSchema-instance'
const	NAMESPACE_OFFICE = 'urn:oasis:names:tc:opendocument:xmlns:office:1.0'
const	NAMESPACE_XLINK = 'http://www.w3.org/1999/xlink'
const	NAMESPACE_DC = 'http://purl.org/dc/elements/1.1/'
const	NAMESPACE_META = 'urn:oasis:names:tc:opendocument:xmlns:meta:1.0'
const	NAMESPACE_OOO = 'http://openoffice.org/2004/office'

Static Public Attributes
static	$mappings

Private Member Functions
	gzfileGetContents ($filename)
	processComments (SimpleXMLElement $sheet)
	processMergedCells (?SimpleXMLElement $sheet)
	processAutofilter (?SimpleXMLElement $sheet)
	setColumnWidth (int $whichColumn, float $defaultWidth)
	setColumnInvisible (int $whichColumn)
	processColumnLoop (int $whichColumn, int $maxCol, SimpleXMLElement $columnOverride, float $defaultWidth)
	processColumnWidths (?SimpleXMLElement $sheet, int $maxCol)
	setRowHeight (int $whichRow, float $defaultHeight)
	setRowInvisible (int $whichRow)
	processRowLoop (int $whichRow, int $maxRow, SimpleXMLElement $rowOverride, float $defaultHeight)
	processRowHeights (?SimpleXMLElement $sheet, int $maxRow)
	processDefinedNames (?SimpleXMLElement $gnmXML)
	parseRichText (string $is)

Static Private Member Functions
static	matchXml (XMLReader $xml, string $expectedLocalName)
static	testSimpleXml ($value)

Private Attributes
	$expressions = []
	$spreadsheet
	$referenceHelper

Additional Inherited Members
Protected Member Functions inherited from PhpOffice\PhpSpreadsheet\Reader\BaseReader
	openFile ($pFilename)
	Open file for reading. More...
Protected Attributes inherited from PhpOffice\PhpSpreadsheet\Reader\BaseReader
	$readDataOnly = false
	$readEmptyCells = true
	$includeCharts = false
	$loadSheetsOnly
	$readFilter
	$fileHandle
	$securityScanner

Detailed Description

Definition at line 21 of file Gnumeric.php.

Constructor & Destructor Documentation

__construct()

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::__construct

(

)

Create a new Gnumeric.

Reimplemented from PhpOffice\PhpSpreadsheet\Reader\BaseReader.

Definition at line 71 of file Gnumeric.php.

    {
        parent::__construct();
        $this->referenceHelper = ReferenceHelper::getInstance();
        $this->securityScanner = XmlScanner::getInstance($this);
    }

References PhpOffice\PhpSpreadsheet\ReferenceHelper\getInstance(), and PhpOffice\PhpSpreadsheet\Reader\Security\XmlScanner\getInstance().

Here is the call graph for this function:

Member Function Documentation

canRead()

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::canRead

(

$pFilename

)

Can the current IReader read the file?

Parameters

string

$pFilename

Returns

bool

Implements PhpOffice\PhpSpreadsheet\Reader\IReader.

Definition at line 85 of file Gnumeric.php.

    {
        File::assertFile($pFilename);
 
        // Check if gzlib functions are available
        $data = '';
        if (function_exists('gzread')) {
            // Read signature data (first 3 bytes)
            $fh = fopen($pFilename, 'rb');
            if ($fh !== false) {
                $data = fread($fh, 2);
                fclose($fh);
            }
        }
 
        return $data === chr(0x1F) . chr(0x8B);
    }

References $data, and PhpOffice\PhpSpreadsheet\Shared\File\assertFile().

Here is the call graph for this function:

gnumericMappings()

static PhpOffice\PhpSpreadsheet\Reader\Gnumeric::gnumericMappings ( )

static

Definition at line 207 of file Gnumeric.php.

                                             : array
    {
        return array_merge(self::$mappings, Styles::$mappings);
    }

References PhpOffice\PhpSpreadsheet\Reader\Gnumeric\Styles\$mappings.

gzfileGetContents()

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::gzfileGetContents (   $filename )

private

Parameters

string

$filename

Returns

string

Definition at line 193 of file Gnumeric.php.

    {
        $file = @gzopen($filename, 'rb');
        $data = '';
        if ($file !== false) {
            while (!gzeof($file)) {
                $data .= gzread($file, 1024);
            }
            gzclose($file);
        }
 
        return $data;
    }

References $data, and $filename.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\loadIntoExisting().

Here is the caller graph for this function:

listWorksheetInfo()

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::listWorksheetInfo

(

$pFilename

)

Return worksheet info (Name, Last Column Letter, Last Column Index, Total Rows, Total Columns).

Parameters

string

$pFilename

Returns

array

Definition at line 146 of file Gnumeric.php.

    {
        File::assertFile($pFilename);
 
        $xml = new XMLReader();
        $xml->xml($this->securityScanner->scanFile('compress.zlib://' . realpath($pFilename)), null, Settings::getLibXmlLoaderOptions());
        $xml->setParserProperty(2, true);
 
        $worksheetInfo = [];
        while ($xml->read()) {
            if (self::matchXml($xml, 'Sheet')) {
                $tmpInfo = [
                    'worksheetName' => '',
                    'lastColumnLetter' => 'A',
                    'lastColumnIndex' => 0,
                    'totalRows' => 0,
                    'totalColumns' => 0,
                ];
 
                while ($xml->read()) {
                    if (self::matchXml($xml, 'Name')) {
                        $xml->read(); //    Move onto the value node
                        $tmpInfo['worksheetName'] = (string) $xml->value;
                    } elseif (self::matchXml($xml, 'MaxCol')) {
                        $xml->read(); //    Move onto the value node
                        $tmpInfo['lastColumnIndex'] = (int) $xml->value;
                        $tmpInfo['totalColumns'] = (int) $xml->value + 1;
                    } elseif (self::matchXml($xml, 'MaxRow')) {
                        $xml->read(); //    Move onto the value node
                        $tmpInfo['totalRows'] = (int) $xml->value + 1;
 
                        break;
                    }
                }
                $tmpInfo['lastColumnLetter'] = Coordinate::stringFromColumnIndex($tmpInfo['lastColumnIndex'] + 1);
                $worksheetInfo[] = $tmpInfo;
            }
        }
 
        return $worksheetInfo;
    }

References $xml, PhpOffice\PhpSpreadsheet\Shared\File\assertFile(), PhpOffice\PhpSpreadsheet\Settings\getLibXmlLoaderOptions(), and PhpOffice\PhpSpreadsheet\Cell\Coordinate\stringFromColumnIndex().

Here is the call graph for this function:

listWorksheetNames()

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::listWorksheetNames

(

$pFilename

)

Reads names of the worksheets from a file, without parsing the whole file to a Spreadsheet object.

Parameters

string

$pFilename

Returns

array

Definition at line 117 of file Gnumeric.php.

    {
        File::assertFile($pFilename);
 
        $xml = new XMLReader();
        $xml->xml($this->securityScanner->scanFile('compress.zlib://' . realpath($pFilename)), null, Settings::getLibXmlLoaderOptions());
        $xml->setParserProperty(2, true);
 
        $worksheetNames = [];
        while ($xml->read()) {
            if (self::matchXml($xml, 'SheetName')) {
                $xml->read(); //    Move onto the value node
                $worksheetNames[] = (string) $xml->value;
            } elseif (self::matchXml($xml, 'Sheets')) {
                //    break out of the loop once we've got our sheet names rather than parse the entire file
                break;
            }
        }
 
        return $worksheetNames;
    }

References $xml, PhpOffice\PhpSpreadsheet\Shared\File\assertFile(), and PhpOffice\PhpSpreadsheet\Settings\getLibXmlLoaderOptions().

Here is the call graph for this function:

load()

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::load

(

$pFilename

)

Loads Spreadsheet from file.

Parameters

string

$pFilename

Returns

Spreadsheet

Implements PhpOffice\PhpSpreadsheet\Reader\IReader.

Definition at line 242 of file Gnumeric.php.

    {
        // Create new Spreadsheet
        $spreadsheet = new Spreadsheet();
        $spreadsheet->removeSheetByIndex(0);
 
        // Load into this instance
        return $this->loadIntoExisting($pFilename, $spreadsheet);
    }

References PhpOffice\PhpSpreadsheet\Reader\Gnumeric\$spreadsheet, and PhpOffice\PhpSpreadsheet\Reader\Gnumeric\loadIntoExisting().

Here is the call graph for this function:

loadIntoExisting()

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::loadIntoExisting	(	string	$pFilename,
		Spreadsheet	$spreadsheet
	)

Loads from file into Spreadsheet instance.

Definition at line 255 of file Gnumeric.php.

                                                                                 : Spreadsheet
    {
        $this->spreadsheet = $spreadsheet;
        File::assertFile($pFilename);
 
        $gFileData = $this->gzfileGetContents($pFilename);
 
        $xml2 = simplexml_load_string($this->securityScanner->scan($gFileData), 'SimpleXMLElement', Settings::getLibXmlLoaderOptions());
        $xml = self::testSimpleXml($xml2);
 
        $gnmXML = $xml->children(self::NAMESPACE_GNM);
        (new Properties($this->spreadsheet))->readProperties($xml, $gnmXML);
 
        $worksheetID = 0;
        foreach ($gnmXML->Sheets->Sheet as $sheet) {
            $worksheetName = (string) $sheet->Name;
            if ((isset($this->loadSheetsOnly)) && (!in_array($worksheetName, $this->loadSheetsOnly))) {
                continue;
            }
 
            $maxRow = $maxCol = 0;
 
            // Create new Worksheet
            $this->spreadsheet->createSheet();
            $this->spreadsheet->setActiveSheetIndex($worksheetID);
            //    Use false for $updateFormulaCellReferences to prevent adjustment of worksheet references in formula
            //        cells... during the load, all formulae should be correct, and we're simply bringing the worksheet
            //        name in line with the formula, not the reverse
            $this->spreadsheet->getActiveSheet()->setTitle($worksheetName, false, false);
 
            if (!$this->readDataOnly) {
                (new PageSetup($this->spreadsheet))
                    ->printInformation($sheet)
                    ->sheetMargins($sheet);
            }
 
            foreach ($sheet->Cells->Cell as $cell) {
                $cellAttributes = $cell->attributes();
                $row = (int) $cellAttributes->Row + 1;
                $column = (int) $cellAttributes->Col;
 
                if ($row > $maxRow) {
                    $maxRow = $row;
                }
                if ($column > $maxCol) {
                    $maxCol = $column;
                }
 
                $column = Coordinate::stringFromColumnIndex($column + 1);
 
                // Read cell?
                if ($this->getReadFilter() !== null) {
                    if (!$this->getReadFilter()->readCell($column, $row, $worksheetName)) {
                        continue;
                    }
                }
 
                $ValueType = $cellAttributes->ValueType;
                $ExprID = (string) $cellAttributes->ExprID;
                $type = DataType::TYPE_FORMULA;
                if ($ExprID > '') {
                    if (((string) $cell) > '') {
                        $this->expressions[$ExprID] = [
                            'column' => $cellAttributes->Col,
                            'row' => $cellAttributes->Row,
                            'formula' => (string) $cell,
                        ];
                    } else {
                        $expression = $this->expressions[$ExprID];
 
                        $cell = $this->referenceHelper->updateFormulaReferences(
                            $expression['formula'],
                            'A1',
                            $cellAttributes->Col - $expression['column'],
                            $cellAttributes->Row - $expression['row'],
                            $worksheetName
                        );
                    }
                    $type = DataType::TYPE_FORMULA;
                } else {
                    $vtype = (string) $ValueType;
                    if (array_key_exists($vtype, self::$mappings['dataType'])) {
                        $type = self::$mappings['dataType'][$vtype];
                    }
                    if ($vtype === '20') {        //    Boolean
                        $cell = $cell == 'TRUE';
                    }
                }
                $this->spreadsheet->getActiveSheet()->getCell($column . $row)->setValueExplicit((string) $cell, $type);
            }
 
            if ($sheet->Styles !== null) {
                (new Styles($this->spreadsheet, $this->readDataOnly))->read($sheet, $maxRow, $maxCol);
            }
 
            $this->processComments($sheet);
            $this->processColumnWidths($sheet, $maxCol);
            $this->processRowHeights($sheet, $maxRow);
            $this->processMergedCells($sheet);
            $this->processAutofilter($sheet);
 
            ++$worksheetID;
        }
 
        $this->processDefinedNames($gnmXML);
 
        // Return
        return $this->spreadsheet;
    }

References $row, PhpOffice\PhpSpreadsheet\Reader\Gnumeric\$spreadsheet, $type, $xml, PhpOffice\PhpSpreadsheet\Shared\File\assertFile(), PhpOffice\PhpSpreadsheet\Settings\getLibXmlLoaderOptions(), PhpOffice\PhpSpreadsheet\Reader\BaseReader\getReadFilter(), PhpOffice\PhpSpreadsheet\Reader\Gnumeric\gzfileGetContents(), if, PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processAutofilter(), PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processColumnWidths(), PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processComments(), PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processDefinedNames(), PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processMergedCells(), PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processRowHeights(), PhpOffice\PhpSpreadsheet\Cell\Coordinate\stringFromColumnIndex(), PhpOffice\PhpSpreadsheet\Reader\Gnumeric\testSimpleXml(), and PhpOffice\PhpSpreadsheet\Cell\DataType\TYPE_FORMULA.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\load().

Here is the call graph for this function:

Here is the caller graph for this function:

matchXml()

static PhpOffice\PhpSpreadsheet\Reader\Gnumeric::matchXml ( XMLReader  $xml, string  $expectedLocalName  )

staticprivate

Definition at line 103 of file Gnumeric.php.

                                                                               : bool
    {
        return $xml->namespaceURI === self::NAMESPACE_GNM
            && $xml->localName === $expectedLocalName
            && $xml->nodeType === XMLReader::ELEMENT;
    }

References $xml.

parseRichText()

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::parseRichText ( string  $is )

private

Definition at line 533 of file Gnumeric.php.

                                              : RichText
    {
        $value = new RichText();
        $value->createText($is);
 
        return $value;
    }

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processComments().

Here is the caller graph for this function:

processAutofilter()

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::processAutofilter ( ?SimpleXMLElement  $sheet )

private

Definition at line 377 of file Gnumeric.php.

                                                                : void
    {
        if ($sheet !== null && isset($sheet->Filters)) {
            foreach ($sheet->Filters->Filter as $autofilter) {
                if ($autofilter !== null) {
                    $attributes = $autofilter->attributes();
                    if (isset($attributes['Area'])) {
                        $this->spreadsheet->getActiveSheet()->setAutoFilter((string) $attributes['Area']);
                    }
                }
            }
        }
    }

References $attributes.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\loadIntoExisting().

Here is the caller graph for this function:

processColumnLoop()

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::processColumnLoop ( int  $whichColumn, int  $maxCol, SimpleXMLElement  $columnOverride, float  $defaultWidth  )

private

Definition at line 407 of file Gnumeric.php.

                                                                                                                            : int
    {
        $columnAttributes = self::testSimpleXml($columnOverride->attributes());
        $column = $columnAttributes['No'];
        $columnWidth = ((float) $columnAttributes['Unit']) / 5.4;
        $hidden = (isset($columnAttributes['Hidden'])) && ((string) $columnAttributes['Hidden'] == '1');
        $columnCount = (int) ($columnAttributes['Count'] ?? 1);
        while ($whichColumn < $column) {
            $this->setColumnWidth($whichColumn, $defaultWidth);
            ++$whichColumn;
        }
        while (($whichColumn < ($column + $columnCount)) && ($whichColumn <= $maxCol)) {
            $this->setColumnWidth($whichColumn, $columnWidth);
            if ($hidden) {
                $this->setColumnInvisible($whichColumn);
            }
            ++$whichColumn;
        }
 
        return $whichColumn;
    }

References $columnCount, PhpOffice\PhpSpreadsheet\Reader\Gnumeric\setColumnInvisible(), PhpOffice\PhpSpreadsheet\Reader\Gnumeric\setColumnWidth(), and PhpOffice\PhpSpreadsheet\Reader\Gnumeric\testSimpleXml().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processColumnWidths().

Here is the call graph for this function:

Here is the caller graph for this function:

processColumnWidths()

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::processColumnWidths ( ?SimpleXMLElement  $sheet, int  $maxCol  )

private

Definition at line 429 of file Gnumeric.php.

                                                                               : void
    {
        if ((!$this->readDataOnly) && $sheet !== null && (isset($sheet->Cols))) {
            //    Column Widths
            $defaultWidth = 0;
            $columnAttributes = $sheet->Cols->attributes();
            if ($columnAttributes !== null) {
                $defaultWidth = $columnAttributes['DefaultSizePts'] / 5.4;
            }
            $whichColumn = 0;
            foreach ($sheet->Cols->ColInfo as $columnOverride) {
                $whichColumn = $this->processColumnLoop($whichColumn, $maxCol, $columnOverride, $defaultWidth);
            }
            while ($whichColumn <= $maxCol) {
                $this->setColumnWidth($whichColumn, $defaultWidth);
                ++$whichColumn;
            }
        }
    }

References PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processColumnLoop(), and PhpOffice\PhpSpreadsheet\Reader\Gnumeric\setColumnWidth().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\loadIntoExisting().

Here is the call graph for this function:

Here is the caller graph for this function:

processComments()

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::processComments ( SimpleXMLElement  $sheet )

private

Definition at line 212 of file Gnumeric.php.

                                                             : void
    {
        if ((!$this->readDataOnly) && (isset($sheet->Objects))) {
            foreach ($sheet->Objects->children(self::NAMESPACE_GNM) as $key => $comment) {
                $commentAttributes = $comment->attributes();
                //    Only comment objects are handled at the moment
                if ($commentAttributes->Text) {
                    $this->spreadsheet->getActiveSheet()->getComment((string) $commentAttributes->ObjectBound)
                        ->setAuthor((string) $commentAttributes->Author)
                        ->setText($this->parseRichText((string) $commentAttributes->Text));
                }
            }
        }
    }

References $comment, $key, and PhpOffice\PhpSpreadsheet\Reader\Gnumeric\parseRichText().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\loadIntoExisting().

Here is the call graph for this function:

Here is the caller graph for this function:

processDefinedNames()

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::processDefinedNames ( ?SimpleXMLElement  $gnmXML )

private

Definition at line 511 of file Gnumeric.php.

                                                                   : void
    {
        //    Loop through definedNames (global named ranges)
        if ($gnmXML !== null && isset($gnmXML->Names)) {
            foreach ($gnmXML->Names->Name as $definedName) {
                $name = (string) $definedName->name;
                $value = (string) $definedName->value;
                if (stripos($value, '#REF!') !== false) {
                    continue;
                }
 
                [$worksheetName] = Worksheet::extractSheetTitle($value, true);
                $worksheetName = trim($worksheetName, "'");
                $worksheet = $this->spreadsheet->getSheetByName($worksheetName);
                // Worksheet might still be null if we're only loading selected sheets rather than the full spreadsheet
                if ($worksheet !== null) {
                    $this->spreadsheet->addDefinedName(DefinedName::createInstance($name, $worksheet, $value));
                }
            }
        }
    }

References $name, and PhpOffice\PhpSpreadsheet\DefinedName\createInstance().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\loadIntoExisting().

Here is the call graph for this function:

Here is the caller graph for this function:

processMergedCells()

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::processMergedCells ( ?SimpleXMLElement  $sheet )

private

Definition at line 365 of file Gnumeric.php.

                                                                 : void
    {
        //    Handle Merged Cells in this worksheet
        if ($sheet !== null && isset($sheet->MergedRegions)) {
            foreach ($sheet->MergedRegions->Merge as $mergeCells) {
                if (strpos($mergeCells, ':') !== false) {
                    $this->spreadsheet->getActiveSheet()->mergeCells($mergeCells);
                }
            }
        }
    }

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\loadIntoExisting().

Here is the caller graph for this function:

processRowHeights()

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::processRowHeights ( ?SimpleXMLElement  $sheet, int  $maxRow  )

private

Definition at line 487 of file Gnumeric.php.

                                                                             : void
    {
        if ((!$this->readDataOnly) && $sheet !== null && (isset($sheet->Rows))) {
            //    Row Heights
            $defaultHeight = 0;
            $rowAttributes = $sheet->Rows->attributes();
            if ($rowAttributes !== null) {
                $defaultHeight = (float) $rowAttributes['DefaultSizePts'];
            }
            $whichRow = 0;
 
            foreach ($sheet->Rows->RowInfo as $rowOverride) {
                $whichRow = $this->processRowLoop($whichRow, $maxRow, $rowOverride, $defaultHeight);
            }
            // never executed, I can't figure out any circumstances
            // under which it would be executed, and, even if
            // such exist, I'm not convinced this is needed.
            //while ($whichRow < $maxRow) {
            //    ++$whichRow;
            //    $this->spreadsheet->getActiveSheet()->getRowDimension($whichRow)->setRowHeight($defaultHeight);
            //}
        }
    }

References PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processRowLoop().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\loadIntoExisting().

Here is the call graph for this function:

Here is the caller graph for this function:

processRowLoop()

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::processRowLoop ( int  $whichRow, int  $maxRow, SimpleXMLElement  $rowOverride, float  $defaultHeight  )

private

Definition at line 465 of file Gnumeric.php.

                                                                                                                    : int
    {
        $rowAttributes = self::testSimpleXml($rowOverride->attributes());
        $row = $rowAttributes['No'];
        $rowHeight = (float) $rowAttributes['Unit'];
        $hidden = (isset($rowAttributes['Hidden'])) && ((string) $rowAttributes['Hidden'] == '1');
        $rowCount = (int) ($rowAttributes['Count'] ?? 1);
        while ($whichRow < $row) {
            ++$whichRow;
            $this->setRowHeight($whichRow, $defaultHeight);
        }
        while (($whichRow < ($row + $rowCount)) && ($whichRow < $maxRow)) {
            ++$whichRow;
            $this->setRowHeight($whichRow, $rowHeight);
            if ($hidden) {
                $this->setRowInvisible($whichRow);
            }
        }
 
        return $whichRow;
    }

References $row, PhpOffice\PhpSpreadsheet\Reader\Gnumeric\setRowHeight(), PhpOffice\PhpSpreadsheet\Reader\Gnumeric\setRowInvisible(), and PhpOffice\PhpSpreadsheet\Reader\Gnumeric\testSimpleXml().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processRowHeights().

Here is the call graph for this function:

Here is the caller graph for this function:

setColumnInvisible()

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::setColumnInvisible ( int  $whichColumn )

private

Definition at line 399 of file Gnumeric.php.

                                                         : void
    {
        $columnDimension = $this->spreadsheet->getActiveSheet()->getColumnDimension(Coordinate::stringFromColumnIndex($whichColumn + 1));
        if ($columnDimension !== null) {
            $columnDimension->setVisible(false);
        }
    }

References PhpOffice\PhpSpreadsheet\Cell\Coordinate\stringFromColumnIndex().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processColumnLoop().

Here is the call graph for this function:

Here is the caller graph for this function:

setColumnWidth()

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::setColumnWidth ( int  $whichColumn, float  $defaultWidth  )

private

Definition at line 391 of file Gnumeric.php.

                                                                          : void
    {
        $columnDimension = $this->spreadsheet->getActiveSheet()->getColumnDimension(Coordinate::stringFromColumnIndex($whichColumn + 1));
        if ($columnDimension !== null) {
            $columnDimension->setWidth($defaultWidth);
        }
    }

References PhpOffice\PhpSpreadsheet\Cell\Coordinate\stringFromColumnIndex().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processColumnLoop(), and PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processColumnWidths().

Here is the call graph for this function:

Here is the caller graph for this function:

setRowHeight()

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::setRowHeight ( int  $whichRow, float  $defaultHeight  )

private

Definition at line 449 of file Gnumeric.php.

                                                                      : void
    {
        $rowDimension = $this->spreadsheet->getActiveSheet()->getRowDimension($whichRow);
        if ($rowDimension !== null) {
            $rowDimension->setRowHeight($defaultHeight);
        }
    }

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processRowLoop().

Here is the caller graph for this function:

setRowInvisible()

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::setRowInvisible ( int  $whichRow )

private

Definition at line 457 of file Gnumeric.php.

                                                   : void
    {
        $rowDimension = $this->spreadsheet->getActiveSheet()->getRowDimension($whichRow);
        if ($rowDimension !== null) {
            $rowDimension->setVisible(false);
        }
    }

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processRowLoop().

Here is the caller graph for this function:

testSimpleXml()

static PhpOffice\PhpSpreadsheet\Reader\Gnumeric::testSimpleXml (   $value )

staticprivate

Parameters

mixed

$value

Definition at line 230 of file Gnumeric.php.

                                                 : SimpleXMLElement
    {
        return ($value instanceof SimpleXMLElement) ? $value : new SimpleXMLElement('<?xml version="1.0" encoding="UTF-8"?><root></root>');
    }

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\loadIntoExisting(), PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processColumnLoop(), and PhpOffice\PhpSpreadsheet\Reader\Gnumeric\processRowLoop().

Here is the caller graph for this function:

Field Documentation

$expressions

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::$expressions = []

private

Definition at line 42 of file Gnumeric.php.

$mappings

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::$mappings

static

Initial value:

= [
        'dataType' => [
            '10' => DataType::TYPE_NULL,
            '20' => DataType::TYPE_BOOL,
            '30' => DataType::TYPE_NUMERIC, 
            '40' => DataType::TYPE_NUMERIC, 
            '50' => DataType::TYPE_ERROR,
            '60' => DataType::TYPE_STRING,
            
            
        ],
    ]

Definition at line 55 of file Gnumeric.php.

$referenceHelper

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::$referenceHelper

private

Definition at line 52 of file Gnumeric.php.

$spreadsheet

PhpOffice\PhpSpreadsheet\Reader\Gnumeric::$spreadsheet

private

Definition at line 49 of file Gnumeric.php.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\load(), and PhpOffice\PhpSpreadsheet\Reader\Gnumeric\loadIntoExisting().

NAMESPACE_DC

const PhpOffice\PhpSpreadsheet\Reader\Gnumeric::NAMESPACE_DC = 'http://purl.org/dc/elements/1.1/'

Definition at line 31 of file Gnumeric.php.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\Properties\readProperties().

NAMESPACE_GNM

const PhpOffice\PhpSpreadsheet\Reader\Gnumeric::NAMESPACE_GNM = 'http://www.gnumeric.org/v10.dtd'

Definition at line 23 of file Gnumeric.php.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\PageSetup\buildMarginSet().

NAMESPACE_META

const PhpOffice\PhpSpreadsheet\Reader\Gnumeric::NAMESPACE_META = 'urn:oasis:names:tc:opendocument:xmlns:meta:1.0'

Definition at line 33 of file Gnumeric.php.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\Properties\docPropertiesMeta(), and PhpOffice\PhpSpreadsheet\Reader\Gnumeric\Properties\readProperties().

NAMESPACE_OFFICE

const PhpOffice\PhpSpreadsheet\Reader\Gnumeric::NAMESPACE_OFFICE = 'urn:oasis:names:tc:opendocument:xmlns:office:1.0'

Definition at line 27 of file Gnumeric.php.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\Properties\readProperties().

NAMESPACE_OOO

const PhpOffice\PhpSpreadsheet\Reader\Gnumeric::NAMESPACE_OOO = 'http://openoffice.org/2004/office'

Definition at line 35 of file Gnumeric.php.

NAMESPACE_XLINK

const PhpOffice\PhpSpreadsheet\Reader\Gnumeric::NAMESPACE_XLINK = 'http://www.w3.org/1999/xlink'

Definition at line 29 of file Gnumeric.php.

NAMESPACE_XSI

const PhpOffice\PhpSpreadsheet\Reader\Gnumeric::NAMESPACE_XSI = 'http://www.w3.org/2001/XMLSchema-instance'

Definition at line 25 of file Gnumeric.php.

---

The documentation for this class was generated from the following file:

• libs/composer/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Gnumeric.php