public void TestLoad()
{
LegendRecord record = new LegendRecord(TestcaseRecordInputStream.Create((short)0x1015, data));
Assert.AreEqual((int)0xe76, record.XAxisUpperLeft);
Assert.AreEqual((int)0x786, record.YAxisUpperLeft);
Assert.AreEqual((int)0x119, record.XSize);
Assert.AreEqual((int)0x8b, record.YSize);
Assert.AreEqual((byte)0x3, record.Type);
Assert.AreEqual((byte)0x1, record.Spacing);
Assert.AreEqual((short)0x1f, record.Options);
Assert.AreEqual(true, record.IsAutoPosition);
Assert.AreEqual(true, record.IsAutoSeries);
Assert.AreEqual(true, record.IsAutoXPositioning);
Assert.AreEqual(true, record.IsAutoYPositioning);
Assert.AreEqual(true, record.IsVertical);
Assert.AreEqual(false, record.IsDataTable);
Assert.AreEqual(24, record.RecordSize);
}
public void TestLoad()
{
DefaultTextRecord record = new DefaultTextRecord(TestcaseRecordInputStream.Create((short)0x1024, data));
Assert.AreEqual(2, (int)record.FormatType);
Assert.AreEqual(6, record.RecordSize);
}
public void TestLoad()
{
TextRecord record = new TextRecord(TestcaseRecordInputStream.Create((short)0x1025, data));
Assert.AreEqual(TextRecord.HORIZONTAL_ALIGNMENT_CENTER, record.HorizontalAlignment);
Assert.AreEqual(TextRecord.VERTICAL_ALIGNMENT_CENTER, record.VerticalAlignment);
Assert.AreEqual(TextRecord.DISPLAY_MODE_TRANSPARENT, record.DisplayMode);
Assert.AreEqual(0, record.RgbColor);
Assert.AreEqual(-42, record.X);
Assert.AreEqual(-60, record.Y);
Assert.AreEqual(0, record.Width);
Assert.AreEqual(0, record.Height);
Assert.AreEqual(177, record.Options1);
Assert.AreEqual(true, record.IsAutoColor);
Assert.AreEqual(false, record.ShowKey);
Assert.AreEqual(false, record.ShowValue);
//Assert.AreEqual(false, record.IsVertical);
Assert.AreEqual(true, record.IsAutoGeneratedText);
Assert.AreEqual(true, record.IsGenerated);
Assert.AreEqual(false, record.IsAutoLabelDeleted);
Assert.AreEqual(true, record.IsAutoBackground);
//Assert.AreEqual(TextRecord.ROTATION_NONE, record.Rotation);
Assert.AreEqual(false, record.ShowCategoryLabelAsPercentage);
Assert.AreEqual(false, record.ShowValueAsPercentage);
Assert.AreEqual(false, record.ShowBubbleSizes);
Assert.AreEqual(false, record.ShowLabel);
Assert.AreEqual(77, record.IndexOfColorValue);
Assert.AreEqual(11088, record.Options2);
Assert.AreEqual(0, record.DataLabelPlacement);
Assert.AreEqual(0, record.TextRotation);
Assert.AreEqual(36, record.RecordSize);
}
public void TestLoad()
{
AxcExtRecord record = new AxcExtRecord(TestcaseRecordInputStream.Create((short)0x1062, data));
Assert.AreEqual(0, record.MinimumDate);
Assert.AreEqual(0, record.MaximumDate);
Assert.AreEqual(1, record.MajorInterval);
Assert.AreEqual(0, (short)record.MajorUnit);
Assert.AreEqual(1, record.MinorInterval);
Assert.AreEqual(0, (short)record.MinorUnit);
Assert.AreEqual(0, (short)record.BaseUnit);
Assert.AreEqual(0, record.CrossDate);
Assert.AreEqual(239, record.Options);
Assert.AreEqual(true, record.IsAutoMin);
Assert.AreEqual(true, record.IsAutoMax);
Assert.AreEqual(true, record.IsAutoMajor);
Assert.AreEqual(true, record.IsAutoMinor);
Assert.AreEqual(false, record.IsDateAxis);
Assert.AreEqual(true, record.IsAutoBase);
Assert.AreEqual(true, record.IsAutoCross);
Assert.AreEqual(true, record.IsAutoDate);
Assert.AreEqual(22, record.RecordSize);
}
public void TestReadWriteTokenValueBytes()
{
ArrayPtg ptg = new ArrayPtg(TestcaseRecordInputStream.CreateWithFakeSid(ENCODED_PTG_DATA));
ptg.ReadTokenValues(TestcaseRecordInputStream.CreateWithFakeSid(ENCODED_CONSTANT_DATA));
Assert.AreEqual(3, ptg.ColumnCount);
Assert.AreEqual(2, ptg.RowCount);
object[] values = ptg.GetTokenArrayValues();
Assert.AreEqual(6, values.Length);
Assert.AreEqual(true, values[0]);
Assert.AreEqual("ABCD", values[1]);
Assert.AreEqual(0, Convert.ToInt32(values[3]));
Assert.AreEqual(false, values[4]);
Assert.AreEqual("FG", values[5]);
byte[] outBuf = new byte[ENCODED_CONSTANT_DATA.Length];
ptg.WriteTokenValueBytes(new LittleEndianByteArrayOutputStream(outBuf, 0));
if (outBuf[0] == 4)
{
throw new AssertFailedException("Identified bug 42564b");
}
Assert.IsTrue(NPOI.Util.Arrays.Equals(ENCODED_CONSTANT_DATA, outBuf));
}
public void TestOlderFormat_bug46918()
{
// There are 10 SXVDEX records in the file (not uploaded) that originated bugzilla 46918
// They all had the following hex encoding:
byte[] data = HexRead.ReadFromString("00 01 0A 00 1E 14 00 0A FF FF FF FF 00 00");
RecordInputStream in1 = TestcaseRecordInputStream.Create(data);
ExtendedPivotTableViewFieldsRecord rec;
try
{
rec = new ExtendedPivotTableViewFieldsRecord(in1);
}
catch (RecordFormatException e)
{
if (e.Message.Equals("Not enough data (0) to read requested (2) bytes"))
{
throw new AssertionException("Identified bug 46918");
}
throw e;
}
byte[] expReserData = HexRead.ReadFromString("1E 14 00 0A FF FF FF FF 00 00" +
"FF FF 00 00 00 00 00 00 00 00");
TestcaseRecordInputStream.ConfirmRecordEncoding(ExtendedPivotTableViewFieldsRecord.sid, expReserData, rec.Serialize());
}
public void TestLoad()
{
AxisUsedRecord record = new AxisUsedRecord(TestcaseRecordInputStream.Create((short)0x1046, data));
Assert.AreEqual(1, record.NumAxis);
Assert.AreEqual(6, record.RecordSize);
}
public void TestLoad()
{
AxisOptionsRecord record = new AxisOptionsRecord(TestcaseRecordInputStream.Create((short)0x1062, data));
Assert.AreEqual(0, record.MinimumCategory);
Assert.AreEqual(0, record.MaximumCategory);
Assert.AreEqual(1, record.MajorUnitValue);
Assert.AreEqual(0, record.MajorUnit);
Assert.AreEqual(1, record.MinorUnitValue);
Assert.AreEqual(0, record.MinorUnit);
Assert.AreEqual(0, record.BaseUnit);
Assert.AreEqual(0, record.CrossingPoint);
Assert.AreEqual(239, record.Options);
Assert.AreEqual(true, record.IsDefaultMinimum);
Assert.AreEqual(true, record.IsDefaultMaximum);
Assert.AreEqual(true, record.IsDefaultMajor);
Assert.AreEqual(true, record.IsDefaultMinorUnit);
Assert.AreEqual(false, record.IsDate);
Assert.AreEqual(true, record.IsDefaultBase);
Assert.AreEqual(true, record.IsDefaultCross);
Assert.AreEqual(true, record.IsDefaultDateSettings);
Assert.AreEqual(22, record.RecordSize);
}
public void TestLoad()
{
AxisLineRecord record = new AxisLineRecord(TestcaseRecordInputStream.Create((short)0x1021, data));
Assert.AreEqual(AxisLineRecord.AXIS_TYPE_MAJOR_GRID_LINE, record.AxisType);
Assert.AreEqual(6, record.RecordSize);
}
public void TestLoad()
{
UnitsRecord record = new UnitsRecord(TestcaseRecordInputStream.Create((short)0x1001, data));
Assert.AreEqual(0, record.Units);
Assert.AreEqual(6, record.RecordSize);
}
public void TestLoad()
{
SeriesChartGroupIndexRecord record = new SeriesChartGroupIndexRecord(TestcaseRecordInputStream.Create(0x1045, data));
Assert.AreEqual(0, record.ChartGroupIndex);
Assert.AreEqual(6, record.RecordSize);
}
public void TestLoad()
{
NumberFormatIndexRecord record = new NumberFormatIndexRecord(TestcaseRecordInputStream.Create((short)0x104e, data));
Assert.AreEqual(5, record.FormatIndex);
Assert.AreEqual(6, record.RecordSize);
}
public void TestLoad()
{
FontXRecord record = new FontXRecord(TestcaseRecordInputStream.Create((short)0x1026, data));
Assert.AreEqual(5, record.FontIndex);
Assert.AreEqual(6, record.RecordSize);
}
public void TestLoad()
{
SeriesListRecord record = new SeriesListRecord(TestcaseRecordInputStream.Create(0x1016, data));
Assert.AreEqual((short)0x2001, record.SeriesNumbers[0]);
Assert.AreEqual(unchecked ((short)0xf0ff), record.SeriesNumbers[1]);
Assert.AreEqual(2, record.SeriesNumbers.Length);
Assert.AreEqual(4 + 6, record.RecordSize);
}
public void TestLoad()
{
SeriesIndexRecord record = new SeriesIndexRecord(TestcaseRecordInputStream.Create(0x1065, data));
Assert.AreEqual((short)3, record.Index);
Assert.AreEqual(6, record.RecordSize);
}
public void TestLoad()
{
PlotGrowthRecord record = new PlotGrowthRecord(TestcaseRecordInputStream.Create(0x1064, data));
Assert.AreEqual(65536, record.HorizontalScale);
Assert.AreEqual(65536, record.VerticalScale);
Assert.AreEqual(12, record.RecordSize);
}
public void TestLoad()
{
ChartRecord record = new ChartRecord(TestcaseRecordInputStream.Create((short)0x1002, data));
Assert.AreEqual(0, record.X);
Assert.AreEqual(0, record.Y);
Assert.AreEqual(30474216, record.Width);
Assert.AreEqual(15060168, record.Height);
Assert.AreEqual(20, record.RecordSize);
}
private static PageItemRecord ConfirmSerialize(String hexDump)
{
byte[] data = HexRead.ReadFromString(hexDump);
RecordInputStream in1 = TestcaseRecordInputStream.Create(PageItemRecord.sid, data);
PageItemRecord rec = new PageItemRecord(in1);
Assert.AreEqual(0, in1.Remaining);
Assert.AreEqual(4 + data.Length, rec.RecordSize);
byte[] data2 = rec.Serialize();
TestcaseRecordInputStream.ConfirmRecordEncoding(PageItemRecord.sid, data, data2);
return(rec);
}
public void TestLoad()
{
AreaRecord record = new AreaRecord(TestcaseRecordInputStream.Create((short)0x101A, data));
Assert.AreEqual(2, record.FormatFlags);
Assert.AreEqual(false, record.IsStacked);
Assert.AreEqual(true, record.IsDisplayAsPercentage);
Assert.AreEqual(false, record.IsShadow);
Assert.AreEqual(6, record.RecordSize);
}
public void TestRead()
{
// This function index represents the LEN() function
byte[] fakeData = { 0x20, 0x00, };
FuncPtg ptg = FuncPtg.Create(TestcaseRecordInputStream.CreateLittleEndian(fakeData));
Assert.AreEqual(0x20, ptg.FunctionIndex, "Len formula index is not 32(20H)");
Assert.AreEqual(1, ptg.NumberOfOperands, "Number of operands in the len formula");
Assert.AreEqual("LEN", ptg.Name, "Function Name");
Assert.AreEqual(3, ptg.Size, "Ptg Size");
}
public void TestLoad()
{
FrameRecord record = new FrameRecord(TestcaseRecordInputStream.Create((short)0x1032, data));
Assert.AreEqual(FrameRecord.BORDER_TYPE_REGULAR, record.BorderType);
Assert.AreEqual(2, record.Options);
Assert.AreEqual(false, record.IsAutoSize);
Assert.AreEqual(true, record.IsAutoPosition);
Assert.AreEqual(8, record.RecordSize);
}
public void TestLoadInvalid()
{
try
{
Assert.IsNotNull(new CellRangeAddress(
TestcaseRecordInputStream.Create(0x000, new byte[] { (byte)0x02 })));
}
catch (RuntimeException e)
{
Assert.IsTrue(e.Message.Contains("Ran out of data"), "Had: " + e);
}
}
public void TestLoad()
{
SeriesTextRecord record = new SeriesTextRecord(TestcaseRecordInputStream.Create(0x100d, SIMPLE_DATA));
Assert.AreEqual((short)0, record.Id);
Assert.AreEqual((byte)0x0C, record.Text.Length);
Assert.AreEqual("Value Number", record.Text);
Assert.AreEqual(SIMPLE_DATA.Length + 4, record.RecordSize);
}
public void TestStore()
{
SeriesTextRecord record = new SeriesTextRecord();
record.Id = 0;
record.Text = ("Value Number");
byte[] recordBytes = record.Serialize();
TestcaseRecordInputStream.ConfirmRecordEncoding(SeriesTextRecord.sid, SIMPLE_DATA, recordBytes);
}
public void TestLoad()
{
CellRangeAddress cref = new CellRangeAddress(
TestcaseRecordInputStream.Create(0x000, data)
);
Assert.AreEqual(2, cref.FirstRow);
Assert.AreEqual(4, cref.LastRow);
Assert.AreEqual(0, cref.FirstColumn);
Assert.AreEqual(3, cref.LastColumn);
Assert.AreEqual(8, CellRangeAddress.ENCODED_SIZE);
}
public void TestReadWrite_tRefN_bug45091()
{
RecordInputStream in1 = TestcaseRecordInputStream.CreateWithFakeSid(tRefN_data);
Ptg[] ptgs = Ptg.ReadTokens(tRefN_data.Length, in1);
byte[] outData = new byte[5];
Ptg.SerializePtgs(ptgs, outData, 0);
if (outData[0] == 0x24)
{
throw new AssertFailedException("Identified bug 45091");
}
Assert.IsTrue(NPOI.Util.Arrays.Equals(tRefN_data, outData));
}
public void TestLoad()
{
FbiRecord record = new FbiRecord(TestcaseRecordInputStream.Create((short)0x1060, data));
Assert.AreEqual(0x1a28, record.XBasis);
Assert.AreEqual(0x0f9c, record.YBasis);
Assert.AreEqual(0xc8, record.HeightBasis);
Assert.AreEqual(0x00, record.Scale);
Assert.AreEqual(0x05, record.IndexToFontTable);
Assert.AreEqual(14, record.RecordSize);
}
public void TestReadWrite_tRefN_bug45091()
{
ILittleEndianInput in1 = TestcaseRecordInputStream.CreateLittleEndian(tRefN_data);
Ptg[] ptgs = Ptg.ReadTokens(tRefN_data.Length, in1);
byte[] outData = new byte[5];
Ptg.SerializePtgs(ptgs, outData, 0);
if (outData[0] == 0x24)
{
throw new AssertionException("Identified bug 45091");
}
Assert.IsTrue(Arrays.Equals(tRefN_data, outData));
}
public void TestLoad()
{
AxisParentRecord record = new AxisParentRecord(TestcaseRecordInputStream.Create((short)0x1041, data));
Assert.AreEqual(AxisParentRecord.AXIS_TYPE_MAIN, record.AxisType);
Assert.AreEqual(0x021d, record.X);
Assert.AreEqual(0xdd, record.Y);
Assert.AreEqual(0x0b31, record.Width);
Assert.AreEqual(0x0b56, record.Height);
Assert.AreEqual(22, record.RecordSize);
}
