/**
  * Constructor
  *
  * @param t the record
  */
 public CalcModeRecord(Record t)
     : base(t)
 {
     byte[] data = t.getData();
     int mode = IntegerHelper.getInt(data[0],data[1]);
     automatic = (mode == 1);
 }
예제 #2
0
        /**
         * Constructs this object
         *
         * @param t the raw data
         * @param fr the formatting records
         * @param si the sheet
         */
        public ErrorRecord(Record t,FormattingRecords fr,SheetImpl si)
            : base(t,fr,si)
        {
            byte[] data = getRecord().getData();

            errorCode = data[6];
        }
        /**
         * Constructs this object from the raw data
         *
         * @param t the raw data
         */
        public NineteenFourRecord(Record t)
            : base(t)
        {
            byte[] data = getRecord().getData();

            nineteenFour = data[0] == 1 ? true : false;
        }
        /**
         * Constructs the def col width from the raw data
         *
         * @param t the raw data
         */
        public DefaultColumnWidthRecord(Record t)
            : base(t)
        {
            byte[] data = t.getData();

            width = IntegerHelper.getInt(data[0],data[1]);
        }
        /**
         * Constructs the value from the raw data
         *
         * @param pgl the raw data
         */
        public PrintHeadersRecord(Record ph)
            : base(ph)
        {
            byte[] data = ph.getData();

            printHeaders = (data[0] == 1 ? true : false);
        }
 /**
  * Constructor
  */
 public DataValidityListRecord(Record t)
     : base(t)
 {
     data = getRecord().getData();
     objectId = (uint)IntegerHelper.getInt(data[10],data[11],data[12],data[13]);
     numSettings = IntegerHelper.getInt(data[14],data[15],data[16],data[17]);
 }
        /**
         * Constructs this object from the raw data
         *
         * @param t the raw data
         * @param ws the workbook settings
         */
        public ExternalSheetRecord(Record t, WorkbookSettings ws)
            : base(t)
        {
            byte[] data = getRecord().getData();

            int numxtis = IntegerHelper.getInt(data[0],data[1]);

            if (data.Length < numxtis * 6 + 2)
                {
                xtiArray = new XTI[0];
                //logger.warn("Could not process external sheets.  Formulas may be compromised.");
                return;
                }

            xtiArray = new XTI[numxtis];

            int pos = 2;
            for (int i = 0; i < numxtis; i++)
                {
                int s = IntegerHelper.getInt(data[pos],data[pos + 1]);
                int f = IntegerHelper.getInt(data[pos + 2],data[pos + 3]);
                int l = IntegerHelper.getInt(data[pos + 4],data[pos + 5]);
                xtiArray[i] = new XTI(s,f,l);
                pos += 6;
                }
        }
        /**
         * Constructs this object from the raw data
         *
         * @param t the raw data
         * @param s the sheet
         */
        public MergedCellsRecord(Record t, Sheet s)
            : base(t)
        {
            byte[] data = getRecord().getData();

            int numRanges = IntegerHelper.getInt(data[0],data[1]);

            ranges = new Range[numRanges];

            int pos = 2;
            int firstRow = 0;
            int lastRow = 0;
            int firstCol = 0;
            int lastCol = 0;

            for (int i = 0; i < numRanges; i++)
                {
                firstRow = IntegerHelper.getInt(data[pos],data[pos + 1]);
                lastRow = IntegerHelper.getInt(data[pos + 2],data[pos + 3]);
                firstCol = IntegerHelper.getInt(data[pos + 4],data[pos + 5]);
                lastCol = IntegerHelper.getInt(data[pos + 6],data[pos + 7]);

                ranges[i] = new SheetRangeImpl(s,firstCol,firstRow,
                                               lastCol,lastRow);

                pos += 8;
                }
        }
 /**
  * Constructor
  */
 public ConditionalFormatRangeRecord(Record t)
     : base(t)
 {
     initialized = false;
     modified = false;
     data = getRecord().getData();
 }
 /**
  * Constructor
  *
  * @param t the record
  */
 public RefreshAllRecord(Record t)
     : base(t)
 {
     byte[] data = t.getData();
     int mode = IntegerHelper.getInt(data[0],data[1]);
     refreshAll = (mode == 1);
 }
 /**
  * Constructor
  *
  * @param t the record
  */
 public WindowProtectedRecord(Record t)
     : base(t)
 {
     byte[] data = t.getData();
     int mode = IntegerHelper.getInt(data[0],data[1]);
     windowProtected = (mode == 1);
 }
        /**
         * Constructs the value from the raw data
         *
         * @param pgl the raw data
         */
        public PrintGridLinesRecord(Record pgl)
            : base(pgl)
        {
            byte[] data = pgl.getData();

            printGridLines = (data[0] == 1 ? true : false);
        }
 /**
  * Constructor
  *
  * @param t the record
  */
 public SaveRecalcRecord(Record t)
     : base(t)
 {
     byte[] data = t.getData();
     int mode = IntegerHelper.getInt(data[0],data[1]);
     recalculateOnSave = (mode == 1);
 }
