public void TestCloneSheetWithEmptyDrawingAggregate()
{
HSSFWorkbook b = new HSSFWorkbook();
HSSFSheet s = b.CreateSheet("Test") as HSSFSheet;
HSSFPatriarch patriarch = s.CreateDrawingPatriarch() as HSSFPatriarch;
EscherAggregate agg1 = patriarch.GetBoundAggregate();
HSSFSheet s2 = s.CloneSheet(b) as HSSFSheet;
patriarch = s2.DrawingPatriarch as HSSFPatriarch;
EscherAggregate agg2 = patriarch.GetBoundAggregate();
EscherSpRecord sp1 = (EscherSpRecord)agg1.GetEscherContainer().GetChild(1).GetChild(0).GetChild(1);
EscherSpRecord sp2 = (EscherSpRecord)agg2.GetEscherContainer().GetChild(1).GetChild(0).GetChild(1);
Assert.AreEqual(sp1.ShapeId, 1024);
Assert.AreEqual(sp2.ShapeId, 2048);
EscherDgRecord dg = (EscherDgRecord)agg2.GetEscherContainer().GetChild(0);
Assert.AreEqual(dg.LastMSOSPID, 2048);
Assert.AreEqual(dg.Instance, 0x2);
//everything except id and DgRecord.lastMSOSPID and DgRecord.Instance must be the same
sp2.ShapeId = (1024);
dg.LastMSOSPID = (1024);
dg.Instance =((short)0x1);
Assert.AreEqual(agg1.Serialize().Length, agg2.Serialize().Length);
Assert.AreEqual(agg1.ToXml(""), agg2.ToXml(""));
Assert.IsTrue(Arrays.Equals(agg1.Serialize(), agg2.Serialize()));
}
public void TestSerialize()
{
EscherContainerRecord container1 = new EscherContainerRecord();
EscherContainerRecord spContainer1 = new EscherContainerRecord();
EscherContainerRecord spContainer2 = new EscherContainerRecord();
EscherContainerRecord spContainer3 = new EscherContainerRecord();
EscherSpRecord sp1 = new EscherSpRecord();
EscherSpRecord sp2 = new EscherSpRecord();
EscherSpRecord sp3 = new EscherSpRecord();
EscherClientDataRecord d2 = new EscherClientDataRecord();
EscherClientDataRecord d3 = new EscherClientDataRecord();
container1.Options = ((short)0x000F);
spContainer1.Options = ((short)0x000F);
spContainer1.RecordId = (EscherContainerRecord.SP_CONTAINER);
spContainer2.Options = ((short)0x000F);
spContainer2.RecordId = (EscherContainerRecord.SP_CONTAINER);
spContainer3.Options = ((short)0x000F);
spContainer3.RecordId = (EscherContainerRecord.SP_CONTAINER);
d2.RecordId = (EscherClientDataRecord.RECORD_ID);
d2.RemainingData = (new byte[0]);
d3.RecordId = (EscherClientDataRecord.RECORD_ID);
d3.RemainingData = (new byte[0]);
container1.AddChildRecord(spContainer1);
container1.AddChildRecord(spContainer2);
container1.AddChildRecord(spContainer3);
spContainer1.AddChildRecord(sp1);
spContainer2.AddChildRecord(sp2);
spContainer3.AddChildRecord(sp3);
spContainer2.AddChildRecord(d2);
spContainer3.AddChildRecord(d3);
EscherAggregate aggregate = new EscherAggregate(null);
aggregate.AddEscherRecord(container1);
aggregate.AssoicateShapeToObjRecord(d2, new ObjRecord());
aggregate.AssoicateShapeToObjRecord(d3, new ObjRecord());
byte[] data = new byte[112];
int bytesWritten = aggregate.Serialize(0, data);
Assert.AreEqual(112, bytesWritten);
Assert.AreEqual("[EC, 00, 40, 00, 0F, 00, 00, 00, 58, 00, 00, 00, 0F, 00, 04, F0, 10, 00, 00, 00, 00, 00, 0A, F0, 08, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 0F, 00, 04, F0, 18, 00, 00, 00, 00, 00, 0A, F0, 08, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 11, F0, 00, 00, 00, 00, 5D, 00, 00, 00, EC, 00, 20, 00, 0F, 00, 04, F0, 18, 00, 00, 00, 00, 00, 0A, F0, 08, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 11, F0, 00, 00, 00, 00, 5D, 00, 00, 00, ]",
HexDump.ToHex(data));
}
public void TestDgContainerMustBeRootOfHSSFSheetEscherRecords()
{
HSSFWorkbook wb = HSSFTestDataSamples.OpenSampleWorkbook("47251.xls");
HSSFSheet sh = wb.GetSheetAt(0) as HSSFSheet;
InternalSheet ish = HSSFTestHelper.GetSheetForTest(sh);
List <RecordBase> records = ish.Records;
// records to be aggregated
List <RecordBase> dgRecords = records.GetRange(19, 23 - 19);
byte[] dgBytes = toByteArray(dgRecords);
IDrawing d = sh.DrawingPatriarch;
EscherAggregate agg = (EscherAggregate)ish.FindFirstRecordBySid(EscherAggregate.sid);
Assert.AreEqual(true, agg.EscherRecords[0] is EscherContainerRecord);
Assert.AreEqual(EscherContainerRecord.DG_CONTAINER, agg.EscherRecords[0].RecordId);
Assert.AreEqual((short)0x0, agg.EscherRecords[0].Options);
agg = (EscherAggregate)ish.FindFirstRecordBySid(EscherAggregate.sid);
byte[] dgBytesAfterSave = agg.Serialize();
Assert.AreEqual(dgBytes.Length, dgBytesAfterSave.Length, "different size of drawing data before and after save");
Assert.IsTrue(Arrays.Equals(dgBytes, dgBytesAfterSave), "drawing data before and after save is different");
}