Interface Cell

    • Method Detail

      • setRow

        void setRow​(Row value)
        Sets the value of the 'Row' container reference.
        Parameters:
        value - the new value of the 'Row' container reference.
        See Also:
        getRow()
      • getValueError

        int getValueError()
        Returns the underlying error, caused by a formula evaluation that cannot succeed. Client shall first verify the cell type indicates an error.
        Returns:
        the underlying formula evaluation error.
        See Also:
        getType(), CellType.ERROR_LITERAL
      • getValueFormula

        String getValueFormula()
        Returns the cell formula evaluation result. The value is the last known evaluation result, evaluated by the time the cell has been modified or the workbook was saved. Client shall first verify the cell type is a formula.
        Returns:
        the cell formula evaluation result, an empty String if the cell is not a formula.
        See Also:
        getType(), CellType.FORMULA_LITERAL, getFormula()
      • getValueDouble

        double getValueDouble()
        Returns the underlying value as an double. Client shall first verify the cell type is a numeric.
        Returns:
        the underlying value as a double, 0.0 if the value is not a double.
        See Also:
        getType(), CellType.NUMERIC_LITERAL
      • getValueInt

        int getValueInt()
        Returns the underlying value as an int. Client shall first verify the cell type is a numeric.
        Returns:
        the underlying value as a int, 0 if the value is not a int.
        See Also:
        getType(), CellType.NUMERIC_LITERAL
      • getValueBoolean

        boolean getValueBoolean()
        Returns the underlying value as a boolean. Client shall first verify the cell type is boolean.
        Returns:
        the underlying value as a boolean, false if the value is not a boolean.
        See Also:
        getType(), CellType.BOOLEAN_LITERAL
      • setValue

        void setValue​(String value)
        Sets the value of the 'Value' attribute.
        Parameters:
        value - the new value of the 'Value' attribute.
        See Also:
        getValue()
      • setValueString

        void setValueString​(String value)
        Updates the cell with the specified String value. The cell type is also updated to reflect the value type.
        Parameters:
        value - the new String cell value.
        See Also:
        CellType.STRING_LITERAL
      • setValueError

        void setValueError​(int value)
        Updates the cell with the specified formula evaluation error. The cell type is also updated to reflect the value type.
        Parameters:
        value - the new boolean cell value.
        See Also:
        CellType.BOOLEAN_LITERAL
      • setValueBoolean

        void setValueBoolean​(boolean value)
        Updates the cell with the specified boolean value. The cell type is also updated to reflect the value type.
        Parameters:
        value - the new String cell value.
        See Also:
        CellType.STRING_LITERAL
      • setValueInt

        void setValueInt​(int value)
        Updates the cell with the specified integer value. The cell type is also updated to reflect the value type.
        Parameters:
        value - the new integer cell value.
        See Also:
        CellType.NUMERIC_LITERAL
      • setValueDouble

        void setValueDouble​(double value)
        Updates the cell with the specified double value. The cell type is also updated to reflect the value type.
        Parameters:
        value - the new double cell value.
        See Also:
        CellType.NUMERIC_LITERAL
      • setComment

        void setComment​(Comment value)
        Sets the value of the 'Comment' containment reference.
        Parameters:
        value - the new value of the 'Comment' containment reference.
        See Also:
        getComment()
      • setStyle

        void setStyle​(CellStyle value)
        Sets the value of the 'Style' reference.
        Parameters:
        value - the new value of the 'Style' reference.
        See Also:
        getStyle()
      • setType

        void setType​(CellType value)
        Sets the value of the 'Type' attribute.
        Parameters:
        value - the new value of the 'Type' attribute.
        See Also:
        CellType, getType()
      • setFormula

        void setFormula​(String value)
        Sets the value of the 'Formula' attribute.
        Parameters:
        value - the new value of the 'Formula' attribute.
        See Also:
        getFormula()
      • setHyperlink

        void setHyperlink​(Hyperlink value)
        Sets the value of the 'Hyperlink' containment reference.
        Parameters:
        value - the new value of the 'Hyperlink' containment reference.
        See Also:
        getHyperlink()