- clear() - Method in class com.github.miachm.sods.Range
-
Clear all the content/styles of the cells in this range
- clear() - Method in class com.github.miachm.sods.Sheet
-
Clear all the content of the sheet.
- clear() - Method in class com.github.miachm.sods.SpreadSheet
-
Remove all sheets of the book.
- clone() - Method in class com.github.miachm.sods.Color
-
- clone() - Method in class com.github.miachm.sods.Sheet
-
- clone() - Method in class com.github.miachm.sods.SpreadSheet
-
- clone() - Method in class com.github.miachm.sods.Style
-
- Color - Class in com.github.miachm.sods
-
Color is a inmutable class for represent colors.
- Color(int, int, int) - Constructor for class com.github.miachm.sods.Color
-
It creates a color object from a RGB format (red, green, blue).
- Color(String) - Constructor for class com.github.miachm.sods.Color
-
It creates a color object from a String representation (CSS Style).
- columnIsHidden(int) - Method in class com.github.miachm.sods.Sheet
-
Determinies if a specific column is hidden or not
- com.github.miachm.sods - package com.github.miachm.sods
-
Package of the library.
- compareTo(Sheet) - Method in class com.github.miachm.sods.Sheet
-
compareTo method, this comparator only compare the names
Note: this class has a natural ordering that is inconsistent with equals.
- ConditionalFormat - Class in com.github.miachm.sods
-
This class refers to a specific rule to apply a conditional style.
- conditionWhenValueIsBetween(Style, double, double) - Static method in class com.github.miachm.sods.ConditionalFormat
-
- conditionWhenValueIsEqual(Style, double) - Static method in class com.github.miachm.sods.ConditionalFormat
-
Create a ConditionalFormat rule where the boolean condition is "values equals to X".
- conditionWhenValueIsEqual(Style, String) - Static method in class com.github.miachm.sods.ConditionalFormat
-
- conditionWhenValueIsGreater(Style, double) - Static method in class com.github.miachm.sods.ConditionalFormat
-
Create a ConditionalFormat rule where the boolean condition is "values greater than X".
- conditionWhenValueIsLower(Style, double) - Static method in class com.github.miachm.sods.ConditionalFormat
-
Create a ConditionalFormat rule where the boolean condition is "values lower than X".
- copyTo(Range) - Method in class com.github.miachm.sods.Range
-
Copy the content of this range to another,
this include values and formatting
- GenerateOdsException - Exception in com.github.miachm.sods
-
An unexpected error occurred when generate the ODS file
- getAnnotation() - Method in class com.github.miachm.sods.Range
-
Returns the annotation/comment of the first Cell in this range.
- getAnnotations() - Method in class com.github.miachm.sods.Range
-
Returns the rectangular grid of the annotations for this range.
- getBackgroundColor() - Method in class com.github.miachm.sods.Style
-
Returns the cell background color.
- getBlue() - Method in class com.github.miachm.sods.Color
-
- getBorderBottomProperties() - Method in class com.github.miachm.sods.Borders
-
Gets bottom border properties.
- getBorderLeftProperties() - Method in class com.github.miachm.sods.Borders
-
Gets left border properties.
- getBorderProperties() - Method in class com.github.miachm.sods.Borders
-
Gets global border properties.
- getBorderRightProperties() - Method in class com.github.miachm.sods.Borders
-
Gets right border properties.
- getBorders() - Method in class com.github.miachm.sods.Style
-
Returns the borders properties.
- getBorderTopProperties() - Method in class com.github.miachm.sods.Borders
-
Gets top border properties.
- getCell(int, int) - Method in class com.github.miachm.sods.Range
-
Get a specific cell of this Range using relative coords
for example, (0,0) would be the first cell of this range
- getColumn() - Method in class com.github.miachm.sods.Range
-
Get the starting column index of this range.
- getColumnWidth(int) - Method in class com.github.miachm.sods.Sheet
-
Get the width of a column
- getConditions() - Method in class com.github.miachm.sods.Style
-
Get a list of all conditional format rules
Conditional format rules are specific properties which are applied if the cell fullfills a specific condition
- getCssStyles() - Method in class com.github.miachm.sods.Borders
-
Returns a Map representing this class as css-styles.
- getCssStyles() - Method in class com.github.miachm.sods.Style
-
Returns a Map representing this class as css-styles.
- getCurrency() - Method in class com.github.miachm.sods.OfficeCurrency
-
- getDataRange() - Method in class com.github.miachm.sods.Sheet
-
Get a @Range which contains the whole Sheet content.
- getDataStyle() - Method in class com.github.miachm.sods.Style
-
Returns the data style.
- getDefaultColumnCellStyle(int) - Method in class com.github.miachm.sods.Sheet
-
Gets the default cell style of a specific column.
- getFontColor() - Method in class com.github.miachm.sods.Style
-
Returns the font color.
- getFontSize() - Method in class com.github.miachm.sods.Style
-
Returns the font size
- getFormula() - Method in class com.github.miachm.sods.Range
-
Get the formula String of the first cell of the range
- getFormulas() - Method in class com.github.miachm.sods.Range
-
Returns the formulas (A1 notation) for the cells in the range.
- getGreen() - Method in class com.github.miachm.sods.Color
-
- getLastColumn() - Method in class com.github.miachm.sods.Range
-
Returns the end column position.
- getLastColumn() - Method in class com.github.miachm.sods.Sheet
-
- getLastModified() - Method in class com.github.miachm.sods.OfficeAnnotation
-
Get the date of the comment (last modification date)
- getLastModified() - Method in class com.github.miachm.sods.OfficeAnnotationBuilder
-
- getLastRow() - Method in class com.github.miachm.sods.Range
-
Returns the end row position.
- getLastRow() - Method in class com.github.miachm.sods.Sheet
-
- getMaxColumns() - Method in class com.github.miachm.sods.Sheet
-
The number of columns created in this sheet
- getMaxRows() - Method in class com.github.miachm.sods.Sheet
-
The number of rows created in this sheet
- getMergedCells() - Method in class com.github.miachm.sods.Range
-
Returns an array of Range objects representing merged cells that either
are fully within the current range, or contain at least one cell in the current range.
- getMessage() - Method in exception com.github.miachm.sods.GenerateOdsException
-
- getMessage() - Method in exception com.github.miachm.sods.NotAnOdsException
-
- getMessage() - Method in exception com.github.miachm.sods.OperationNotSupportedException
-
- getMessage() - Method in exception com.github.miachm.sods.SodsException
-
- getMsg() - Method in class com.github.miachm.sods.OfficeAnnotation
-
Returns the msg contained in the comment
- getMsg() - Method in class com.github.miachm.sods.OfficeAnnotationBuilder
-
- getName() - Method in class com.github.miachm.sods.Sheet
-
Obtains the name of this sheet
- getNumColumns() - Method in class com.github.miachm.sods.Range
-
Number of columns which contains this range
- getNumRows() - Method in class com.github.miachm.sods.Range
-
Number of rows which contains this range
- getNumSheets() - Method in class com.github.miachm.sods.SpreadSheet
-
Return the number of sheets in the book
- getNumValues() - Method in class com.github.miachm.sods.Range
-
Return the number of cells which contains this range
- getRange(int, int) - Method in class com.github.miachm.sods.Sheet
-
Obtains a @Range which contains a specific cell of the sheet
- getRange(int, int, int) - Method in class com.github.miachm.sods.Sheet
-
Obtains a @Range which represents a number of rows starting
in a specific Cell.
- getRange(int, int, int, int) - Method in class com.github.miachm.sods.Sheet
-
Obtains a @Range which represents a subset of the Sheet.
- getRange(String) - Method in class com.github.miachm.sods.Sheet
-
Obtains a @Range using the A1 Notation format.
- getRed() - Method in class com.github.miachm.sods.Color
-
- getRow() - Method in class com.github.miachm.sods.Range
-
Get the starting row index of this range.
- getRowHeight(int) - Method in class com.github.miachm.sods.Sheet
-
Get the height of a row
- getSheet() - Method in class com.github.miachm.sods.Range
-
Returns the sheet where this range is contained
- getSheet(String) - Method in class com.github.miachm.sods.SpreadSheet
-
Return a sheet with a given name.
- getSheet(int) - Method in class com.github.miachm.sods.SpreadSheet
-
Return a sheet with a given index.
- getSheets() - Method in class com.github.miachm.sods.SpreadSheet
-
Return all the sheets of the book in a list.
- getStyle() - Method in class com.github.miachm.sods.Range
-
Returns the formating style of the top-left cell in the range.
- getStyleApplied() - Method in class com.github.miachm.sods.ConditionalFormat
-
- getStyles() - Method in class com.github.miachm.sods.Range
-
Returns the rectangular grid of formating styles for this range.
- getTextAligment() - Method in class com.github.miachm.sods.Style
-
Get text aligment of the cell
- getValue() - Method in class com.github.miachm.sods.OfficeCurrency
-
- getValue() - Method in class com.github.miachm.sods.OfficePercentage
-
- getValue() - Method in class com.github.miachm.sods.Range
-
Returns the value of the top-left cell in the range.
- getValues() - Method in class com.github.miachm.sods.Range
-
Returns the rectangular grid of values for this range.
- getVerticalTextAligment() - Method in class com.github.miachm.sods.Style
-
Get the vertical text aligment of the cell
- insertColumnAfter(int) - Method in class com.github.miachm.sods.Sheet
-
Insert a column after a specific position
- insertColumnBefore(int) - Method in class com.github.miachm.sods.Sheet
-
Insert a column before a specific position
- insertColumnsAfter(int, int) - Method in class com.github.miachm.sods.Sheet
-
Insert a number of columns after a specific position
- insertColumnsBefore(int, int) - Method in class com.github.miachm.sods.Sheet
-
Insert a number of columns before a specific position
- insertRowAfter(int) - Method in class com.github.miachm.sods.Sheet
-
Insert a row after a specific position
- insertRowBefore(int) - Method in class com.github.miachm.sods.Sheet
-
Insert a row before a specific position
- insertRowsAfter(int, int) - Method in class com.github.miachm.sods.Sheet
-
Insert a row after a specific position
- insertRowsBefore(int, int) - Method in class com.github.miachm.sods.Sheet
-
Insert a row before a specific position
- isBold() - Method in class com.github.miachm.sods.Style
-
Determines if the font has bold style or not.
- isBorder() - Method in class com.github.miachm.sods.Borders
-
Determines if the style has all borders or not.
- isBorderBottom() - Method in class com.github.miachm.sods.Borders
-
Determines if the style has bottom border or not.
- isBorderLeft() - Method in class com.github.miachm.sods.Borders
-
Determines if the style has left border or not.
- isBorderRight() - Method in class com.github.miachm.sods.Borders
-
Determines if the style has right border or not.
- isBorderTop() - Method in class com.github.miachm.sods.Borders
-
Determines if the style has top border or not.
- isDefault() - Method in class com.github.miachm.sods.Style
-
Determine if this has default rules or not
- isHidden() - Method in class com.github.miachm.sods.Sheet
-
Determinies if the sheet is marked as hidden or not
- isItalic() - Method in class com.github.miachm.sods.Style
-
Determines if the font has italic style or not.
- isPartOfMerge() - Method in class com.github.miachm.sods.Range
-
Determines if the range is part of an existing cell's block
- isProtected() - Method in class com.github.miachm.sods.Sheet
-
Determines if this sheet is protected by a password or not
- isUnderline() - Method in class com.github.miachm.sods.Style
-
Returns if the font has a underline style or not
- isWrap() - Method in class com.github.miachm.sods.Style
-
Gets the wrapping nature.
- save(File) - Method in class com.github.miachm.sods.SpreadSheet
-
Save this SpreadSheet in a ODS file.
- save(OutputStream) - Method in class com.github.miachm.sods.SpreadSheet
-
Save this Spreadsheet to the stream in the ODS format
- setAdditionalFile(String, String, byte[]) - Method in class com.github.miachm.sods.SpreadSheet
-
This function allows you to add/edit additional files inside your Spreadsheet
This is an advanced feature which could be useful if you intent to store
macros inside the Spreadsheet file.This function will override existing files.
- setAnnotation(OfficeAnnotation) - Method in class com.github.miachm.sods.Range
-
Set an annotation for all the cells in this range.
- setAnnotations(OfficeAnnotation...) - Method in class com.github.miachm.sods.Range
-
Set a set of anotations to the range.
- setAnnotations(OfficeAnnotation[][]) - Method in class com.github.miachm.sods.Range
-
Set a set of annotations to the range.
- setBackgroundColor(Color) - Method in class com.github.miachm.sods.Range
-
Set a cell background color to the entire range
- setBackgroundColor(Color) - Method in class com.github.miachm.sods.Style
-
Set the background color
- setBackgroundColors(Color...) - Method in class com.github.miachm.sods.Range
-
Set a set of cell background colors to the range.
- setBackgroundColors(Color[][]) - Method in class com.github.miachm.sods.Range
-
Set a set of cell background colors formatting to the range.
- setBold(boolean) - Method in class com.github.miachm.sods.Style
-
Set a bold font style
- setBorder(boolean) - Method in class com.github.miachm.sods.Borders
-
Sets all borders on/off.
- setBorderBottom(boolean) - Method in class com.github.miachm.sods.Borders
-
Sets bottom border on/off.
- setBorderBottomProperties(String) - Method in class com.github.miachm.sods.Borders
-
Sets bottom border properties.
- setBorderLeft(boolean) - Method in class com.github.miachm.sods.Borders
-
Sets left border on/off.
- setBorderLeftProperties(String) - Method in class com.github.miachm.sods.Borders
-
Sets left border properties.
- setBorderProperties(String) - Method in class com.github.miachm.sods.Borders
-
Sets global border properties.
- setBorderRight(boolean) - Method in class com.github.miachm.sods.Borders
-
Sets right border on/off.
- setBorderRightProperties(String) - Method in class com.github.miachm.sods.Borders
-
Sets right border properties.
- setBorders(Borders) - Method in class com.github.miachm.sods.Style
-
Sets the borders properties.
- setBorderTop(boolean) - Method in class com.github.miachm.sods.Borders
-
Sets top border on/off.
- setBorderTopProperties(String) - Method in class com.github.miachm.sods.Borders
-
Sets top border properties.
- setColumnWidth(int, Double) - Method in class com.github.miachm.sods.Sheet
-
Set a specific column width to a specific column
- setColumnWidths(int, int, Double) - Method in class com.github.miachm.sods.Sheet
-
Set a column width to a specific set of columns
- setDataStyle(String) - Method in class com.github.miachm.sods.Style
-
Sets the data style that tells office software how to interpret and format content entered into a cell.
- setDefaultColumnCellStyle(int, Style) - Method in class com.github.miachm.sods.Sheet
-
Sets the default cell style of a specific column.
- setFontBold(boolean) - Method in class com.github.miachm.sods.Range
-
Set a font bold style to the entire range
- setFontBolds(boolean...) - Method in class com.github.miachm.sods.Range
-
Set a set of font bolds styles to the range.
- setFontBolds(boolean[][]) - Method in class com.github.miachm.sods.Range
-
Set a set of font bolds formatting to the range.
- setFontColor(Color) - Method in class com.github.miachm.sods.Range
-
Set a font color to the entire range
- setFontColor(Color) - Method in class com.github.miachm.sods.Style
-
Set the font color
- setFontColors(Color...) - Method in class com.github.miachm.sods.Range
-
Set a set of font colors styles to the range.
- setFontColors(Color[][]) - Method in class com.github.miachm.sods.Range
-
Set a set of font colors formatting to the range.
- setFontItalic(boolean) - Method in class com.github.miachm.sods.Range
-
Set a font italic style to the entire range
- setFontItalics(boolean...) - Method in class com.github.miachm.sods.Range
-
Set a set of font italics styles to the range.
- setFontItalics(boolean[][]) - Method in class com.github.miachm.sods.Range
-
Set a set of font italics formatting to the range.
- setFontSize(int) - Method in class com.github.miachm.sods.Range
-
Set the font size to the entire range
- setFontSize(int) - Method in class com.github.miachm.sods.Style
-
Sets the font size
- setFontSizes(int...) - Method in class com.github.miachm.sods.Range
-
Set a set of font sizes to the range.
- setFontSizes(int[][]) - Method in class com.github.miachm.sods.Range
-
Set a set of font sizes to the range.
- setFontUnderline(boolean) - Method in class com.github.miachm.sods.Range
-
Set a font underline style to the entire range
- setFontUnderlines(boolean...) - Method in class com.github.miachm.sods.Range
-
Set a set of font underlines styles to the range.
- setFontUnderlines(boolean[][]) - Method in class com.github.miachm.sods.Range
-
Set a set of font underlines formatting to the range.
- setFormula(String) - Method in class com.github.miachm.sods.Range
-
Set a formula for every cell in the range.
- setFormulas(String...) - Method in class com.github.miachm.sods.Range
-
Set a set of formulas to the range.
- setFormulas(String[][]) - Method in class com.github.miachm.sods.Range
-
Set a set of formulas to the range.
- setItalic(boolean) - Method in class com.github.miachm.sods.Style
-
Set a italic font style
- setLastModified(LocalDateTime) - Method in class com.github.miachm.sods.OfficeAnnotationBuilder
-
- setMsg(String) - Method in class com.github.miachm.sods.OfficeAnnotationBuilder
-
- setName(String) - Method in class com.github.miachm.sods.Sheet
-
Rename this sheet
- setPassword(String) - Method in class com.github.miachm.sods.Sheet
-
Sets a password for a sheet.
- setRowHeight(int, Double) - Method in class com.github.miachm.sods.Sheet
-
Set a specific row height to a specific row
- setRowHeights(int, int, Double) - Method in class com.github.miachm.sods.Sheet
-
Set a row height to a specific set of rows
- setSheet(Sheet, int) - Method in class com.github.miachm.sods.SpreadSheet
-
Replace the sheet in the position pos.
- setStyle(Style) - Method in class com.github.miachm.sods.Range
-
Set a format style for all the cells of the range
- setStyles(Style...) - Method in class com.github.miachm.sods.Range
-
Set a set of format styles to the range.
- setStyles(Style[][]) - Method in class com.github.miachm.sods.Range
-
Set a set of styles to the range.
- setTextAligment(Style.TEXT_ALIGMENT) - Method in class com.github.miachm.sods.Style
-
Set text's aligment of the cell's text.
- setUnderline(boolean) - Method in class com.github.miachm.sods.Style
-
Set a underline font style
- setValue(Object) - Method in class com.github.miachm.sods.Range
-
Set a value to the entire range
- setValues(Object...) - Method in class com.github.miachm.sods.Range
-
Set a set of values to the range.
- setValues(Object[][]) - Method in class com.github.miachm.sods.Range
-
Set a set of values to the range.
- setVerticalTextAligment(Style.VERTICAL_TEXT_ALIGMENT) - Method in class com.github.miachm.sods.Style
-
Set text's aligment of the cell's text in a vertical axis.
- setWrap(boolean) - Method in class com.github.miachm.sods.Style
-
Sets the wrapping nature.
- Sheet - Class in com.github.miachm.sods
-
Represents a sheet in a Spreadsheet.
- Sheet(String) - Constructor for class com.github.miachm.sods.Sheet
-
Create an empty sheet with a given name.
- Sheet(String, int, int) - Constructor for class com.github.miachm.sods.Sheet
-
Create an empty sheet with a given name and dimmensions
- showColumn(int) - Method in class com.github.miachm.sods.Sheet
-
Unhides the columns at the given index.
- showRow(int) - Method in class com.github.miachm.sods.Sheet
-
Unhides the row at the given index.
- showSheet() - Method in class com.github.miachm.sods.Sheet
-
Mark this sheet as visible
- SodsException - Exception in com.github.miachm.sods
-
Base class for all exceptions of the library
- SodsException() - Constructor for exception com.github.miachm.sods.SodsException
-
- sortSheets() - Method in class com.github.miachm.sods.SpreadSheet
-
- sortSheets(Comparator<Sheet>) - Method in class com.github.miachm.sods.SpreadSheet
-
- split() - Method in class com.github.miachm.sods.Range
-
Breaks apart any combined cells on the range.
- SpreadSheet - Class in com.github.miachm.sods
-
Spreadsheet is the base class for handle a Spreadsheet.
- SpreadSheet() - Constructor for class com.github.miachm.sods.SpreadSheet
-
Create an empty spreadsheet
- SpreadSheet(File) - Constructor for class com.github.miachm.sods.SpreadSheet
-
Load a Spreadsheet from an ODS file.
- SpreadSheet(InputStream) - Constructor for class com.github.miachm.sods.SpreadSheet
-
Load a Spreadsheet from an inputstream.
- Style - Class in com.github.miachm.sods
-
This a class which represents the formatting of a cell (background color, font size, font style, etc...)
- Style() - Constructor for class com.github.miachm.sods.Style
-
Constructs an empty-default Style.
- Style(boolean, boolean, boolean, Color, Color, int) - Constructor for class com.github.miachm.sods.Style
-
Deprecated.
- Style(boolean, boolean, boolean, Color, Color, int, Borders, boolean) - Constructor for class com.github.miachm.sods.Style
-
Deprecated.
- Style.TEXT_ALIGMENT - Enum in com.github.miachm.sods
-
Defines the text position of a Cell
- Style.VERTICAL_TEXT_ALIGMENT - Enum in com.github.miachm.sods
-
Defines the text position of a Cell in a vertical axis