Package org.apache.poi.hssf.record.cf

Examples of org.apache.poi.hssf.record.cf.PatternFormatting

164
165
166
167
168
169
170
171
172
173
174
    if (containsBorderFormattingBlock()) {
      borderFormatting = new BorderFormatting(in);
    }

    if (containsPatternFormattingBlock()) {
      patternFormatting = new PatternFormatting(in);
    }

    // "You may not use unions, intersections or array constants in Conditional Formatting criteria"
    field_17_formula1 = Formula.read(field_3_formula1_len, in);
    field_18_formula2 = Formula.read(field_4_formula2_len, in);
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
        assertFalse(record.isBottomLeftTopRightBorderModified());
        record.setBottomLeftTopRightBorderModified(true);
        assertTrue(record.isBottomLeftTopRightBorderModified());


        PatternFormatting patternFormatting = new PatternFormatting();
        testPatternFormattingAccessors(patternFormatting);
        assertFalse(record.containsPatternFormattingBlock());
        record.setPatternFormatting(patternFormatting);
        assertTrue(record.containsPatternFormattingBlock());
View Full Code Here
310
311
312
313
314
315
316
317
318
319
320
321
    public void testWrite() {
        HSSFWorkbook workbook = new HSSFWorkbook();
        HSSFSheet sheet = workbook.createSheet();
        CFRuleRecord rr = CFRuleRecord.create(sheet, ComparisonOperator.BETWEEN, "5", "10");

        PatternFormatting patternFormatting = new PatternFormatting();
        patternFormatting.setFillPattern(PatternFormatting.BRICKS);
        rr.setPatternFormatting(patternFormatting);

        byte[] data = rr.serialize();
        assertEquals(26, data.length);
        assertEquals(3, LittleEndian.getShort(data, 6));
View Full Code Here
127
128
129
130
131
132
133
134
135
136
137
        assertFalse(record.isBottomLeftTopRightBorderModified());
        record.setBottomLeftTopRightBorderModified(true);
        assertTrue(record.isBottomLeftTopRightBorderModified());


        PatternFormatting patternFormatting = new PatternFormatting();
        testPatternFormattingAccessors(patternFormatting);
        assertFalse(record.containsPatternFormattingBlock());
        record.setPatternFormatting(patternFormatting);
        assertTrue(record.containsPatternFormattingBlock());
View Full Code Here
303
304
305
306
307
308
309
310
311
312
313
314
    public void testWrite() {
        HSSFWorkbook workbook = new HSSFWorkbook();
        HSSFSheet sheet = workbook.createSheet();
        CFRuleRecord rr = CFRuleRecord.create(sheet, ComparisonOperator.BETWEEN, "5", "10");

        PatternFormatting patternFormatting = new PatternFormatting();
        patternFormatting.setFillPattern(PatternFormatting.BRICKS);
        rr.setPatternFormatting(patternFormatting);

        byte[] data = rr.serialize();
        assertEquals(26, data.length);
        assertEquals(3, LittleEndian.getShort(data, 6));
View Full Code Here
165
166
167
168
169
170
171
172
173
174
175
    if (containsBorderFormattingBlock()) {
      _borderFormatting = new BorderFormatting(in);
    }

    if (containsPatternFormattingBlock()) {
      _patternFormatting = new PatternFormatting(in);
    }

    // "You may not use unions, intersections or array constants in Conditional Formatting criteria"
    field_17_formula1 = Formula.read(field_3_formula1_len, in);
    field_18_formula2 = Formula.read(field_4_formula2_len, in);
View Full Code Here
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
    return getBorderFormatting(true);
  }
 
  private HSSFPatternFormatting getPatternFormatting(boolean create)
  {
    PatternFormatting patternFormatting = cfRuleRecord.getPatternFormatting();
    if ( patternFormatting != null)
    {
      cfRuleRecord.setPatternFormatting(patternFormatting);
      return new HSSFPatternFormatting(cfRuleRecord);
    }
    else if( create )
    {
      patternFormatting = new PatternFormatting();
      cfRuleRecord.setPatternFormatting(patternFormatting);
      return new HSSFPatternFormatting(cfRuleRecord);
    }
    else
    {
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
    assertFalse(record.isBottomLeftTopRightBorderModified());
    record.setBottomLeftTopRightBorderModified(true);
    assertTrue(record.isBottomLeftTopRightBorderModified());


    PatternFormatting patternFormatting = new PatternFormatting();
    testPatternFormattingAccessors(patternFormatting);
    assertFalse(record.containsPatternFormattingBlock());
    record.setPatternFormatting(patternFormatting);
    assertTrue(record.containsPatternFormattingBlock());
View Full Code Here
279
280
281
282
283
284
285
286
287
288
289
290
  public void testWrite() {
    HSSFWorkbook workbook = new HSSFWorkbook();
    CFRuleRecord rr = CFRuleRecord.create(workbook, ComparisonOperator.BETWEEN, "5", "10");

    PatternFormatting patternFormatting = new PatternFormatting();
    patternFormatting.setFillPattern(PatternFormatting.BRICKS);
    rr.setPatternFormatting(patternFormatting);

    byte[] data = rr.serialize();
    assertEquals(26, data.length);
    assertEquals(3, LittleEndian.getShort(data, 6));
View Full Code Here
202
203
204
205
206
207
208
209
210
211
212
      if (containsBorderFormattingBlock()) {
        borderFormatting = new BorderFormatting(in);
      }

      if (containsPatternFormattingBlock()) {
        patternFormatting = new PatternFormatting(in);
      }

      if (field_3_formula1_len > 0) {
        Stack ptgs = Ptg.createParsedExpressionTokens(field_3_formula1_len, in);
        // Now convert any fields as required
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.record.cf.PatternFormatting

  • org.apache.poi.hssf.record.CFRuleRecord
  • org.apache.poi.hssf.record.TestCFRuleRecord
  • org.apache.poi.hssf.usermodel.HSSFConditionalFormattingRule
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.