예제 #14
0
        /**
         * Constructs this object from the raw data
         *
         * @param t the raw data
         * @param fr the formatting records
         * @param si the sheet
         * @param ws the workbook settings
         * @param dummy dummy overload to indicate a biff 7 workbook
         */
        public RStringRecord(Record t,FormattingRecords fr,SheetImpl si,WorkbookSettings ws,Biff7 dummy)
            : base(t,fr,si)
        {
            byte[] data = getRecord().getData();
            length = IntegerHelper.getInt(data[6],data[7]);

            description = StringHelper.getString(data,length,8,ws);
        }
예제 #15
0
        /**
         * Constructs this object from the raw data
         *
         * @param t the raw data
         */
        public ProtectRecord(Record t)
            : base(t)
        {
            byte[] data = getRecord().getData();

            int protflag = IntegerHelper.getInt(data[0],data[1]);
            prot = (protflag == 1);
        }
예제 #16
0
        /**
         * Constructs the dimensions from the raw data
         *
         * @param t the raw data
         */
        public PaneRecord(Record t)
            : base(t)
        {
            byte[] data = t.getData();

            columnsVisible = IntegerHelper.getInt(data[0],data[1]);
            rowsVisible = IntegerHelper.getInt(data[2],data[3]);
        }
예제 #17
0
        /**
         * Constructs this record from the raw data
         * @param r the record
         */
        public SCLRecord(Record r)
            : base(Type.SCL)
        {
            byte[] data = r.getData();

            numerator = IntegerHelper.getInt(data[0],data[1]);
            denominator = IntegerHelper.getInt(data[2],data[3]);
        }
예제 #18
0
        /**
         * Constructs the dimensions from the raw data
         *
         * @param t the raw data
         */
        public CountryRecord(Record t)
            : base(t)
        {
            byte[] data = t.getData();

            language = IntegerHelper.getInt(data[0],data[1]);
            regionalSettings = IntegerHelper.getInt(data[2],data[3]);
        }
예제 #19
0
 /**
  * Constructs this object from the raw data
  *
  * @param t the raw data
  */
 public NoteRecord(Record t)
     : base(t)
 {
     data = getRecord().getData();
     row = IntegerHelper.getInt(data[0],data[1]);
     column = IntegerHelper.getInt(data[2],data[3]);
     objectId = (uint)IntegerHelper.getInt(data[6],data[7]);
 }
예제 #20
0
 /**
  * Constructs this object from the raw data
  *
  * @param r the raw data
  */
 public GuttersRecord(Record r)
     : base(r)
 {
     byte[] data = getRecord().getData();
     width = IntegerHelper.getInt(data[0],data[1]);
     height = IntegerHelper.getInt(data[2],data[3]);
     rowOutlineLevel = IntegerHelper.getInt(data[4],data[5]);
     columnOutlineLevel = IntegerHelper.getInt(data[6],data[7]);
 }
        /**
         * Constructs the def col width from the raw data
         *
         * @param t the raw data
         */
        public DefaultRowHeightRecord(Record t)
            : base(t)
        {
            byte[] data = t.getData();

            if (data.Length > 2)
                {
                height = IntegerHelper.getInt(data[2],data[3]);
                }
        }
