mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-20 14:50:53 +00:00
oleibman
641f86dc80
A continuation of PR #3859. Change code that would be flagged if we were to run Phpstan at level 9 (we currently run level 8). I may or may not follow up with source code (454 level-9 problems remain for src), but there is no reason to avoid the effort for samples. No changes are made to src.
52 lines
1.6 KiB
PHP
52 lines
1.6 KiB
PHP
<?php
|
|
|
|
use PhpOffice\PhpSpreadsheet\NamedFormula;
|
|
use PhpOffice\PhpSpreadsheet\NamedRange;
|
|
use PhpOffice\PhpSpreadsheet\Spreadsheet;
|
|
|
|
require_once __DIR__ . '/../Header.php';
|
|
|
|
$spreadsheet = new Spreadsheet();
|
|
$worksheet = $spreadsheet->setActiveSheetIndex(0);
|
|
|
|
// Add some Named Formulae
|
|
// The first to store our tax rate
|
|
$spreadsheet->addNamedFormula(new NamedFormula('TAX_RATE', $worksheet, '=19%'));
|
|
// The second to calculate the Tax on a Price value (Note that `PRICE` is defined later as a Named Range)
|
|
$spreadsheet->addNamedFormula(new NamedFormula('TAX', $worksheet, '=PRICE*TAX_RATE'));
|
|
|
|
// Set up some basic data
|
|
$worksheet
|
|
->setCellValue('A1', 'Tax Rate:')
|
|
->setCellValue('B1', '=TAX_RATE')
|
|
->setCellValue('A3', 'Net Price:')
|
|
->setCellValue('B3', 19.99)
|
|
->setCellValue('A4', 'Tax:')
|
|
->setCellValue('A5', 'Price including Tax:');
|
|
|
|
// Define a named range that we can use in our formulae
|
|
$spreadsheet->addNamedRange(new NamedRange('PRICE', $worksheet, '=$B$3'));
|
|
|
|
// Reference the defined formulae in worksheet formulae
|
|
$worksheet
|
|
->setCellValue('B4', '=TAX')
|
|
->setCellValue('B5', '=PRICE+TAX');
|
|
|
|
/** @var float */
|
|
$calc1 = $worksheet->getCell('B1')->getCalculatedValue();
|
|
/** @var float */
|
|
$value = $worksheet->getCell('B3')->getValue();
|
|
/** @var float */
|
|
$calc2 = $worksheet->getCell('B4')->getCalculatedValue();
|
|
/** @var float */
|
|
$calc3 = $worksheet->getCell('B5')->getCalculatedValue();
|
|
$helper->log(sprintf(
|
|
'With a Tax Rate of %.2f and a net price of %.2f, Tax is %.2f and the gross price is %.2f',
|
|
$calc1,
|
|
$value,
|
|
$calc2,
|
|
$calc3
|
|
));
|
|
|
|
$helper->write($spreadsheet, __FILE__, ['Xlsx']);
|