Examples with MulBlankRecord org.apache.poi.hssf.record.MulBlankRecord used on opensource projects

Example 6 with MulBlankRecord

use of org.apache.poi.hssf.record.MulBlankRecord in project poi by apache.

the class TestValueRecordsAggregate method testMultipleBlanks.

/**
	 * Tests various manipulations of blank cells, to make sure that {@link MulBlankRecord}s
	 * are use appropriately
	 */
@Test
public void testMultipleBlanks() {
    BlankRecord brA2 = newBlankRecord(0, 1);
    BlankRecord brB2 = newBlankRecord(1, 1);
    BlankRecord brC2 = newBlankRecord(2, 1);
    BlankRecord brD2 = newBlankRecord(3, 1);
    BlankRecord brE2 = newBlankRecord(4, 1);
    BlankRecord brB3 = newBlankRecord(1, 2);
    BlankRecord brC3 = newBlankRecord(2, 2);
    valueRecord.insertCell(brA2);
    valueRecord.insertCell(brB2);
    valueRecord.insertCell(brD2);
    confirmMulBlank(3, 1, 1);
    valueRecord.insertCell(brC3);
    confirmMulBlank(4, 1, 2);
    valueRecord.insertCell(brB3);
    valueRecord.insertCell(brE2);
    confirmMulBlank(6, 3, 0);
    valueRecord.insertCell(brC2);
    confirmMulBlank(7, 2, 0);
    valueRecord.removeCell(brA2);
    confirmMulBlank(6, 2, 0);
    valueRecord.removeCell(brC2);
    confirmMulBlank(5, 2, 1);
    valueRecord.removeCell(brC3);
    confirmMulBlank(4, 1, 2);
}