Struct spreadsheet_ods::Sheet

pub struct Sheet { /* fields omitted */ }

One sheet of the spreadsheet.

Contains the data and the style-references. The can also be styles on the whole sheet, columns and rows. The more complicated grouping tags are not covered.

Implementations

impl Sheet

pub fn new() -> Self

New, empty

pub fn new_with_name<S: Into<String>>(name: S) -> Self

New, empty, but with a name.

pub fn clone_no_data(&self) -> Self

Copy all the attributes but not the actual data.

pub fn iter(&self) -> CellIter<'_>

Iterate all cells.

pub fn range<R>(&self, range: R) -> Range<'_> where
    R: RangeBounds<(u32, u32)>, 

Iterate a range of cells.

pub fn set_name<V: Into<String>>(&mut self, name: V)

Sheet name.

pub fn name(&self) -> &String

Sheet name.

pub fn config(&self) -> &SheetConfig

Configuration for the sheet.

pub fn config_mut(&mut self) -> &mut SheetConfig

Configuration for the sheet.

pub fn set_style(&mut self, style: &TableStyleRef)

Sets the table-style

pub fn style(&self) -> Option<&String>

Returns the table-style.

pub fn set_colstyle(&mut self, col: u32, style: &ColStyleRef)

Column style.

pub fn clear_colstyle(&mut self, col: u32)

Remove the style.

pub fn colstyle(&self, col: u32) -> Option<&String>

Returns the column style.

pub fn set_col_cellstyle(&mut self, col: u32, style: &CellStyleRef)

Default cell style for this column.

pub fn clear_col_cellstyle(&mut self, col: u32)

Remove the style.

pub fn col_cellstyle(&self, col: u32) -> Option<&String>

Returns the default cell style for this column.

pub fn set_col_visible(&mut self, col: u32, visible: Visibility)

Visibility of the column

pub fn col_visible(&self, col: u32) -> Visibility

Returns the default cell style for this column.

pub fn set_col_width(&mut self, col: u32, width: Length)

Sets the column width for this column.

pub fn col_width(&self, col: u32) -> Length

Returns the column-width.

pub fn set_rowstyle(&mut self, row: u32, style: &RowStyleRef)

Row style.

pub fn clear_rowstyle(&mut self, row: u32)

Remove the style.

pub fn rowstyle(&self, row: u32) -> Option<&String>

Returns the row style.

pub fn set_row_cellstyle(&mut self, row: u32, style: &CellStyleRef)

Default cell style for this row.

pub fn clear_row_cellstyle(&mut self, row: u32)

Remove the style.

pub fn row_cellstyle(&self, row: u32) -> Option<&String>

Returns the default cell style for this row.

pub fn set_row_visible(&mut self, row: u32, visible: Visibility)

Visibility of the row

pub fn row_visible(&self, row: u32) -> Visibility

Returns the default cell style for this row.

pub fn set_row_repeat(&mut self, row: u32, repeat: u32)

Sets the repeat count for this row. Usually this is the last row with data in a sheet. Setting the repeat count will not change the row number of following rows. But they will be changed after writing to an ODS file and reading it again.

pub fn row_repeat(&self, row: u32) -> u32

Returns the repeat count for this row.

pub fn set_row_height(&mut self, row: u32, height: Length)

Sets the row-height.

pub fn row_height(&self, row: u32) -> Length

Returns the row-height

pub fn used_cols(&self) -> u32

Returns the maximum used column +1 in the column header

pub fn used_rows(&self) -> u32

Returns the maximum used row +1 in the row header

pub fn used_grid_size(&self) -> (u32, u32)

Returns a tuple of (max(row)+1, max(col)+1)

pub fn set_display(&mut self, display: bool)

Is the sheet displayed?

pub fn display(&self) -> bool

Is the sheet displayed?

pub fn set_print(&mut self, print: bool)

Is the sheet printed?

pub fn print(&self) -> bool

Is the sheet printed?

pub fn is_empty(&self, row: u32, col: u32) -> bool

Returns true if there is no SCell at the given position.

pub fn cell(&self, row: u32, col: u32) -> Option<CellContent>

