Orcus
|
#include <sheet.hpp>
Public Member Functions | |
sheet (document &doc, sheet_t sheet_index, row_t row_size, col_t col_size) | |
virtual iface::import_sheet_properties * | get_sheet_properties () |
virtual iface::import_data_table * | get_data_table () |
virtual iface::import_table * | get_table () |
virtual iface::import_auto_filter * | get_auto_filter () |
virtual void | set_auto (row_t row, col_t col, const char *p, size_t n) |
virtual void | set_string (row_t row, col_t col, size_t sindex) |
virtual void | set_value (row_t row, col_t col, double value) |
virtual void | set_bool (row_t row, col_t col, bool value) |
virtual void | set_date_time (row_t row, col_t col, int year, int month, int day, int hour, int minute, double second) |
virtual void | set_format (row_t row, col_t col, size_t index) |
virtual void | set_format (row_t row_start, col_t col_start, row_t row_end, col_t col_end, size_t index) |
virtual void | set_formula (row_t row, col_t col, formula_grammar_t grammar, const char *p, size_t n) |
virtual void | set_shared_formula (row_t row, col_t col, formula_grammar_t grammar, size_t sindex, const char *p_formula, size_t n_formula, const char *p_range, size_t n_range) |
virtual void | set_shared_formula (row_t row, col_t col, formula_grammar_t grammar, size_t sindex, const char *p_formula, size_t n_formula) |
virtual void | set_shared_formula (row_t row, col_t col, size_t sindex) |
virtual void | set_formula_result (row_t row, col_t col, double value) |
virtual void | set_formula_result (row_t row, col_t col, const char *p, size_t n) |
virtual void | set_array_formula (row_t, col_t, formula_grammar_t, const char *, size_t, row_t, col_t) |
virtual void | set_array_formula (row_t, col_t, formula_grammar_t, const char *, size_t, const char *, size_t) |
virtual void | write_string (std::ostream &os, row_t row, col_t col) const |
void | set_col_width (col_t col, col_width_t width) |
col_width_t | get_col_width (col_t col, col_t *col_start, col_t *col_end) const |
void | set_col_hidden (col_t col, bool hidden) |
void | set_row_height (row_t row, row_height_t height) |
row_height_t | get_row_height (row_t row, row_t *row_start, row_t *row_end) const |
void | set_row_hidden (row_t row, bool hidden) |
void | set_merge_cell_range (const char *p_ref, size_t p_ref_len) |
size_t | get_string_identifier (row_t row, col_t col) const |
auto_filter_t * | get_auto_filter_data () |
const auto_filter_t * | get_auto_filter_data () const |
void | set_auto_filter_data (auto_filter_t *p) |
row_t | row_size () const |
col_t | col_size () const |
sheet_t | get_index () const |
void | finalize () |
void | dump_flat (std::ostream &os) const |
void | dump_check (std::ostream &os, const pstring &sheet_name) const |
void | dump_html (const ::std::string &filepath) const |
size_t | get_cell_format (row_t row, col_t col) const |
![]() | |
virtual import_conditional_format * | get_conditional_format () |
Friends | |
struct | sheet_impl |
This class represents a single sheet instance in the internal document model.
|
virtual |
Get an interface for importing auto filter ranges.
The implementor should also initialize the internal state of the temporary auto filter object when this method is called.
Reimplemented from orcus::spreadsheet::iface::import_sheet.
size_t orcus::spreadsheet::sheet::get_cell_format | ( | row_t | row, |
col_t | col | ||
) | const |
Get the cell format ID of specified cell.
|
virtual |
Get an interface for importing data tables. Note that the implementer may decide not to support this feature in which case this method returns NULL. The implementer is responsible for managing the life cycle of the returned interface object.
The implementor should also initialize the internal state of the temporary data table object when this method is called.
Reimplemented from orcus::spreadsheet::iface::import_sheet.
|
virtual |
Get an interface for importing tables. The implementer is responsible for managing the life cycle of the returned interface object.
The implementor should also initialize the internal state of the temporary table object when this method is called.
Reimplemented from orcus::spreadsheet::iface::import_sheet.
|
virtual |
Set a array formula to the specified cells. The formula covers an area specified by array_rows and array_cols beginning from the base cell.
row | row ID |
col | column ID |
grammar | grammar used in the formula expression |
p | pointer to the first character of the raw formula expression string. |
n | size of the raw formula expression string |
array_rows | number of rows the array formula covers |
array_cols | number of columns the array formula covers |
Implements orcus::spreadsheet::iface::import_sheet.
|
virtual |
Set a array formula to the specified cells. The formula covers an area specified by the range string.
row | row ID |
col | column ID |
grammar | grammar used in the formula expression |
p | pointer to the first character of the raw formula expression string. |
n | size of the raw formula expression string |
p_range | pointer to the first character of the range string |
n_range | isze of the range string |
Implements orcus::spreadsheet::iface::import_sheet.
|
virtual |
Set raw string value to a cell and have the implementation auto-recognize its data type.
row | row ID |
col | column ID |
p | pointer to the first character of the raw string value. |
n | size of the raw string value. |
Implements orcus::spreadsheet::iface::import_sheet.
|
virtual |
Set a boolean value to a cell.
row | row ID |
col | col ID |
value | boolean value being assigned to the cell |
Implements orcus::spreadsheet::iface::import_sheet.
|
virtual |
Set date and time value to a cell.
row | row ID |
col | column ID |
Implements orcus::spreadsheet::iface::import_sheet.
|
virtual |
Set cell format to specified cell. The cell format is referred to by the xf (cell format) index in the styles table.
row | row ID |
col | column ID |
index | 0-based xf (cell format) index |
Implements orcus::spreadsheet::iface::import_sheet.
|
virtual |
Set cell format to specified cell range. The cell format is referred to by the xf (cell format) index in the styles table.
row_start | start row ID |
col_start | start column ID |
row_end | end row ID |
col_end | end column ID |
index | 0-based xf (cell format) index |
Implements orcus::spreadsheet::iface::import_sheet.
|
virtual |
Set normal, non-shared formula expression to specified cell.
row | row ID |
col | column ID |
grammar | grammar used in the formula expression |
p | pointer to the first character of the raw formula expression string. |
n | size of the raw formula expression string. |
Implements orcus::spreadsheet::iface::import_sheet.
|
virtual |
Set shared formula expression to specified cell. This call also registers the formula expression to a common formula expression pool to allow it to be looked up by the specified index later.
row | row ID |
col | column ID |
grammar | grammar used in the formula expression |
sindex | shared formula index (0-based) |
p_formula | pointer to the first character of the raw formula expression string. |
n_formula | size of the raw formula expression string. |
p_range | pointer to the first character of the range string |
n_range | size of the raw range string |
Implements orcus::spreadsheet::iface::import_sheet.
|
virtual |
Set shared formula expression to specified cell. This call also registers the formula expression to a common formula expression pool to allow it to be looked up by the specified index later.
row | row ID |
col | column ID |
grammar | grammar used in the formula expression |
sindex | shared formula index (0-based) |
p_formula | pointer to the first character of the raw formula expression string. |
n_formula | size of the raw formula expression string. |
Implements orcus::spreadsheet::iface::import_sheet.
|
virtual |
Set shared formula to specified cell by shared formula index. The formula expression itself associated with the index must be defined.
row | row ID |
col | column ID |
grammar | grammar used in the formula expression |
sindex | shared formula index (0-based) |
p | pointer to the first character of the raw formula expression string. |
n | size of the raw formula expression string. |
Implements orcus::spreadsheet::iface::import_sheet.
|
virtual |
Set string value to a cell.
row | row ID |
col | column ID |
sindex | 0-based string index in the shared string table. |
Implements orcus::spreadsheet::iface::import_sheet.
|
virtual |
Set numerical value to a cell.
row | row ID |
col | column ID |
value | value being assigned to the cell. |
Implements orcus::spreadsheet::iface::import_sheet.