public override Object Clone() { BoolErrRecord rec = new BoolErrRecord(); CopyBaseFields(rec); rec._value = _value; rec._isError = _isError; return(rec); }
public void TestError() { byte[] data = HexRead.ReadFromString( "00 00 00 00 0F 00 " + // row, col, xfIndex "07 01 " // #DIV/0!, isError ); RecordInputStream in1 = TestcaseRecordInputStream.Create(BoolErrRecord.sid, data); BoolErrRecord ber = new BoolErrRecord(in1); Assert.IsTrue(ber.IsError); Assert.AreEqual(7, ber.ErrorValue); TestcaseRecordInputStream.ConfirmRecordEncoding(BoolErrRecord.sid, data, ber.Serialize()); }
public void TestOooBadFormat_bug47479() { byte[] data = HexRead.ReadFromString( "05 02 09 00 " + // sid, size "00 00 00 00 0F 00 " + // row, col, xfIndex "01 00 00 " // extra 00 byte here ); RecordInputStream in1 = TestcaseRecordInputStream.Create(data); BoolErrRecord ber = new BoolErrRecord(in1); bool hasMore; try { hasMore = in1.HasNextRecord; } catch (LeftoverDataException e) { if ("Initialisation of record 0x205 left 1 bytes remaining still to be Read.".Equals(e.Message)) { throw new AssertionException("Identified bug 47479"); } throw e; } Assert.IsFalse(hasMore); Assert.IsTrue(ber.IsBoolean); Assert.AreEqual(true, ber.BooleanValue); // Check that the record re-Serializes correctly byte[] outData = ber.Serialize(); byte[] expData = HexRead.ReadFromString( "05 02 08 00 " + "00 00 00 00 0F 00 " + "01 00 " // normal number of data bytes ); Assert.IsTrue(Arrays.Equals(expData, outData)); }
/// <summary> /// Sets the cell type. The SetValue flag indicates whether to bother about /// trying to preserve the current value in the new record if one is Created. /// The SetCellValue method will call this method with false in SetValue /// since it will overWrite the cell value later /// </summary> /// <param name="cellType">Type of the cell.</param> /// <param name="setValue">if set to <c>true</c> [set value].</param> /// <param name="row">The row.</param> /// <param name="col">The col.</param> /// <param name="styleIndex">Index of the style.</param> private void SetCellType(CellType cellType, bool setValue, int row, int col, short styleIndex) { if (cellType > CellType.ERROR) { throw new Exception("I have no idea what type that Is!"); } switch (cellType) { case CellType.FORMULA: FormulaRecordAggregate frec = null; if (cellType != this.cellType) { frec = sheet.Sheet.RowsAggregate.CreateFormula(row, col); } else { frec = (FormulaRecordAggregate)record; } frec.Column = col; if (setValue) { frec.FormulaRecord.Value = NumericCellValue; } frec.XFIndex = styleIndex; frec.Row = row; record = frec; break; case CellType.NUMERIC: NumberRecord nrec = null; if (cellType != this.cellType) { nrec = new NumberRecord(); } else { nrec = (NumberRecord)record; } nrec.Column = col; if (setValue) { nrec.Value = NumericCellValue; } nrec.XFIndex = styleIndex; nrec.Row = row; record = nrec; break; case CellType.STRING: LabelSSTRecord lrec = null; if (cellType != this.cellType) { lrec = new LabelSSTRecord(); } else { lrec = (LabelSSTRecord)record; } lrec.Column = col; lrec.Row = row; lrec.XFIndex = styleIndex; if (setValue) { String str = ConvertCellValueToString(); int sstIndex = book.Workbook.AddSSTString(new UnicodeString(str)); lrec.SSTIndex = (sstIndex); UnicodeString us = book.Workbook.GetSSTString(sstIndex); stringValue = new HSSFRichTextString(); stringValue.UnicodeString = us; } record = lrec; break; case CellType.BLANK: BlankRecord brec = null; if (cellType != this.cellType) { brec = new BlankRecord(); } else { brec = (BlankRecord)record; } brec.Column = col; // During construction the cellStyle may be null for a Blank cell. brec.XFIndex = styleIndex; brec.Row = row; record = brec; break; case CellType.BOOLEAN: BoolErrRecord boolRec = null; if (cellType != this.cellType) { boolRec = new BoolErrRecord(); } else { boolRec = (BoolErrRecord)record; } boolRec.Column = col; if (setValue) { boolRec.SetValue(ConvertCellValueToBoolean()); } boolRec.XFIndex = styleIndex; boolRec.Row = row; record = boolRec; break; case CellType.ERROR: BoolErrRecord errRec = null; if (cellType != this.cellType) { errRec = new BoolErrRecord(); } else { errRec = (BoolErrRecord)record; } errRec.Column = col; if (setValue) { errRec.SetValue((byte)HSSFErrorConstants.ERROR_VALUE); } errRec.XFIndex = styleIndex; errRec.Row = row; record = errRec; break; } if (cellType != this.cellType && this.cellType != CellType.Unknown) // Special Value to indicate an Uninitialized Cell { sheet.Sheet.ReplaceValueRecord(record); } this.cellType = cellType; }
public override Object Clone() { BoolErrRecord rec = new BoolErrRecord(); CopyBaseFields(rec); rec._value = _value; rec._isError = _isError; return rec; }
public override Object Clone() { BoolErrRecord rec = new BoolErrRecord(); rec.field_1_row = field_1_row; rec.field_2_column = field_2_column; rec.field_3_xf_index = field_3_xf_index; rec.field_4_bBoolErr = field_4_bBoolErr; rec.field_5_fError = field_5_fError; return rec; }