Basic range operator. Returns a copy of the cell content.

pub fn add_cell(&mut self, row: u32, col: u32, cell: CellContent)

Consumes the CellContent and sets the values.

pub fn remove_cell(&mut self, row: u32, col: u32) -> Option<CellContent>

Removes the cell and returns the values as CellContent.

pub fn set_styled_value<V: Into<Value>>(
    &mut self,
    row: u32,
    col: u32,
    value: V,
    style: &CellStyleRef
)

Sets a value for the specified cell. Creates a new cell if necessary.

pub fn set_value<V: Into<Value>>(&mut self, row: u32, col: u32, value: V)

Sets a value for the specified cell. Creates a new cell if necessary.

pub fn value(&self, row: u32, col: u32) -> &Value

Returns a value

pub fn set_formula<V: Into<String>>(&mut self, row: u32, col: u32, formula: V)

Sets a formula for the specified cell. Creates a new cell if necessary.

pub fn clear_formula(&mut self, row: u32, col: u32)

Removes the formula.

pub fn formula(&self, row: u32, col: u32) -> Option<&String>

Returns a value

pub fn set_cellstyle(&mut self, row: u32, col: u32, style: &CellStyleRef)

Sets the cell-style for the specified cell. Creates a new cell if necessary.

pub fn clear_cellstyle(&mut self, row: u32, col: u32)

Removes the cell-style.

pub fn cellstyle(&self, row: u32, col: u32) -> Option<&String>

Returns a value

pub fn set_validation(&mut self, row: u32, col: u32, validation: &ValidationRef)

Sets a content-validation for this cell.

pub fn clear_validation(&mut self, row: u32, col: u32)

Removes the cell-style.

pub fn validation(&self, row: u32, col: u32) -> Option<&String>

Returns a content-validation name for this cell.

pub fn set_row_span(&mut self, row: u32, col: u32, span: u32)

Sets the rowspan of the cell. Must be greater than 0.

pub fn row_span(&self, row: u32, col: u32) -> u32

Rowspan of the cell.

pub fn set_col_span(&mut self, row: u32, col: u32, span: u32)

Sets the colspan of the cell. Must be greater than 0.

pub fn col_span(&self, row: u32, col: u32) -> u32

Colspan of the cell.

pub fn set_header_rows(&mut self, row_start: u32, row_end: u32)

Defines a range of rows as header rows.

pub fn clear_header_rows(&mut self)

Clears the header-rows definition.

pub fn header_rows(&self) -> &Option<RowRange>

Returns the header rows.

pub fn set_header_cols(&mut self, col_start: u32, col_end: u32)

Defines a range of columns as header columns.

pub fn clear_header_cols(&mut self)

Clears the header-columns definition.

pub fn header_cols(&self) -> &Option<ColRange>

Returns the header columns.

pub fn add_print_range(&mut self, range: CellRange)

Print ranges.

pub fn clear_print_ranges(&mut self)

Remove print ranges.

pub fn print_ranges(&self) -> Option<&Vec<CellRange>>

Return the print ranges.

pub fn split_col_header(&mut self, col: u32)

Split horizontally on a cell boundary. The splitting is fixed in position.

pub fn split_row_header(&mut self, row: u32)

Split vertically on a cell boundary. The splitting is fixed in position.

pub fn split_horizontal(&mut self, col: u32)

Split horizontally with a pixel width. The split can be moved around. For more control look at SheetConfig.

pub fn split_vertical(&mut self, col: u32)

Split vertically with a pixel width. The split can be moved around. For more control look at SheetConfig.

Trait Implementations

impl Clone for Sheet

fn clone(&self) -> Sheet

Returns a copy of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for Sheet

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Default for Sheet

fn default() -> Sheet

Returns the “default value” for a type.

impl<'a> IntoIterator for &'a Sheet

type Item = ((u32, u32), CellContentRef<'a>)

The type of the elements being iterated over.

type IntoIter = CellIter<'a>

Which kind of iterator are we turning this into?

fn into_iter(self) -> Self::IntoIter

Creates an iterator from a value.