Class SpreadSheetAddFormulaRow

  • All Implemented Interfaces:
    AdditionalInformationHandler, CleanUpHandler, Destroyable, GlobalInfoSupporter, LoggingLevelHandler, LoggingSupporter, OptionHandler, QuickInfoSupporter, ShallowCopySupporter<AbstractConversion>, SizeOfHandler, Stoppable, Conversion, InPlaceProcessing, Serializable

    public class SpreadSheetAddFormulaRow
    extends AbstractInPlaceSpreadSheetConversion
    Adds a row with a user-supplied formula for the specified columns.

    -logging-level <OFF|SEVERE|WARNING|INFO|CONFIG|FINE|FINER|FINEST> (property: loggingLevel)
        The logging level for outputting errors and debugging output.
        default: WARNING
     
    -no-copy <boolean> (property: noCopy)
        If enabled, no copy of the spreadsheet is created before processing it.
        default: false
     
    -formula <adams.parser.SpreadSheetFormulaText> (property: formula)
        The formula to add (incl '='); use '@' as placeholder for the current column
        and '#' for the last row.
        default: =sum(@1:@#)
     
    -columns <adams.data.spreadsheet.SpreadSheetColumnRange> (property: columns)
        The range of columns to add the formula for; A range is a comma-separated
        list of single 1-based indices or sub-ranges of indices ('start-end'); '
        inv(...)' inverts the range '...'; column names (case-sensitive) as well
        as the following placeholders can be used: first, second, third, last_2,
        last_1, last; numeric indices can be enforced by preceding them with '#'
        (eg '#12'); column names can be surrounded by double quotes.
        default: first-last
        example: A range is a comma-separated list of single 1-based indices or sub-ranges of indices ('start-end'); 'inv(...)' inverts the range '...'; column names (case-sensitive) as well as the following placeholders can be used: first, second, third, last_2, last_1, last; numeric indices can be enforced by preceding them with '#' (eg '#12'); column names can be surrounded by double quotes.
     
    -expand-variables <boolean> (property: expandVariables)
        If enabled, any variables in the formula get expanded first before adding
        it to the spreadsheet.
        default: false
     
    Author:
    fracpete (fracpete at waikato dot ac dot nz)
    See Also:
    Serialized Form
    • Field Detail

      • PLACEHOLDER_CURRENT_COLUMN

        public static final String PLACEHOLDER_CURRENT_COLUMN
        the placeholder for the current column.
        See Also:
        Constant Field Values
      • PLACEHOLDER_LAST_COLUMN

        public static final String PLACEHOLDER_LAST_COLUMN
        the placeholder for the last column.
        See Also:
        Constant Field Values
      • PLACEHOLDER_LAST_ROW

        public static final String PLACEHOLDER_LAST_ROW
        the placeholder for the last row.
        See Also:
        Constant Field Values
      • m_ExpandVariables

        protected boolean m_ExpandVariables
        whether to expand variables.
    • Constructor Detail

      • SpreadSheetAddFormulaRow

        public SpreadSheetAddFormulaRow()
    • Method Detail

      • setFormula

        public void setFormula​(SpreadSheetFormulaText value)
        Sets the formula to use.
        Parameters:
        value - the formula (incl. "=")
      • getFormula

        public SpreadSheetFormulaText getFormula()
        Returns the formula in use.
        Returns:
        the formula (incl. "=")
      • formulaTipText

        public String formulaTipText()
        Returns the tip text for this property.
        Returns:
        tip text for this property suitable for displaying in the GUI or for listing the options.
      • setColumns

        public void setColumns​(SpreadSheetColumnRange value)
        Sets the range of columns to add the sum for.
        Parameters:
        value - the range
      • getColumns

        public SpreadSheetColumnRange getColumns()
        Returns the range of columns to add the sum for.
        Returns:
        true range
      • columnsTipText

        public String columnsTipText()
        Returns the tip text for this property.
        Returns:
        tip text for this property suitable for displaying in the GUI or for listing the options.
      • setExpandVariables

        public void setExpandVariables​(boolean value)
        Sets whether to expand any variable first before adding the formula to the spreadsheet.
        Parameters:
        value - true if to expand first
      • getExpandVariables

        public boolean getExpandVariables()
        Returns whether to expand any variable first before adding the formula to the spreadsheet.
        Returns:
        true if to expand first
      • expandVariablesTipText

        public String expandVariablesTipText()
        Returns the tip text for this property.
        Returns:
        tip text for this property suitable for displaying in the GUI or for listing the options.