Home
last modified time | relevance | path

Searched refs:write_formula (Results 1 – 25 of 30) sorted by relevance

12

/dports/textproc/p5-Excel-Writer-XLSX/Excel-Writer-XLSX-1.09/t/regression/
H A Dformula_results01.t39 $worksheet->write_formula( 'A1', '1+1', undef, 2 );
40 $worksheet->write_formula( 'A2', '"Foo"', undef, 'Foo' );
41 $worksheet->write_formula( 'A3', 'IF(B3,FALSE,TRUE)', undef, 'TRUE' );
42 $worksheet->write_formula( 'A4', 'IF(B4,TRUE,FALSE)', undef, 'FALSE' );
43 $worksheet->write_formula( 'A5', '#DIV/0!', undef, '#DIV/0!' );
44 $worksheet->write_formula( 'A6', '#N/A', undef, '#N/A' );
45 $worksheet->write_formula( 'A7', '#NAME?', undef, '#NAME?' );
46 $worksheet->write_formula( 'A8', '#NULL!', undef, '#NULL!' );
47 $worksheet->write_formula( 'A9', '#NUM!', undef, '#NUM!' );
48 $worksheet->write_formula( 'A10', '#REF!', undef, '#REF!' );
[all …]
H A Descapes01.t38 $worksheet->write_formula( 'A1', q{=IF(1>2,0,1)}, undef, 1 );
39 $worksheet->write_formula( 'A2', q{=CONCATENATE("'","<>&")}, undef, q{'<>&} );
40 $worksheet->write_formula( 'A3', q{=1&"b"}, undef, q{1b} );
41 $worksheet->write_formula( 'A4', q{="'"}, undef, q{'} );
42 $worksheet->write_formula( 'A5', q{=""""}, undef, q{"} );
43 $worksheet->write_formula( 'A6', q{="&" & "&"}, undef, q{&&} );
H A Dignore_error06.t37 $worksheet->write_formula( 'A1', '=B1' );
38 $worksheet->write_formula( 'A2', '=B1' );
39 $worksheet->write_formula( 'A3', '=B3' );
H A Dignore_error05.t38 $worksheet->write_formula( 'A2', '=1/0', undef, '#DIV/0!' );
H A Dutf8_05.t38 $worksheet->write_formula( 'A1', '="Café"', undef, 'Café' );
H A Dhyperlink19.t45 $worksheet->write_formula( 'A1', '=1+1', undef, 2 );
H A Darray_formula03.t42 $worksheet->write_formula( 'A1', '{=SUM(B1:C1*B2:C2)}', undef, 0 );
/dports/textproc/py-xlsxwriter/XlsxWriter-1.4.3/examples/
H A Dworksheet_protection.py28 worksheet.write_formula('B1', '=1+2') # Locked by default.
29 worksheet.write_formula('B2', '=1+2', unlocked)
30 worksheet.write_formula('B3', '=1+2', hidden)
H A Dignore_errors.py18 worksheet.write_formula('C5', '=1/0')
19 worksheet.write_formula('C6', '=1/0')
H A Darray_formula.py28 worksheet.write_formula('A1', '{=SUM(B1:C1*B2:C2)}')
/dports/textproc/p5-Excel-Writer-XLSX/Excel-Writer-XLSX-1.09/examples/
H A Dprotection.pl31 $worksheet->write_formula( 'B1', '=1+2', undef, 3 ); # Locked by default.
34 $worksheet->write_formula( 'B2', '=1+2', $unlocked, 3 );
37 $worksheet->write_formula( 'B3', '=1+2', $hidden, 3 );
H A Dignore_errors.pl22 $worksheet->write_formula('C5', '=1/0');
23 $worksheet->write_formula('C6', '=1/0');
/dports/textproc/p5-Excel-Template/Excel-Template-0.34/t/
H A D008_formula.t25 Spreadsheet::WriteExcel::Worksheet::write_formula( '0', '0', 'Test1', '1' )
26 Spreadsheet::WriteExcel::Worksheet::write_formula( '0', '1', 'Test2', '1' )
27 Spreadsheet::WriteExcel::Worksheet::write_formula( '0', '2', '', '1' )
H A D015_cell_type.t29 Spreadsheet::WriteExcel::Worksheet::write_formula( '0', '4', 'Formula', '1' )
/dports/textproc/p5-Excel-Writer-XLSX/Excel-Writer-XLSX-1.09/t/worksheet/
H A Dtest_range_return_values.t56 $got = $worksheet->write_formula( $max_row, 0, '=A1' );
59 $got = $worksheet->write_formula( 0, $max_col, '=A1' );
62 $got = $worksheet->write_formula( $max_row, $max_col, '=A1' );
/dports/www/moodle311/moodle/lib/
H A Dexcellib.class.php280 public function write_formula($row, $col, $formula, $format = null) { function in MoodleExcelWorksheet
328 return $this->write_formula($row, $col, $token, $format);
331 return $this->write_formula($row, $col, $token, $format);
H A Dodslib.class.php234 public function write_formula($row, $col, $formula, $format = null) { function in MoodleODSWorksheet
286 return $this->write_formula($row, $col, $token, $format);
289 return $this->write_formula($row, $col, $token, $format);
/dports/www/moodle310/moodle/lib/
H A Dexcellib.class.php280 public function write_formula($row, $col, $formula, $format = null) { function in MoodleExcelWorksheet
328 return $this->write_formula($row, $col, $token, $format);
331 return $this->write_formula($row, $col, $token, $format);
H A Dodslib.class.php234 public function write_formula($row, $col, $formula, $format = null) { function in MoodleODSWorksheet
286 return $this->write_formula($row, $col, $token, $format);
289 return $this->write_formula($row, $col, $token, $format);
/dports/www/moodle39/moodle/lib/
H A Dexcellib.class.php280 public function write_formula($row, $col, $formula, $format = null) { function in MoodleExcelWorksheet
328 return $this->write_formula($row, $col, $token, $format);
331 return $this->write_formula($row, $col, $token, $format);
H A Dodslib.class.php234 public function write_formula($row, $col, $formula, $format = null) { function in MoodleODSWorksheet
286 return $this->write_formula($row, $col, $token, $format);
289 return $this->write_formula($row, $col, $token, $format);
/dports/math/libxlsxwriter/libxlsxwriter-RELEASE_1.1.4/docs/src/
H A Dtutorial01.dox98 @skipline write_formula
H A Dbugs.dox33 When written using `write_formula()` these functions need to be fully
/dports/textproc/p5-Spreadsheet-WriteExcel/Spreadsheet-WriteExcel-2.40/t/
H A D04_dimensions.t393 $worksheet->write_formula(5, 3, '= 1 + 2');
/dports/textproc/p5-Spreadsheet-WriteExcelXML/Spreadsheet-WriteExcelXML-0.15/lib/Spreadsheet/WriteExcelXML/
H A DWorksheet.pm1156 return $self->write_formula(@_);
1160 return $self->write_formula(@_);
1699 sub write_formula{ subroutine

12