1 ////////////////////////////////////////////////////////////////////////////////
2 // MillScript-Excel: an Open Spice interpreter and batch website creation tool
3 // Copyright (C) 2006 Open World Ltd, Kevin Rogers
4 //
5 // This file is part of MillScript-Excel.
6 //
7 // MillScript-Excel is free software; you can redistribute it and/or modify it under
8 // the terms of the GNU General Public License as published by the Free
9 // Software Foundation; either version 2 of the License, or (at your option)
10 // any later version.
11 //
12 // MillScript-Excel is distributed in the hope that it will be useful, but WITHOUT
13 // ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
14 // FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
15 // more details.
16 //
17 // You should have received a copy of the GNU General Public License along with
18 // MillScript-Excel; if not, write to the Free Software Foundation, Inc., 59 Temple
19 // Place, Suite 330, Boston, MA 02111-1307 USA
20 ////////////////////////////////////////////////////////////////////////////////
21 package org.millscript.office.excel.records.formula;
22
23 import org.millscript.millscript.expr.SkipExpr;
24 import org.millscript.office.excel.FormulaTokenSyntax;
25 import org.millscript.office.excel.FormulaTokenizer;
26 import org.millscript.office.excel.records.substructures.CellRangeAddress;
27 import org.millscript.office.excel.versions.BIFF5;
28 import org.millscript.office.excel.versions.BIFF7;
29 import org.millscript.office.excel.versions.BIFF8;
30 import org.millscript.office.excel.versions.BIFF8X;
31
32 /**
33 *
34 */
35 public class Area3dTokenSyntax extends FormulaTokenSyntax implements BIFF5, BIFF7, BIFF8, BIFF8X {
36
37 /**
38 * @see org.millscript.office.excel.FormulaTokenSyntax#newToken(org.millscript.office.excel.FormulaTokenizer)
39 */
40 @Override
41 public void newToken( final FormulaTokenizer tokenizer ) {
42 // Area3d
43 switch ( tokenizer.getBiffVersion() ) {
44 case BIFF5:
45 case BIFF7:
46 final int externsheetIndex = tokenizer.read2ByteInt();
47 if ( externsheetIndex < 0 ) {
48 // This is a 3D reference
49 tokenizer.skipBytes( 8 );
50 final int firstSheetIndex = tokenizer.readUnsigned2Byte();
51 final int secondSheetIndex = tokenizer.readUnsigned2Byte();
52 } else {
53 tokenizer.skipBytes( 12 );
54 }
55 final CellRangeAddress range = tokenizer.readCellRangeAddress();
56 break;
57 default:
58 // BIFF8+
59 final int refIndex = tokenizer.readUnsigned2Byte();
60 final CellRangeAddress range2 = tokenizer.readCellRangeAddress();
61 break;
62 }
63 // FIXME - This really isn't the right thing to do...
64 tokenizer.pushExpr(
65 new SkipExpr()
66 );
67 }
68
69 }