visualizer / vendor / phpoffice / phpspreadsheet / samples / Basic / 13_CalculationCyclicFormulae.php

13_CalculationCyclicFormulae.php in Visualizer – Tables & Charts Manager with Built-in AI Generator 3.7.1, at vendor/phpoffice/phpspreadsheet/samples/Basic/13_CalculationCyclicFormulae.php

34 lines 1.0 KB

Raw Download Zip

1	<?php
2
3	use PhpOffice\PhpSpreadsheet\Calculation\Calculation;
4	use PhpOffice\PhpSpreadsheet\Spreadsheet;
5
6	require __DIR__ . '/../Header.php';
7
8	// Create new Spreadsheet object
9	$helper->log('Create new Spreadsheet object');
10	$spreadsheet = new Spreadsheet();
11
12	// Add some data, we will use some formulas here
13	$helper->log('Add some data and formulas');
14	$spreadsheet->getActiveSheet()->setCellValue('A1', '=B1')
15	->setCellValue('A2', '=B2+1')
16	->setCellValue('B1', '=A1+1')
17	->setCellValue('B2', '=A2');
18
19	Calculation::getInstance($spreadsheet)->cyclicFormulaCount = 100;
20
21	// Calculated data
22	$helper->log('Calculated data');
23	for ($row = 1; $row <= 2; ++$row) {
24	for ($col = 'A'; $col != 'C'; ++$col) {
25	if ((($formula = $spreadsheet->getActiveSheet()->getCell($col . $row)->getValue()) !== null) &&
26	($formula[0] == '=')) {
27	$helper->log('Value of ' . $col . $row . ' [' . $formula . ']: ' . $spreadsheet->getActiveSheet()->getCell($col . $row)->getCalculatedValue());
28	}
29	}
30	}
31
32	// Save
33	$helper->write($spreadsheet, __FILE__);
34