Class CFRule12Record

    • Method Detail

      • create

        public static CFRule12Record create​(HSSFSheet sheet,
                                            String formulaText)
        Creates a new comparison operation rule
        Parameters:
        sheet - the sheet
        formulaText - the first formula text
        Returns:
        a new comparison operation rule
      • create

        public static CFRule12Record create​(HSSFSheet sheet,
                                            byte comparisonOperation,
                                            String formulaText1,
                                            String formulaText2)
        Creates a new comparison operation rule
        Parameters:
        sheet - the sheet
        comparisonOperation - the comparison operation
        formulaText1 - the first formula text
        formulaText2 - the second formula text
        Returns:
        a new comparison operation rule
      • create

        public static CFRule12Record create​(HSSFSheet sheet,
                                            byte comparisonOperation,
                                            String formulaText1,
                                            String formulaText2,
                                            String formulaTextScale)
        Creates a new comparison operation rule
        Parameters:
        sheet - the sheet
        comparisonOperation - the comparison operation
        formulaText1 - the first formula text
        formulaText2 - the second formula text
        formulaTextScale - the scale to apply for the comparison
        Returns:
        a new comparison operation rule
      • create

        public static CFRule12Record create​(HSSFSheet sheet,
                                            ExtendedColor color)
        Creates a new Data Bar formatting
        Parameters:
        sheet - the sheet
        color - the data bar color
        Returns:
        a new Data Bar formatting
      • createColorScale

        public static CFRule12Record createColorScale​(HSSFSheet sheet)
        Creates a new Color Scale / Color Gradient formatting
        Parameters:
        sheet - the sheet
        Returns:
        a new Color Scale / Color Gradient formatting
      • containsDataBarBlock

        public boolean containsDataBarBlock()
      • containsMultiStateBlock

        public boolean containsMultiStateBlock()
      • containsColorGradientBlock

        public boolean containsColorGradientBlock()
      • getParsedExpressionScale

        public Ptg[] getParsedExpressionScale()
        get the stack of the scale expression as a list
        Returns:
        list of tokens (casts stack to a list and returns it!) this method can return null is we are unable to create Ptgs from existing excel file callers should check for null!
      • setParsedExpressionScale

        public void setParsedExpressionScale​(Ptg[] ptgs)
      • getPriority

        public int getPriority()
      • setPriority

        public void setPriority​(int priority)
      • getSid

        public short getSid()
        Description copied from class: Record
        return the non static version of the id for this record.
        Specified by:
        getSid in class Record
        Returns:
        he id for this record
      • serialize

        public void serialize​(LittleEndianOutput out)
        called by the class that is responsible for writing this sucker. Subclasses should implement this so that their data is passed back in a byte array.
        Specified by:
        serialize in class StandardRecord
        Parameters:
        out - the stream to write to