Examples of org.apache.poi.hssf.record.ExternSheetRecord$RefSubRecord

org.apache.poi.hssf.record.ExternSheetRecord
EXTERNSHEET (0x0017)
A List of Indexes to EXTERNALBOOK (supplemental book) Records
@author Libin Roman (Vista Portal LDT. Developer)

    _workbookRecordList = workbookRecordList;
    _definedNames = new ArrayList();
    _externalBookBlocks = new ExternalBookBlock[] {
        new ExternalBookBlock(numberOfSheets),
    };
    _externSheetRecord = new ExternSheetRecord();
    _recordCount = 2;


    // tell _workbookRecordList about the 2 new records


    SupBookRecord supbook = _externalBookBlocks[0].getExternalBookRecord();

View Full Code Here

    _workbookRecordList = workbookRecordList;
    _definedNames = new ArrayList();
    _externalBookBlocks = new ExternalBookBlock[] {
        new ExternalBookBlock(numberOfSheets),
    };
    _externSheetRecord = new ExternSheetRecord();
    _recordCount = 2;


    // tell _workbookRecordList about the 2 new records


    SupBookRecord supbook = _externalBookBlocks[0].getExternalBookRecord();

View Full Code Here

        assertEquals(5, wrl.getRecords().size());
        assertTrue(wrl.get(2) instanceof SupBookRecord);
        SupBookRecord sup1 = (SupBookRecord)wrl.get(2);
        assertEquals(numberOfSheets, sup1.getNumberOfSheets());
        assertTrue(wrl.get(3) instanceof ExternSheetRecord);
        ExternSheetRecord extSheet = (ExternSheetRecord)wrl.get(3);
        assertEquals(0, extSheet.getNumOfRefs());


        assertNull(tbl.getNameXPtg("ISODD", -1));
        assertEquals(5, wrl.getRecords().size()); //still have five records


        NameXPtg namex1 = tbl.addNameXPtg("ISODD");  // adds two new rercords
        assertEquals(0, namex1.getSheetRefIndex());
        assertEquals(0, namex1.getNameIndex());
        assertEquals(namex1.toString(), tbl.getNameXPtg("ISODD", -1).toString());
        
        // Can only find on the right sheet ref, if restricting
        assertEquals(namex1.toString(), tbl.getNameXPtg("ISODD", 0).toString());
        assertNull(tbl.getNameXPtg("ISODD", 1));
        assertNull(tbl.getNameXPtg("ISODD", 2));
        
        // assure they are in place:
        //    [BOFRecord]
        //    [CountryRecord]
        //    [SUPBOOK Internal References  nSheets= 3]
        //    [SUPBOOK Add-In Functions nSheets= 1]
        //    [EXTERNALNAME .name    = ISODD]
        //    [EXTERNSHEET]
        //    [EOFRecord]


        assertEquals(7, wrl.getRecords().size());
        assertTrue(wrl.get(3) instanceof SupBookRecord);
        SupBookRecord sup2 = (SupBookRecord)wrl.get(3);
        assertTrue(sup2.isAddInFunctions());
        assertTrue(wrl.get(4) instanceof ExternalNameRecord);
        ExternalNameRecord ext1 = (ExternalNameRecord)wrl.get(4);
        assertEquals("ISODD", ext1.getText());
        assertTrue(wrl.get(5) instanceof ExternSheetRecord);
        assertEquals(1, extSheet.getNumOfRefs());


        //check that
        assertEquals(0, tbl.resolveNameXIx(namex1.getSheetRefIndex(), namex1.getNameIndex()));
        assertEquals("ISODD", tbl.resolveNameXText(namex1.getSheetRefIndex(), namex1.getNameIndex(), null));

View Full Code Here

    _workbookRecordList = workbookRecordList;
    _definedNames = new ArrayList();
    _externalBookBlocks = new ExternalBookBlock[] {
        new ExternalBookBlock(numberOfSheets),
    };
    _externSheetRecord = new ExternSheetRecord();
    _recordCount = 2;


    // tell _workbookRecordList about the 2 new records


    SupBookRecord supbook = _externalBookBlocks[0].getExternalBookRecord();

View Full Code Here

    _workbookRecordList = workbookRecordList;
    _definedNames = new ArrayList<NameRecord>();
    _externalBookBlocks = new ExternalBookBlock[] {
        new ExternalBookBlock(numberOfSheets),
    };
    _externSheetRecord = new ExternSheetRecord();
    _recordCount = 2;


    // tell _workbookRecordList about the 2 new records


    SupBookRecord supbook = _externalBookBlocks[0].getExternalBookRecord();

View Full Code Here

    _workbookRecordList = workbookRecordList;
    _definedNames = new ArrayList<NameRecord>();
    _externalBookBlocks = new ExternalBookBlock[] {
        new ExternalBookBlock(numberOfSheets),
    };
    _externSheetRecord = new ExternSheetRecord();
    _recordCount = 2;


    // tell _workbookRecordList about the 2 new records


    SupBookRecord supbook = _externalBookBlocks[0].getExternalBookRecord();

View Full Code Here

    _workbookRecordList = workbookRecordList;
    _definedNames = new ArrayList();
    _externalBookBlocks = new ExternalBookBlock[] {
        new ExternalBookBlock(numberOfSheets),
    };
    _externSheetRecord = new ExternSheetRecord();
    _recordCount = 2;


    // tell _workbookRecordList about the 2 new records


    SupBookRecord supbook = _externalBookBlocks[0].getExternalBookRecord();

View Full Code Here

    _workbookRecordList = workbookRecordList;
    _definedNames = new ArrayList<NameRecord>();
    _externalBookBlocks = new ExternalBookBlock[] {
        new ExternalBookBlock(numberOfSheets),
    };
    _externSheetRecord = new ExternSheetRecord();
    _recordCount = 2;


    // tell _workbookRecordList about the 2 new records


    SupBookRecord supbook = _externalBookBlocks[0].getExternalBookRecord();

View Full Code Here

    _workbookRecordList = workbookRecordList;
    _definedNames = new ArrayList<NameRecord>();
    _externalBookBlocks = new ExternalBookBlock[] {
        new ExternalBookBlock(numberOfSheets),
    };
    _externSheetRecord = new ExternSheetRecord();
    _recordCount = 2;


    // tell _workbookRecordList about the 2 new records


    SupBookRecord supbook = _externalBookBlocks[0].getExternalBookRecord();

View Full Code Here

    _workbookRecordList = workbookRecordList;
    _definedNames = new ArrayList();
    _externalBookBlocks = new ExternalBookBlock[] {
        new ExternalBookBlock(numberOfSheets),
    };
    _externSheetRecord = new ExternSheetRecord();
    _recordCount = 2;


    // tell _workbookRecordList about the 2 new records


    SupBookRecord supbook = _externalBookBlocks[0].getExternalBookRecord();

View Full Code Here

0 1

TOP

Related Classes of org.apache.poi.hssf.record.ExternSheetRecord$RefSubRecord

org.apache.poi.hssf.model.LinkTable

org.apache.poi.hssf.model.TestLinkTable

java.util.ArrayList

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.