Package org.apache.poi.hssf.record

Class CFRuleBase

    • Constructor Detail

      • CFRuleBase

        protected CFRuleBase​(byte conditionType,
                     byte comparisonOperation)
        Creates new CFRuleRecord
        Parameters:
        conditionType - the condition type
        comparisonOperation - the comparison operation

      • CFRuleBase

        protected CFRuleBase​(byte conditionType,
                     byte comparisonOperation,
                     Ptg[] formula1,
                     Ptg[] formula2)

      • CFRuleBase

        protected CFRuleBase()

      • CFRuleBase

        protected CFRuleBase​(CFRuleBase other)

    • Method Detail

      • getConditionType

        public byte getConditionType()

      • setConditionType

        protected void setConditionType​(byte condition_type)

      • setComparisonOperation

        public void setComparisonOperation​(byte operation)

      • getComparisonOperation

        public byte getComparisonOperation()

      • containsFontFormattingBlock

        public boolean containsFontFormattingBlock()

      • setFontFormatting

        public void setFontFormatting​(FontFormatting fontFormatting)

      • containsAlignFormattingBlock

        public boolean containsAlignFormattingBlock()

      • setAlignFormattingUnchanged

        public void setAlignFormattingUnchanged()

      • containsBorderFormattingBlock

        public boolean containsBorderFormattingBlock()

      • setBorderFormatting

        public void setBorderFormatting​(BorderFormatting borderFormatting)

      • containsPatternFormattingBlock

        public boolean containsPatternFormattingBlock()

      • setPatternFormatting

        public void setPatternFormatting​(PatternFormatting patternFormatting)

      • containsProtectionFormattingBlock

        public boolean containsProtectionFormattingBlock()

      • setProtectionFormattingUnchanged

        public void setProtectionFormattingUnchanged()

      • getOptions

        public int getOptions()
        get the option flags
        Returns:
        bit mask

      • isLeftBorderModified

        public boolean isLeftBorderModified()

      • setLeftBorderModified

        public void setLeftBorderModified​(boolean modified)

      • isRightBorderModified

        public boolean isRightBorderModified()

      • setRightBorderModified

        public void setRightBorderModified​(boolean modified)

      • isTopBorderModified

        public boolean isTopBorderModified()

      • setTopBorderModified

        public void setTopBorderModified​(boolean modified)

      • isBottomBorderModified

        public boolean isBottomBorderModified()

      • setBottomBorderModified

        public void setBottomBorderModified​(boolean modified)

      • isTopLeftBottomRightBorderModified

        public boolean isTopLeftBottomRightBorderModified()

      • setTopLeftBottomRightBorderModified

        public void setTopLeftBottomRightBorderModified​(boolean modified)

      • isBottomLeftTopRightBorderModified

        public boolean isBottomLeftTopRightBorderModified()

      • setBottomLeftTopRightBorderModified

        public void setBottomLeftTopRightBorderModified​(boolean modified)

      • isPatternStyleModified

        public boolean isPatternStyleModified()

      • setPatternStyleModified

        public void setPatternStyleModified​(boolean modified)

      • isPatternColorModified

        public boolean isPatternColorModified()

      • setPatternColorModified

        public void setPatternColorModified​(boolean modified)

      • isPatternBackgroundColorModified

        public boolean isPatternBackgroundColorModified()

      • setPatternBackgroundColorModified

        public void setPatternBackgroundColorModified​(boolean modified)

      • getFormattingBlockSize

        protected int getFormattingBlockSize()

      • serializeFormattingBlock

        protected void serializeFormattingBlock​(LittleEndianOutput out)

      • getParsedExpression1

        public Ptg[] getParsedExpression1()
        get the stack of the 1st 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!

      • setParsedExpression1

        public void setParsedExpression1​(Ptg[] ptgs)

      • getFormula1

        protected Formula getFormula1()

      • setFormula1

        protected void setFormula1​(Formula formula1)

      • getParsedExpression2

        public Ptg[] getParsedExpression2()
        get the stack of the 2nd expression as a list
        Returns:
        array of Ptgs, possibly null

      • setParsedExpression2

        public void setParsedExpression2​(Ptg[] ptgs)

      • getFormula2

        protected Formula getFormula2()

      • setFormula2

        protected void setFormula2​(Formula formula2)

      • getFormulaSize

        protected static int getFormulaSize​(Formula formula)
        Parameters:
        formula - must not be null
        Returns:
        encoded size of the formula tokens (does not include 2 bytes for ushort length)

      • parseFormula

        public static Ptg[] parseFormula​(String formula,
                                 HSSFSheet sheet)
        TODO - parse conditional format formulas properly i.e. produce tRefN and tAreaN instead of tRef and tArea this call will produce the wrong results if the formula contains any cell references One approach might be to apply the inverse of SharedFormulaRecord.convertSharedFormulas(Stack, int, int) Note - two extra parameters (rowIx & colIx) will be required. They probably come from one of the Region objects.
        Parameters:
        formula - The formula to parse, excluding the leading equals sign.
        sheet - The sheet that the formula is on.
        Returns:
        null if formula was null.