예제 #22
0
        /**
         * Constructs this object from the raw data
         *
         * @param t the raw data
         * @param fr the formatting records
         * @param si the sheet
         * @param ws the workbook settings
         */
        public LabelRecord(Record t,FormattingRecords fr,SheetImpl si,WorkbookSettings ws)
            : base(t,fr,si)
        {
            byte[] data = getRecord().getData();
            length = IntegerHelper.getInt(data[6],data[7]);

            if (data[8] == 0x0)
                description = StringHelper.getString(data,length,9,ws);
            else
                description = StringHelper.getUnicodeString(data,length,9);
        }
 /**
  * Constructor
  */
 public DataValiditySettingsRecord(Record t,
     ExternalSheet es,
     WorkbookMethods wm,
     WorkbookSettings ws)
     : base(t)
 {
     data = t.getData();
     externalSheet = es;
     workbook = wm;
     workbookSettings = ws;
 }
 /**
  * Constructs this number
  *
  * @param t the data
  * @param excelFile the excel biff data
  * @param v the value
  * @param fr the formatting records
  * @param es the external sheet
  * @param nt the name table
  * @param si the sheet
  */
 public SharedBooleanFormulaRecord(Record t,
     File excelFile,
     bool v,
     FormattingRecords fr,
     ExternalSheet es,
     WorkbookMethods nt,
     SheetImpl si)
     : base(t,fr,es,nt,si,excelFile.getPos())
 {
     value = v;
 }
 /**
  * Constructs this number
  *
  * @param t the data
  * @param excelFile the excel biff data
  * @param v the errorCode
  * @param fr the formatting records
  * @param es the external sheet
  * @param nt the name table
  * @param si the sheet
  */
 public SharedErrorFormulaRecord(Record t,
     File excelFile,
     int ec,
     FormattingRecords fr,
     ExternalSheet es,
     WorkbookMethods nt,
     SheetImpl si)
     : base(t,fr,es,nt,si,excelFile.getPos())
 {
     errorCode = ec;
 }
예제 #26
0
        /**
         * Constructs this object from the raw data
         *
         * @param t the raw data
         * @param fr the available formats
         * @param si the sheet
         */
        public NumberRecord(Record t,FormattingRecords fr,SheetImpl si)
            : base(t,fr,si)
        {
            byte[] data = getRecord().getData();

            value = DoubleHelper.getIEEEDouble(data,6);

            // Now get the number format
            format = fr.getNumberFormat(getXFIndex());
            if (format == null)
                format = defaultFormat;
        }
        /**
         * Constructs this object from the raw data
         *
         * @param t the raw data
         * @param fr the formatting records
         * @param es the external sheet
         * @param nt the name table
         * @param si the sheet
         */
        public ErrorFormulaRecord(Record t,FormattingRecords fr,ExternalSheet es,
            WorkbookMethods nt,SheetImpl si)
            : base(t,fr,si)
        {
            externalSheet = es;
            nameTable = nt;
            data = getRecord().getData();

            Assert.verify(data[6] == 2);

            errorCode = data[8];
        }
 /**
  * Constructs the dimensions from the raw data
  *
  * @param t the raw data
  * @param biff7 an indicator to initialise this record for biff 7 format
  */
 public HorizontalPageBreaksRecord(Record t,Biff7 biff7)
     : base(t)
 {
     byte[] data = t.getData();
     int numbreaks = IntegerHelper.getInt(data[0],data[1]);
     int pos = 2;
     rowBreaks = new int[numbreaks];
     for (int i = 0; i < numbreaks; i++)
         {
         rowBreaks[i] = IntegerHelper.getInt(data[pos],data[pos + 1]);
         pos += 2;
         }
 }
 /**
  * Constructs this number
  *
  * @param t the data
  * @param excelFile the excel biff data
  * @param v the value
  * @param fr the formatting records
  * @param es the external sheet
  * @param nt the name table
  * @param si the sheet
  */
 public SharedNumberFormulaRecord(Record t,
     File excelFile,
     double v,
     FormattingRecords fr,
     ExternalSheet es,
     WorkbookMethods nt,
     SheetImpl si)
     : base(t,fr,es,nt,si,excelFile.getPos())
 {
     value = v;
     format = defaultFormat;    // format is set up later from the
     // SharedFormulaRecord
 }
예제 #30
0
        /**
         * Constructs the blank records from the raw data
         *
         * @param t the raw data
         */
        public MulBlankRecord(Record t)
            : base(t)
        {
            byte[] data = getRecord().getData();
            int length = getRecord().getLength();
            row = IntegerHelper.getInt(data[0],data[1]);
            colFirst = IntegerHelper.getInt(data[2],data[3]);
            colLast = IntegerHelper.getInt(data[length - 2],data[length - 1]);
            numblanks = colLast - colFirst + 1;
            xfIndices = new int[numblanks];

            readBlanks(data);
        }
예제 #31
0
        /**
         * Constructor which creates this object from the binary data
         *
         * @param t the record
         */
        public SetupRecord(Record t)
            : base(Type.SETUP)
        {
            data = t.getData();

            paperSize   = IntegerHelper.getInt(data[0], data[1]);
            scaleFactor = IntegerHelper.getInt(data[2], data[3]);
            pageStart   = IntegerHelper.getInt(data[4], data[5]);
            fitWidth    = IntegerHelper.getInt(data[6], data[7]);
            fitHeight   = IntegerHelper.getInt(data[8], data[9]);
            horizontalPrintResolution = IntegerHelper.getInt(data[12], data[13]);
            verticalPrintResolution   = IntegerHelper.getInt(data[14], data[15]);
            copies = IntegerHelper.getInt(data[32], data[33]);

            headerMargin = DoubleHelper.getIEEEDouble(data, 16);
            footerMargin = DoubleHelper.getIEEEDouble(data, 24);

            int grbit = IntegerHelper.getInt(data[10], data[11]);

            pageOrder           = ((grbit & 0x01) != 0);
            portraitOrientation = ((grbit & 0x02) != 0);
            initialized         = ((grbit & 0x04) == 0);
        }
