Description: sheet window settings
REFERENCE: PG 422 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
@author Andrew C. Oliver (acoliver at apache dot org) @author Jason Height (jheight at chariot dot net dot au) @version 2.0-pre
173174175176177178179180181182183
BOFRecord.createSheetBOF(), new HeaderRecord("&LSales Figures"), new FooterRecord("&LJanuary"), new DimensionsRecord(), createBottomMargin(0.787F), new WindowTwoRecord(), EOFRecord.instance, }; RecordStream rs = new RecordStream(Arrays.asList(recs), 0); Sheet sheet;
111311141115111611171118111911201121112211231124112511261127
* headercolor = 0x40 <P> * pagebreakzoom = 0x0 <P> * normalzoom = 0x0 <p> */ private static WindowTwoRecord createWindowTwo() { WindowTwoRecord retval = new WindowTwoRecord(); retval.setOptions(( short ) 0x6b6); retval.setTopRow(( short ) 0); retval.setLeftCol(( short ) 0); retval.setHeaderColor(0x40); retval.setPageBreakZoom(( short ) 0); retval.setNormalZoom(( short ) 0); return retval; }
87888990919293949596979899100
assertTrue(outRecs[pos++] instanceof WindowTwoRecord ); assertTrue(outRecs[pos++] instanceof EOFRecord ); } private static Record createWindow2Record() { WindowTwoRecord result = new WindowTwoRecord(); result.setOptions(( short ) 0x6b6); result.setTopRow(( short ) 0); result.setLeftCol(( short ) 0); result.setHeaderColor(0x40); result.setPageBreakZoom(( short ) 0); result.setNormalZoom(( short ) 0); return result; }
4041424344454647484950
Record[] inRecs = { new RowRecord(0), new NumberRecord(), // normally MSODRAWING(0x00EC) would come here before SXVIEW new UnknownRecord(SXVIEW_SID, "dummydata (SXVIEW: View Definition)".getBytes()), new WindowTwoRecord(), }; RecordStream rs = new RecordStream(Arrays.asList(inRecs), 0); RowBlocksReader rbr = new RowBlocksReader(rs); if (rs.peekNextClass() == WindowTwoRecord.class) { // Should have stopped at the SXVIEW record
5657585960616263646566
*/ public void testSharedFormula() { List<Record> records = new ArrayList<Record>(); records.add(new FormulaRecord()); records.add(new SharedFormulaRecord()); records.add(new WindowTwoRecord()); constructValueRecord(records); CellValueRecordInterface[] cvrs = valueRecord.getValueRecords(); //Ensure that the SharedFormulaRecord has been converted assertEquals(1, cvrs.length);
8889909192939495
formulaRecord.setColumn((short) 1); blankRecord.setRow(2); blankRecord.setColumn((short) 2); records.add(formulaRecord); records.add(blankRecord); records.add(new WindowTwoRecord()); return records; }
112611271128112911301131113211331134113511361137113811391140