Home
last modified time | relevance | path

Searched refs:spreadsheet (Results 1 – 25 of 3649) sorted by relevance

12345678910>>...146

/dports/finance/prestashop/prestashop/vendor/phpoffice/phpspreadsheet/samples/Basic/
H A D18_Extendedcalculation.php15 $spreadsheet = new Spreadsheet(); variable
22 $spreadsheet->getActiveSheet()->setCellValue('B2', 2);
23 $spreadsheet->getActiveSheet()->setCellValue('B3', 8);
24 $spreadsheet->getActiveSheet()->setCellValue('B4', 10);
29 $spreadsheet->getActiveSheet()->setCellValue('B10', 4);
30 $spreadsheet->getActiveSheet()->setCellValue('B11', 6);
36 $spreadsheet->getActiveSheet()->setCellValue('C2', 1);
37 $spreadsheet->getActiveSheet()->setCellValue('C3', 2);
38 $spreadsheet->getActiveSheet()->setCellValue('C4', 2);
39 $spreadsheet->getActiveSheet()->setCellValue('C5', 3);
[all …]
H A D29_Advanced_value_binder.php19 $spreadsheet = new Spreadsheet(); variable
23 $spreadsheet->getProperties()->setCreator('Maarten Balliauw')
33 $spreadsheet->getDefaultStyle()->getFont()->setName('Arial');
34 $spreadsheet->getDefaultStyle()->getFont()->setSize(10);
39 $spreadsheet->getActiveSheet()->getColumnDimension('B')->setWidth(14);
43 $spreadsheet->getActiveSheet()->setCellValue('A1', 'String value:')
46 $spreadsheet->getActiveSheet()->setCellValue('A2', 'Numeric value #1:')
70 $spreadsheet->getActiveSheet()->setCellValue('A10', 'Boolean value:')
124 $spreadsheet->getActiveSheet()->setCellValue('A28', 'Formula:')
129 $spreadsheet->getActiveSheet()->setTitle('Advanced value binder');
[all …]
H A D13_Calculation.php17 $spreadsheet = new Spreadsheet(); variable
21 $spreadsheet->getActiveSheet()->setCellValue('A14', 'Count:')
29 $spreadsheet->getActiveSheet()->setCellValue('A22', 'CountA:')
33 $spreadsheet->getActiveSheet()->setCellValue('A26', 'StDev:')
38 $spreadsheet->getActiveSheet()->setCellValue('A31', 'DevSq:')
44 $spreadsheet->getActiveSheet()->setCellValue('A37', 'Date:');
46 $spreadsheet->getActiveSheet()->setCellValue('B1', 'Range 1')
58 $spreadsheet->getActiveSheet()->setCellValue('B14', '=COUNT(B2:B12)')
87 $spreadsheet->getActiveSheet()->setCellValue('C1', 'Range 2')
123 $spreadsheet->getActiveSheet()->setCellValue('D1', 'Range 3')
[all …]
H A D03_Formulas.php9 $spreadsheet = new Spreadsheet(); variable
23 $spreadsheet->getActiveSheet()
40 $spreadsheet->getActiveSheet()
42 $spreadsheet->getActiveSheet()
46 $spreadsheet->getActiveSheet()
48 $spreadsheet->getActiveSheet()
52 $spreadsheet->getActiveSheet()
54 $spreadsheet->getActiveSheet()
58 $spreadsheet->getActiveSheet()
60 $spreadsheet->getActiveSheet()
[all …]
H A D02_Types.php13 $spreadsheet = new Spreadsheet(); variable
17 $spreadsheet->getProperties()
28 $spreadsheet->getDefaultStyle()
35 $spreadsheet->getActiveSheet()
40 $spreadsheet->getActiveSheet()
45 $spreadsheet->getActiveSheet()
50 $spreadsheet->getActiveSheet()
55 $spreadsheet->getActiveSheet()
60 $spreadsheet->getActiveSheet()
65 $spreadsheet->getActiveSheet()
[all …]
H A D19_Namedrange.php10 $spreadsheet = new Spreadsheet(); variable
14 $spreadsheet->getProperties()->setCreator('Maarten Balliauw')
24 $spreadsheet->setActiveSheetIndex(0);
25 $spreadsheet->getActiveSheet()->setCellValue('A1', 'Firstname:')
34 $spreadsheet->addNamedRange(new NamedRange('PersonName', $spreadsheet->getActiveSheet(), 'B1'));
35 $spreadsheet->addNamedRange(new NamedRange('PersonLN', $spreadsheet->getActiveSheet(), 'B2'));
43 $spreadsheet->getActiveSheet()->setTitle('Person');
47 $spreadsheet->createSheet();
51 $spreadsheet->setActiveSheetIndex(1);
67 $spreadsheet->getActiveSheet()->setTitle('Person (cloned)');
[all …]
H A D08_Conditional_formatting.php13 $spreadsheet = new Spreadsheet(); variable
17 $spreadsheet->getProperties()->setCreator('Maarten Balliauw')
27 $spreadsheet->setActiveSheetIndex(0);
28 $spreadsheet->getActiveSheet()->setCellValue('A1', 'Description')
31 $spreadsheet->getActiveSheet()->setCellValue('A2', 'Paycheck received')
43 $spreadsheet->getActiveSheet()->setCellValue('A6', 'Found some money')
46 $spreadsheet->getActiveSheet()->setCellValue('A7', 'Total:')
89 $spreadsheet->getActiveSheet()->duplicateConditionalStyle(
103 $spreadsheet->getActiveSheet()->getHeaderFooter()->setOddFooter('&L&B' . $spreadsheet->getPropertie…
112 $spreadsheet->getActiveSheet()->setTitle('Invoice');
[all …]
H A D11_Documentsecurity.php9 $spreadsheet = new Spreadsheet(); variable
13 $spreadsheet->getProperties()->setCreator('Maarten Balliauw')
23 $spreadsheet->setActiveSheetIndex(0);
24 $spreadsheet->getActiveSheet()->setCellValue('A1', 'Hello');
25 $spreadsheet->getActiveSheet()->setCellValue('B2', 'world!');
26 $spreadsheet->getActiveSheet()->setCellValue('C1', 'Hello');
27 $spreadsheet->getActiveSheet()->setCellValue('D2', 'world!');
31 $spreadsheet->getActiveSheet()->setTitle('Simple');
35 $spreadsheet->getSecurity()->setLockWindows(true);
36 $spreadsheet->getSecurity()->setLockStructure(true);
[all …]
H A D39_Dropdown.php11 $spreadsheet = new Spreadsheet(); variable
15 $spreadsheet->getProperties()
63 $spreadsheet->getActiveSheet()
67 $spreadsheet->addNamedRange(
76 $spreadsheet->getActiveSheet()
78 $spreadsheet->getActiveSheet()
80 $spreadsheet->getActiveSheet()
82 $spreadsheet->getActiveSheet()
84 $spreadsheet->getActiveSheet()
104 $spreadsheet->getActiveSheet()
[all …]
H A D09_Pagebreaks.php10 $spreadsheet = new Spreadsheet(); variable
14 $spreadsheet->getProperties()->setCreator('Maarten Balliauw')
24 $spreadsheet->setActiveSheetIndex(0);
25 $spreadsheet->getActiveSheet()->setCellValue('A1', 'Firstname')
47 $spreadsheet->setActiveSheetIndex(0);
48 $spreadsheet->getActiveSheet()->setTitle('Printing Options');
51 $spreadsheet->getActiveSheet()
53 $spreadsheet->getActiveSheet()
57 $spreadsheet->getActiveSheet()
59 $spreadsheet->getActiveSheet()
[all …]
/dports/devel/liborcus/liborcus-0.16.1/src/
H A Dorcus_test_xls_xml.cpp36 namespace ss = orcus::spreadsheet;
68 std::unique_ptr<spreadsheet::document> doc = orcus::make_unique<spreadsheet::document>(ss); in load_doc_from_filepath()
82 std::unique_ptr<spreadsheet::document> doc = orcus::make_unique<spreadsheet::document>(ss); in load_doc_from_stream()
101 spreadsheet::document m_doc;
383 spreadsheet::row_t row; in test_xls_xml_colored_text()
456 spreadsheet::col_t col; in test_xls_xml_column_width_row_height()
463 spreadsheet::row_t row; in test_xls_xml_column_width_row_height()
530 spreadsheet::row_t row; in test_xls_xml_background_fill()
531 spreadsheet::col_t col; in test_xls_xml_background_fill()
619 spreadsheet::row_t row; in test_xls_xml_text_alignment()
[all …]
H A Dorcus_test_xlsx.cpp35 using namespace orcus::spreadsheet;
36 namespace ss = orcus::spreadsheet;
46 std::unique_ptr<spreadsheet::document> doc = orcus::make_unique<spreadsheet::document>(ss); in load_doc()
324 spreadsheet::row_t row; in test_xlsx_background_fill()
325 spreadsheet::col_t col; in test_xlsx_background_fill()
413 spreadsheet::row_t row; in test_xlsx_text_alignment()
414 spreadsheet::col_t col; in test_xlsx_text_alignment()
479 spreadsheet::row_t row; in test_xlsx_cell_borders_single_cells()
480 spreadsheet::col_t col; in test_xlsx_cell_borders_single_cells()
529 spreadsheet::row_t row; in test_xlsx_cell_borders_directions()
[all …]
H A Dodf_styles_context_test.cpp23 const orcus::spreadsheet::cell_style_t* find_cell_style_by_name(const orcus::pstring& name, orcus::… in find_cell_style_by_name()
39 void test_odf_fill(orcus::spreadsheet::styles &styles) in test_odf_fill()
50 const orcus::spreadsheet::fill_t* cell_fill = styles.get_fill(fill); in test_odf_fill()
59 void test_odf_border(orcus::spreadsheet::styles &styles) in test_odf_border()
114 void test_odf_cell_protection(orcus::spreadsheet::styles& styles) in test_odf_cell_protection()
156 void test_odf_font(orcus::spreadsheet::styles& styles) in test_odf_font()
197 void test_odf_number_formatting(orcus::spreadsheet::styles& styles) in test_odf_number_formatting()
322 void test_odf_text_alignment(orcus::spreadsheet::styles& styles) in test_odf_text_alignment()
339 orcus::spreadsheet::styles styles; in main()
340 orcus::spreadsheet::import_styles istyles(styles, string_pool); in main()
[all …]
/dports/devel/liborcus/liborcus-0.16.1/src/liborcus/
H A Dodf_helper.cpp31 { MDDS_ASCII("none"), spreadsheet::border_style_t::none},
32 { MDDS_ASCII("solid"), spreadsheet::border_style_t::solid},
55 { MDDS_ASCII("dash"), spreadsheet::underline_t::dash},
60 { MDDS_ASCII("none"), spreadsheet::underline_t::none},
62 { MDDS_ASCII("wave"), spreadsheet::underline_t::wave}
82 { MDDS_ASCII("top"), spreadsheet::ver_alignment_t::top}
123 orcus::spreadsheet::color_elem_t& green, orcus::spreadsheet::color_elem_t& blue) in convert_fo_color()
165 orcus::spreadsheet::underline_width_t underline_width; in extract_underline_width()
175 spreadsheet::underline_t underline_style; in extract_underline_style()
187 spreadsheet::hor_alignment_t::unknown); in extract_hor_alignment_style()
[all …]
H A Dxls_xml_context.hpp113 spreadsheet::address_t pos;
128 spreadsheet::border_direction_t dir = spreadsheet::border_direction_t::unknown;
129 spreadsheet::border_style_t style = spreadsheet::border_style_t::unknown;
153 spreadsheet::hor_alignment_t hor = spreadsheet::hor_alignment_t::unknown;
154 spreadsheet::ver_alignment_t ver = spreadsheet::ver_alignment_t::unknown;
174 spreadsheet::sheet_t scope;
182 spreadsheet::col_t col;
183 spreadsheet::row_t row;
184 spreadsheet::range_t range;
284 spreadsheet::row_t m_cur_row;
[all …]
H A Dodf_styles_context.cpp136 spreadsheet::color_elem_t m_red;
137 spreadsheet::color_elem_t m_green;
138 spreadsheet::color_elem_t m_blue;
143 spreadsheet::color_elem_t m_underline_red;
145 spreadsheet::color_elem_t m_underline_blue;
149 spreadsheet::underline_t m_underline_style;
286 void get_color(spreadsheet::color_elem_t& red, spreadsheet::color_elem_t& green, in get_color()
287 spreadsheet::color_elem_t& blue) in get_color()
299 void get_underline_color(spreadsheet::color_elem_t& red, spreadsheet::color_elem_t& green, in get_underline_color()
300 spreadsheet::color_elem_t& blue) in get_underline_color()
[all …]
H A Dmock_spreadsheet.hpp13 namespace orcus { namespace spreadsheet { namespace mock { namespace
34 class import_styles : public orcus::spreadsheet::iface::import_styles
172 …virtual void set_auto(orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col, const char* p,…
174 …virtual void set_string(orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col, size_t sinde…
176 …virtual void set_value(orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col, double value)…
178 …virtual void set_bool(orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col, bool value) ov…
181 orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col,
184 …virtual void set_format(orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col, size_t xf_in…
186 … virtual void set_format(orcus::spreadsheet::row_t row_start, orcus::spreadsheet::col_t col_start,
187 … orcus::spreadsheet::row_t row_end, orcus::spreadsheet::col_t col_end, size_t xf_index) override;
[all …]
H A Dxlsx_session_data.hpp31 spreadsheet::sheet_t sheet;
32 spreadsheet::address_t ref;
36 spreadsheet::sheet_t _sheet, spreadsheet::row_t _row, spreadsheet::col_t _column,
42 spreadsheet::sheet_t sheet;
43 spreadsheet::range_t ref;
49 spreadsheet::sheet_t sheet, const spreadsheet::range_t& ref,
55 spreadsheet::sheet_t sheet;
56 spreadsheet::row_t row;
57 spreadsheet::col_t column;
63 spreadsheet::sheet_t _sheet, spreadsheet::row_t _row, spreadsheet::col_t _column,
[all …]
/dports/finance/prestashop/prestashop/vendor/phpoffice/phpspreadsheet/samples/templates/
H A DsampleSpreadsheet.php18 $spreadsheet = new Spreadsheet(); variable
22 $spreadsheet->getProperties()->setCreator('Maarten Balliauw')
32 $spreadsheet->setActiveSheetIndex(0);
40 $spreadsheet->getActiveSheet()->setCellValue('C3', 'Price');
44 $spreadsheet->getActiveSheet()->setCellValue('A4', '1001');
46 $spreadsheet->getActiveSheet()->setCellValue('C4', '20');
47 $spreadsheet->getActiveSheet()->setCellValue('D4', '1');
50 $spreadsheet->getActiveSheet()->setCellValue('A5', '1012');
52 $spreadsheet->getActiveSheet()->setCellValue('C5', '22');
53 $spreadsheet->getActiveSheet()->setCellValue('D5', '2');
[all …]
/dports/editors/libreoffice6/libreoffice-6.4.7.2/sc/source/filter/inc/
H A Dorcusinterface.hxx126 …virtual void set_color(orcus::spreadsheet::color_elem_t alpha, orcus::spreadsheet::color_elem_t re…
127 orcus::spreadsheet::color_elem_t green, orcus::spreadsheet::color_elem_t blue) override;
144 orcus::spreadsheet::color_elem_t green, orcus::spreadsheet::color_elem_t blue) override;
147 orcus::spreadsheet::color_elem_t green, orcus::spreadsheet::color_elem_t blue) override;
167 virtual void set_range(orcus::spreadsheet::row_t row_start, orcus::spreadsheet::col_t col_start,
168 orcus::spreadsheet::row_t row_end, orcus::spreadsheet::col_t col_end) override;
248 … virtual void set_position(orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col) override;
330 … virtual void set_format(orcus::spreadsheet::row_t row_start, orcus::spreadsheet::col_t col_start,
335 …virtual void fill_down_cells(orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col, orcus::…
511 …olor(orcus::spreadsheet::color_elem_t alpha, orcus::spreadsheet::color_elem_t red, orcus::spreadsh…
[all …]
/dports/editors/libreoffice/libreoffice-7.2.6.2/sc/source/filter/inc/
H A Dorcusinterface.hxx133 …virtual void set_color(orcus::spreadsheet::color_elem_t alpha, orcus::spreadsheet::color_elem_t re…
134 orcus::spreadsheet::color_elem_t green, orcus::spreadsheet::color_elem_t blue) override;
151 orcus::spreadsheet::color_elem_t green, orcus::spreadsheet::color_elem_t blue) override;
154 orcus::spreadsheet::color_elem_t green, orcus::spreadsheet::color_elem_t blue) override;
174 virtual void set_range(orcus::spreadsheet::row_t row_start, orcus::spreadsheet::col_t col_start,
175 orcus::spreadsheet::row_t row_end, orcus::spreadsheet::col_t col_end) override;
255 … virtual void set_position(orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col) override;
337 … virtual void set_format(orcus::spreadsheet::row_t row_start, orcus::spreadsheet::col_t col_start,
342 …virtual void fill_down_cells(orcus::spreadsheet::row_t row, orcus::spreadsheet::col_t col, orcus::…
518 …olor(orcus::spreadsheet::color_elem_t alpha, orcus::spreadsheet::color_elem_t red, orcus::spreadsh…
[all …]
/dports/math/scilab/scilab-6.1.1/scilab/modules/spreadsheet/locales/
H A Dspreadsheet.pot1 # Localization of the module spreadsheet
380 # File: modules/spreadsheet/src/c/csvRead.c, line: 372
381 # File: modules/spreadsheet/src/c/csvRead.c, line: 376
387 # File: modules/spreadsheet/src/c/csvRead.c, line: 441
395 # File: modules/spreadsheet/src/c/csvRead.c, line: 441
400 # File: modules/spreadsheet/src/c/csvRead.c, line: 442
424 # File: modules/spreadsheet/src/c/ripole/ole.c, line: 98
430 # File: modules/spreadsheet/src/c/ripole/ole.c, line: 246
620 msgid "Scilab spreadsheet module not installed.\n"
623 # File: modules/spreadsheet/demos/spreadsheet.dem.gateway.sce, line: 9
[all …]
/dports/www/dolibarr/dolibarr-14.0.3/htdocs/includes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx/
H A DWorkbook.php18 * @param Spreadsheet $spreadsheet
58 $this->writeSheets($objWriter, $spreadsheet);
109 * @param Spreadsheet $spreadsheet
138 * @param Spreadsheet $spreadsheet
187 * @param Spreadsheet $spreadsheet
195 $sheetCount = $spreadsheet->getSheetCount();
200 $spreadsheet->getSheet($i)->getTitle(),
242 * @param Spreadsheet $spreadsheet
258 $sheetCount = $spreadsheet->getSheetCount();
277 * @param Spreadsheet $spreadsheet
[all …]
/dports/www/dolibarr13/dolibarr-13.0.5/htdocs/includes/phpoffice/PhpSpreadsheet/Writer/Xlsx/
H A DWorkbook.php18 * @param Spreadsheet $spreadsheet
58 $this->writeSheets($objWriter, $spreadsheet);
109 * @param Spreadsheet $spreadsheet
138 * @param Spreadsheet $spreadsheet
187 * @param Spreadsheet $spreadsheet
195 $sheetCount = $spreadsheet->getSheetCount();
200 $spreadsheet->getSheet($i)->getTitle(),
242 * @param Spreadsheet $spreadsheet
258 $sheetCount = $spreadsheet->getSheetCount();
277 * @param Spreadsheet $spreadsheet
[all …]
/dports/finance/prestashop/prestashop/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx/
H A DWorkbook.php18 * @param Spreadsheet $spreadsheet
58 $this->writeSheets($objWriter, $spreadsheet);
109 * @param Spreadsheet $spreadsheet
138 * @param Spreadsheet $spreadsheet
187 * @param Spreadsheet $spreadsheet
195 $sheetCount = $spreadsheet->getSheetCount();
200 $spreadsheet->getSheet($i)->getTitle(),
242 * @param Spreadsheet $spreadsheet
258 $sheetCount = $spreadsheet->getSheetCount();
277 * @param Spreadsheet $spreadsheet
[all …]

12345678910>>...146