예제 #32
0
        /**
         * Constructs this object from the raw data
         *
         * @param t the record data
         * @param ws the workbook settings
         */
        public FooterRecord(Record t, WorkbookSettings ws)
            : base(t)
        {
            byte[] data = getRecord().getData();

            if (data.Length == 0)
            {
                return;
            }

            int chars = IntegerHelper.getInt(data[0], data[1]);

            bool unicode = data[2] == 1;

            if (unicode)
            {
                footer = StringHelper.getUnicodeString(data, chars, 3);
            }
            else
            {
                footer = StringHelper.getString(data, chars, 3, ws);
            }
        }
예제 #33
0
        /**
         * Writes out the biff record
         * @param r
         * @exception IOException if an error occurs
         */
        private bool writeRecord(CSharpJExcel.Jxl.Read.Biff.Record r, TextWriter os)
        {
            bool cont = true;
            int  pos  = reader.getPos();
            int  code = r.getCode();

            if (bofs == 0)
            {
                cont = (r.getType() == CSharpJExcel.Jxl.Biff.Type.BOF);
            }

            if (!cont)
            {
                return(cont);
            }

            if (r.getType() == CSharpJExcel.Jxl.Biff.Type.BOF)
            {
                bofs++;
            }

            if (r.getType() == CSharpJExcel.Jxl.Biff.Type.EOF)
            {
                bofs--;
            }

            StringBuilder buf = new StringBuilder();

            // Write out the record header
            writeSixDigitValue(pos, buf);
            buf.Append(" [");
            buf.Append(recordNames[r.getType()]);
            buf.Append("]");
            buf.Append("  (0x");
            buf.Append(code.ToString("x"));
            buf.Append(")");

            if (code == CSharpJExcel.Jxl.Biff.Type.XF.value)
            {
                buf.Append(" (0x");
                buf.Append(xfIndex.ToString("x"));
                buf.Append(")");
                xfIndex++;
            }

            if (code == CSharpJExcel.Jxl.Biff.Type.FONT.value)
            {
                if (fontIndex == 4)
                {
                    fontIndex++;
                }

                buf.Append(" (0x");
                buf.Append(fontIndex.ToString("x"));
                buf.Append(")");
                fontIndex++;
            }

            os.Write(buf.ToString());
            os.WriteLine();

            byte[] standardData = new byte[4];
            standardData[0] = (byte)(code & 0xff);
            standardData[1] = (byte)((code & 0xff00) >> 8);
            standardData[2] = (byte)(r.getLength() & 0xff);
            standardData[3] = (byte)((r.getLength() & 0xff00) >> 8);
            byte[] recordData = r.getData();
            byte[] data       = new byte[standardData.Length + recordData.Length];
            Array.Copy(standardData, 0, data, 0, standardData.Length);
            Array.Copy(recordData, 0, data, standardData.Length, recordData.Length);

            int byteCount = 0;
            int lineBytes = 0;

            while (byteCount < data.Length)
            {
                buf = new StringBuilder();
                writeSixDigitValue(pos + byteCount, buf);
                buf.Append("   ");

                lineBytes = Math.Min(bytesPerLine, data.Length - byteCount);

                for (int i = 0; i < lineBytes; i++)
                {
                    writeByte(data[i + byteCount], buf);
                    buf.Append(' ');
                }

                // Perform any padding
                if (lineBytes < bytesPerLine)
                {
                    for (int i = 0; i < bytesPerLine - lineBytes; i++)
                    {
                        buf.Append("   ");
                    }
                }

                buf.Append("  ");

                for (int i = 0; i < lineBytes; i++)
                {
                    char c = (char)data[i + byteCount];
                    if (c < ' ' || c > 'z')
                    {
                        c = '.';
                    }
                    buf.Append(c);
                }

                byteCount += lineBytes;

                os.Write(buf.ToString());
                os.WriteLine();
            }

            return(cont);
        }
예제 #34
0
 /**
  * Constructor
  *
  * @param r the record
  */
 public TopMarginRecord(Record r)
     : base(Type.TOPMARGIN, r)
 {
 }