samples/Basic/18_Extendedcalculation.php

15 $spreadsheet = new Spreadsheet();  variable
19 $spreadsheet->getActiveSheet()->setCellValue('A14', 'Count:');
21 $spreadsheet->getActiveSheet()->setCellValue('B1', 'Range 1');
22 $spreadsheet->getActiveSheet()->setCellValue('B2', 2);
23 $spreadsheet->getActiveSheet()->setCellValue('B3', 8);
24 $spreadsheet->getActiveSheet()->setCellValue('B4', 10);
25 $spreadsheet->getActiveSheet()->setCellValue('B5', true);
26 $spreadsheet->getActiveSheet()->setCellValue('B6', false);
27 $spreadsheet->getActiveSheet()->setCellValue('B7', 'Text String');
28 $spreadsheet->getActiveSheet()->setCellValue('B9', '22');
29 $spreadsheet->getActiveSheet()->setCellValue('B10', 4);
30 $spreadsheet->getActiveSheet()->setCellValue('B11', 6);
31 $spreadsheet->getActiveSheet()->setCellValue('B12', 12);
33 $spreadsheet->getActiveSheet()->setCellValue('B14', '=COUNT(B2:B12)');
35 $spreadsheet->getActiveSheet()->setCellValue('C1', 'Range 2');
36 $spreadsheet->getActiveSheet()->setCellValue('C2', 1);
37 $spreadsheet->getActiveSheet()->setCellValue('C3', 2);
38 $spreadsheet->getActiveSheet()->setCellValue('C4', 2);
39 $spreadsheet->getActiveSheet()->setCellValue('C5', 3);
40 $spreadsheet->getActiveSheet()->setCellValue('C6', 3);
41 $spreadsheet->getActiveSheet()->setCellValue('C7', 3);
42 $spreadsheet->getActiveSheet()->setCellValue('C8', '0');
43 $spreadsheet->getActiveSheet()->setCellValue('C9', 4);
44 $spreadsheet->getActiveSheet()->setCellValue('C10', 4);
45 $spreadsheet->getActiveSheet()->setCellValue('C11', 4);
46 $spreadsheet->getActiveSheet()->setCellValue('C12', 4);
48 $spreadsheet->getActiveSheet()->setCellValue('C14', '=COUNT(C2:C12)');
50 $spreadsheet->getActiveSheet()->setCellValue('D1', 'Range 3');
51 $spreadsheet->getActiveSheet()->setCellValue('D2', 2);
52 $spreadsheet->getActiveSheet()->setCellValue('D3', 3);
53 $spreadsheet->getActiveSheet()->setCellValue('D4', 4);
55 $spreadsheet->getActiveSheet()->setCellValue('D5', '=((D2 * D3) + D4) & " should be 10"');
57 $spreadsheet->getActiveSheet()->setCellValue('E1', 'Other functions');
58 $spreadsheet->getActiveSheet()->setCellValue('E2', '=PI()');
59 $spreadsheet->getActiveSheet()->setCellValue('E3', '=RAND()');
60 $spreadsheet->getActiveSheet()->setCellValue('E4', '=RANDBETWEEN(5, 10)');
62 $spreadsheet->getActiveSheet()->setCellValue('E14', 'Count of both ranges:');
63 $spreadsheet->getActiveSheet()->setCellValue('F14', '=COUNT(B2:C12)');
67 $helper->log('Value of B14 [=COUNT(B2:B12)]: ' . $spreadsheet->getActiveSheet()->getCell('B14')->ge…