ULTRA [ dhmd.unla.ac.id ]

Linux unla-WEB 3.19.0-80-generic #88~14.04.1-Ubuntu SMP Fri Jan 13 14:54:07 UTC 2017 x86_64

Apache/2.4.7 (Ubuntu)

103.184.53.210 | Your IP: 192.168.112.121

Cant read [ /etc/named.conf ]

[ drwxrwxr-x ]

/ home / mkwu-online.unla.ac.id / vendor / phpoffice / phpspreadsheet / samples / Basic /

Home Upload Mass Deface Mass Delete Back Connect Notify

18_Extendedcalculation.php

<?php

use PhpOffice\PhpSpreadsheet\Calculation\Calculation;
use PhpOffice\PhpSpreadsheet\Spreadsheet;

require __DIR__ . '/../Header.php';

// List functions
$helper->log('List implemented functions');
$calc = Calculation::getInstance();
print_r($calc->getImplementedFunctionNames());

// Create new Spreadsheet object
$helper->log('Create new Spreadsheet object');
$spreadsheet = new Spreadsheet();

// Add some data, we will use some formulas here
$helper->log('Add some data');
$spreadsheet->getActiveSheet()->setCellValue('A14', 'Count:');

$spreadsheet->getActiveSheet()->setCellValue('B1', 'Range 1');
$spreadsheet->getActiveSheet()->setCellValue('B2', 2);
$spreadsheet->getActiveSheet()->setCellValue('B3', 8);
$spreadsheet->getActiveSheet()->setCellValue('B4', 10);
$spreadsheet->getActiveSheet()->setCellValue('B5', true);
$spreadsheet->getActiveSheet()->setCellValue('B6', false);
$spreadsheet->getActiveSheet()->setCellValue('B7', 'Text String');
$spreadsheet->getActiveSheet()->setCellValue('B9', '22');
$spreadsheet->getActiveSheet()->setCellValue('B10', 4);
$spreadsheet->getActiveSheet()->setCellValue('B11', 6);
$spreadsheet->getActiveSheet()->setCellValue('B12', 12);

$spreadsheet->getActiveSheet()->setCellValue('B14', '=COUNT(B2:B12)');

$spreadsheet->getActiveSheet()->setCellValue('C1', 'Range 2');
$spreadsheet->getActiveSheet()->setCellValue('C2', 1);
$spreadsheet->getActiveSheet()->setCellValue('C3', 2);
$spreadsheet->getActiveSheet()->setCellValue('C4', 2);
$spreadsheet->getActiveSheet()->setCellValue('C5', 3);
$spreadsheet->getActiveSheet()->setCellValue('C6', 3);
$spreadsheet->getActiveSheet()->setCellValue('C7', 3);
$spreadsheet->getActiveSheet()->setCellValue('C8', '0');
$spreadsheet->getActiveSheet()->setCellValue('C9', 4);
$spreadsheet->getActiveSheet()->setCellValue('C10', 4);
$spreadsheet->getActiveSheet()->setCellValue('C11', 4);
$spreadsheet->getActiveSheet()->setCellValue('C12', 4);

$spreadsheet->getActiveSheet()->setCellValue('C14', '=COUNT(C2:C12)');

$spreadsheet->getActiveSheet()->setCellValue('D1', 'Range 3');
$spreadsheet->getActiveSheet()->setCellValue('D2', 2);
$spreadsheet->getActiveSheet()->setCellValue('D3', 3);
$spreadsheet->getActiveSheet()->setCellValue('D4', 4);

$spreadsheet->getActiveSheet()->setCellValue('D5', '=((D2 * D3) + D4) & " should be 10"');

$spreadsheet->getActiveSheet()->setCellValue('E1', 'Other functions');
$spreadsheet->getActiveSheet()->setCellValue('E2', '=PI()');
$spreadsheet->getActiveSheet()->setCellValue('E3', '=RAND()');
$spreadsheet->getActiveSheet()->setCellValue('E4', '=RANDBETWEEN(5, 10)');

$spreadsheet->getActiveSheet()->setCellValue('E14', 'Count of both ranges:');
$spreadsheet->getActiveSheet()->setCellValue('F14', '=COUNT(B2:C12)');

// Calculated data
$helper->log('Calculated data');
$helper->log('Value of B14 [=COUNT(B2:B12)]: ' . $spreadsheet->getActiveSheet()->getCell('B14')->getCalculatedValue());

