Examples of PatternFormatting

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

302
303
304
305
306
307
308
309
310
311
312
313
    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

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

129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
    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

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

173
174
175
176
177
178
179
180
181
182
183
    if (containsBorderFormattingBlock()) {
      borderFormatting = new BorderFormatting(in);
    }

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

    if (field_3_formula1_len > 0) {
      field_17_formula1 = Ptg.readTokens(field_3_formula1_len, in);
    }
View Full Code Here

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

105
106
107
108
109
110
111
112
113
114
115
    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

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

283
284
285
286
287
288
289
290
291
292
293
294
  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

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

130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
    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

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

163
164
165
166
167
168
169
170
171
172
173
    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

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

177
178
179
180
181
182
183
184
185
186
187
    if (containsBorderFormattingBlock()) {
      borderFormatting = new BorderFormatting(in);
    }

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

    if (field_3_formula1_len > 0) {
      field_17_formula1 = Ptg.readTokens(field_3_formula1_len, in);
    }
View Full Code Here

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
TOP
Copyright © 2018 www.massapi.com. 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.