$helper->logEndingNotes();

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	root/root	drwxrwxr-x	2023-09-12 07:21:59
..	dir	-	root/root	drwxrwxr-x	2023-09-12 07:21:59
data	dir	-	root/root	drwxrwxr-x	2023-09-12 07:21:59
01_Simple.php	application/x-sc	1.86 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
01_Simple_download_ods.php	text/x-php	2.13 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
01_Simple_download_pdf.php	text/x-php	1.77 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
01_Simple_download_xls.php	text/x-php	2.11 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
01_Simple_download_xlsx.php	text/x-php	2.15 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
02_Types.php	text/x-php	4.98 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
03_Formulas.php	application/x-sc	3.33 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
04_Printing.php	application/x-sc	2.29 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
05_Feature_demo.php	text/x-php	171 B	root/root	-rw-rw-r--	2021-03-15 01:16:03
06_Largescale.php	text/x-php	172 B	root/root	-rw-rw-r--	2021-03-15 01:16:03
07_Reader.php	text/x-php	558 B	root/root	-rw-rw-r--	2021-03-15 01:16:03
08_Conditional_formatting.php	application/x-sc	4.97 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
08_Conditional_formatting_2.php	application/x-sc	2.55 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
09_Pagebreaks.php	application/x-sc	2.27 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
11_Documentsecurity.php	application/x-sc	1.85 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
12_CellProtection.php	application/x-sc	1.51 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
13_Calculation.php	text/x-php	6.76 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
13_CalculationCyclicFormulae.php	text/x-php	1.08 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
14_Xls.php	text/x-php	393 B	root/root	-rw-rw-r--	2021-03-15 01:16:03
15_Datavalidation.php	text/x-php	3.36 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
16_Csv.php	text/x-php	1.32 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
17_Html.php	text/x-php	395 B	root/root	-rw-rw-r--	2021-03-15 01:16:03
18_Extendedcalculation.php	text/x-php	2.95 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
19_Namedrange.php	text/x-php	2.63 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
20_Read_Excel2003XML.php	text/x-php	336 B	root/root	-rw-rw-r--	2021-03-15 01:16:03
20_Read_Gnumeric.php	text/x-php	342 B	root/root	-rw-rw-r--	2021-03-15 01:16:03
20_Read_Ods.php	text/x-php	330 B	root/root	-rw-rw-r--	2021-03-15 01:16:03
20_Read_Sylk.php	text/x-php	328 B	root/root	-rw-rw-r--	2021-03-15 01:16:03
20_Read_Xls.php	text/x-php	621 B	root/root	-rw-rw-r--	2021-03-15 01:16:03
22_Heavily_formatted.php	application/x-sc	1.49 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
23_Sharedstyles.php	application/x-sc	1.84 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
24_Readfilter.php	text/x-php	1.16 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
25_In_memory_image.php	application/x-sc	1.49 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
26_Utf8.php	text/x-php	1.46 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
27_Images_Xls.php	text/x-php	335 B	root/root	-rw-rw-r--	2021-03-15 01:16:03
28_Iterator.php	text/x-php	1.23 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
29_Advanced_value_binder.php	text/x-php	4.69 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
30_Template.php	text/x-php	1.25 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
31_Document_properties_write.php	text/x-php	3.09 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
31_Document_properties_write_xls.php	text/x-php	3.08 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
37_Page_layout_view.php	application/x-sc	1.03 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
38_Clone_worksheet.php	application/x-sc	1.85 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
39_Dropdown.php	text/x-php	4.06 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
40_Duplicate_style.php	text/x-php	1.02 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
41_Password.php	text/x-php	386 B	root/root	-rw-rw-r--	2021-03-15 01:16:03
42_RichText.php	text/x-php	2.71 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
43_Merge_workbooks.php	text/x-php	855 B	root/root	-rw-rw-r--	2021-03-15 01:16:03
44_Worksheet_info.php	text/x-php	760 B	root/root	-rw-rw-r--	2021-03-15 01:16:03
45_Quadratic_equation_solver.php	text/x-php	2 KB	root/root	-rw-rw-r--	2021-03-15 01:16:03
46_ReadHtml.php	text/x-php	424 B	root/root	-rw-rw-r--	2021-03-15 01:16:03