/**
* @return color of the line. If color is not Set returns <code>java.awt.Color.black</code>
*/
public Color GetLineColor()
{
EscherOptRecord opt = (EscherOptRecord)GetEscherChild(_escherContainer, EscherOptRecord.RECORD_ID);
EscherSimpleProperty p1 = (EscherSimpleProperty)GetEscherProperty(opt, EscherProperties.LINESTYLE__COLOR);
EscherSimpleProperty p2 = (EscherSimpleProperty)GetEscherProperty(opt, EscherProperties.LINESTYLE__NOLINEDRAWDASH);
int p2val = p2 == null ? 0 : p2.PropertyValue;
Color clr = null;
if ((p2val & 0x8) != 0 || (p2val & 0x10) != 0)
{
int rgb = p1 == null ? 0 : p1.PropertyValue;
if (rgb >= 0x8000000)
{
int idx = rgb % 0x8000000;
if (Sheet != null)
{
ColorSchemeAtom ca = Sheet.GetColorScheme();
if (idx >= 0 && idx <= 7)
{
rgb = ca.GetColor(idx);
}
}
}
Color tmp = new Color(rgb, true);
clr = new Color(tmp.GetBlue(), tmp.GetGreen(), tmp.GetRed());
}
return(clr);
}
/// <summary>
/// Sets standard escher options for a comment.
/// This method is responsible for Setting default background,
/// shading and other comment properties.
/// </summary>
/// <param name="shape">The highlevel shape.</param>
/// <param name="opt">The escher records holding the proerties</param>
/// <returns>The number of escher options added</returns>
protected override int AddStandardOptions(HSSFShape shape, EscherOptRecord opt)
{
base.AddStandardOptions(shape, opt);
//Remove Unnecessary properties inherited from TextboxShape
IList props = (IList)opt.EscherProperties.Clone();
for (IEnumerator iterator = props.GetEnumerator(); iterator.MoveNext();)
{
EscherProperty prop = (EscherProperty)iterator.Current;
switch (prop.Id)
{
case EscherProperties.TEXT__TEXTLEFT:
case EscherProperties.TEXT__TEXTRIGHT:
case EscherProperties.TEXT__TEXTTOP:
case EscherProperties.TEXT__TEXTBOTTOM:
case EscherProperties.GROUPSHAPE__PRINT:
case EscherProperties.Fill__FillBACKCOLOR:
case EscherProperties.LINESTYLE__COLOR:
opt.EscherProperties.Remove(prop);
break;
}
}
HSSFComment comment = (HSSFComment)shape;
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.GROUPSHAPE__PRINT, comment.Visible ? 0x000A0000 : 0x000A0002));
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.SHADOWSTYLE__SHADOWOBSURED, 0x00030003));
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.SHADOWSTYLE__COLOR, 0x00000000));
opt.SortProperties();
return(opt.EscherProperties.Count); // # options Added
}
/// <summary>
/// Creates the lowerlevel escher records for this shape.
/// </summary>
/// <param name="hssfShape">The HSSF shape.</param>
/// <param name="shapeId">The shape id.</param>
/// <returns></returns>
private EscherContainerRecord CreateSpContainer(HSSFSimpleShape hssfShape, int shapeId)
{
HSSFShape shape = hssfShape;
EscherContainerRecord spContainer = new EscherContainerRecord();
EscherSpRecord sp = new EscherSpRecord();
EscherOptRecord opt = new EscherOptRecord();
EscherClientDataRecord clientData = new EscherClientDataRecord();
spContainer.RecordId = EscherContainerRecord.SP_CONTAINER;
spContainer.Options = (short)0x000F;
sp.RecordId = EscherSpRecord.RECORD_ID;
short shapeType = objTypeToShapeType(hssfShape.ShapeType);
sp.Options = (short)((shapeType << 4) | 0x2);
sp.ShapeId = shapeId;
sp.Flags = EscherSpRecord.FLAG_HAVEANCHOR | EscherSpRecord.FLAG_HASSHAPETYPE;
opt.RecordId = EscherOptRecord.RECORD_ID;
AddStandardOptions(shape, opt);
EscherRecord anchor = CreateAnchor(shape.Anchor);
clientData.RecordId = EscherClientDataRecord.RECORD_ID;
clientData.Options = (short)0x0000;
spContainer.AddChildRecord(sp);
spContainer.AddChildRecord(opt);
spContainer.AddChildRecord(anchor);
spContainer.AddChildRecord(clientData);
return(spContainer);
}
//int lineStyleColor = 0x08000040;
//int fillColor = 0x08000009;
//int lineWidth = LINEWIDTH_DEFAULT;
//LineStyle lineStyle = LineStyle.Solid;
//bool noFill = false;
/**
* creates shapes from existing file
* @param spContainer
* @param objRecord
*/
public HSSFShape(EscherContainerRecord spContainer, ObjRecord objRecord)
{
this._escherContainer = spContainer;
this._objRecord = objRecord;
this._optRecord = (EscherOptRecord)spContainer.GetChildById(EscherOptRecord.RECORD_ID);
this.anchor = HSSFAnchor.CreateAnchorFromEscher(spContainer);
}
/// <summary>
/// Does this HSSFPatriarch contain a chart?
/// (Technically a reference to a chart, since they
/// Get stored in a different block of records)
/// FIXME - detect chart in all cases (only seems
/// to work on some charts so far)
/// </summary>
/// <returns>
/// <c>true</c> if this instance contains chart; otherwise, <c>false</c>.
/// </returns>
public bool ContainsChart()
{
// TODO - support charts properly in usermodel
// We're looking for a EscherOptRecord
EscherOptRecord optRecord = (EscherOptRecord)
_boundAggregate.FindFirstWithId(EscherOptRecord.RECORD_ID);
if (optRecord == null)
{
// No opt record, can't have chart
return(false);
}
for (IEnumerator it = optRecord.EscherProperties.GetEnumerator(); it.MoveNext();)
{
EscherProperty prop = (EscherProperty)it.Current;
if (prop.PropertyNumber == 896 && prop.IsComplex)
{
EscherComplexProperty cp = (EscherComplexProperty)prop;
String str = StringUtil.GetFromUnicodeLE(cp.ComplexData);
//Console.Error.WriteLine(str);
if (str.Equals("Chart 1\0"))
{
return(true);
}
}
}
return(false);
}
public void TestCorrectOrderInOptRecord()
{
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.CreateSheet() as HSSFSheet;
HSSFPatriarch patriarch = sheet.CreateDrawingPatriarch() as HSSFPatriarch;
HSSFTextbox textbox = patriarch.CreateTextbox(new HSSFClientAnchor()) as HSSFTextbox;
EscherOptRecord opt = HSSFTestHelper.GetOptRecord(textbox);
String opt1Str = opt.ToXml();
textbox.FillColor = textbox.FillColor;
EscherContainerRecord Container = HSSFTestHelper.GetEscherContainer(textbox);
EscherOptRecord optRecord = Container.GetChildById(EscherOptRecord.RECORD_ID) as EscherOptRecord;
Assert.AreEqual(opt1Str, optRecord.ToXml());
textbox.LineStyle = textbox.LineStyle;
Assert.AreEqual(opt1Str, optRecord.ToXml());
textbox.LineWidth = textbox.LineWidth;
Assert.AreEqual(opt1Str, optRecord.ToXml());
textbox.LineStyleColor = textbox.LineStyleColor;
Assert.AreEqual(opt1Str, optRecord.ToXml());
wb.Close();
}
public void TestHSSFShapeCompatibility()
{
HSSFSimpleShape shape = new HSSFSimpleShape(null, new HSSFClientAnchor());
shape.ShapeType = (HSSFSimpleShape.OBJECT_TYPE_LINE);
Assert.AreEqual(0x08000040, shape.LineStyleColor);
Assert.AreEqual(0x08000009, shape.FillColor);
Assert.AreEqual(HSSFShape.LINEWIDTH_DEFAULT, shape.LineWidth);
Assert.AreEqual(HSSFShape.LINESTYLE_SOLID, shape.LineStyle);
Assert.IsFalse(shape.IsNoFill);
AbstractShape sp = AbstractShape.CreateShape(shape, 1);
EscherContainerRecord spContainer = sp.SpContainer;
EscherOptRecord opt = spContainer.GetChildById(EscherOptRecord.RECORD_ID) as EscherOptRecord;
Assert.AreEqual(7, opt.EscherProperties.Count);
Assert.AreEqual(true,
((EscherBoolProperty)opt.Lookup(EscherProperties.TEXT__SIZE_TEXT_TO_FIT_SHAPE)).IsTrue);
Assert.AreEqual(0x00000004,
((EscherSimpleProperty)opt.Lookup(EscherProperties.GEOMETRY__SHAPEPATH)).PropertyValue);
Assert.AreEqual(0x08000009,
((EscherSimpleProperty)opt.Lookup(EscherProperties.FILL__FILLCOLOR)).PropertyValue);
Assert.AreEqual(true,
((EscherBoolProperty)opt.Lookup(EscherProperties.FILL__NOFILLHITTEST)).IsTrue);
Assert.AreEqual(0x08000040,
((EscherSimpleProperty)opt.Lookup(EscherProperties.LINESTYLE__COLOR)).PropertyValue);
Assert.AreEqual(true,
((EscherBoolProperty)opt.Lookup(EscherProperties.LINESTYLE__NOLINEDRAWDASH)).IsTrue);
Assert.AreEqual(true,
((EscherBoolProperty)opt.Lookup(EscherProperties.GROUPSHAPE__PRINT)).IsTrue);
}
/**
* Create a new Table of the given number of rows and columns
*
* @param numrows the number of rows
* @param numcols the number of columns
*/
public Table(int numrows, int numcols) {
base();
if(numrows < 1) throw new ArgumentException("The number of rows must be greater than 1");
if(numcols < 1) throw new ArgumentException("The number of columns must be greater than 1");
int x=0, y=0, tblWidth=0, tblHeight=0;
cells = new TableCell[numrows][numcols];
for (int i = 0; i < cells.Length; i++) {
x = 0;
for (int j = 0; j < cells[i].Length; j++) {
cells[i][j] = new TableCell(this);
Rectangle anchor = new Rectangle(x, y, TableCell.DEFAULT_WIDTH, TableCell.DEFAULT_HEIGHT);
cells[i][j].SetAnchor(anchor);
x += TableCell.DEFAULT_WIDTH;
}
y += TableCell.DEFAULT_HEIGHT;
}
tblWidth = x;
tblHeight = y;
SetAnchor(new Rectangle(0, 0, tblWidth, tblHeight));
EscherContainerRecord spCont = (EscherContainerRecord) GetSpContainer().GetChild(0);
EscherOptRecord opt = new EscherOptRecord();
opt.SetRecordId((short)0xF122);
opt.AddEscherProperty(new EscherSimpleProperty((short)0x39F, 1));
EscherArrayProperty p = new EscherArrayProperty((short)0x43A0, false, null);
p.SetSizeOfElements(0x0004);
p.SetNumberOfElementsInArray(numrows);
p.SetNumberOfElementsInMemory(numrows);
opt.AddEscherProperty(p);
List<EscherRecord> lst = spCont.GetChildRecords();
lst.Add(lst.Count-1, opt);
spCont.SetChildRecords(lst);
}
/**
* Generates the escher shape records for this shape.
*/
private EscherContainerRecord CreateSpContainer(HSSFSimpleShape shape, int shapeId)
{
EscherContainerRecord spContainer = new EscherContainerRecord();
EscherSpRecord sp = new EscherSpRecord();
EscherOptRecord opt = new EscherOptRecord();
EscherClientDataRecord clientData = new EscherClientDataRecord();
spContainer.RecordId = (EscherContainerRecord.SP_CONTAINER);
spContainer.Options = ((short)0x000F);
sp.RecordId = (EscherSpRecord.RECORD_ID);
sp.Options = ((short)((EscherAggregate.ST_HOSTCONTROL << 4) | 0x2));
sp.ShapeId = (shapeId);
sp.Flags = (EscherSpRecord.FLAG_HAVEANCHOR | EscherSpRecord.FLAG_HASSHAPETYPE);
opt.RecordId = (EscherOptRecord.RECORD_ID);
opt.AddEscherProperty(new EscherBoolProperty(EscherProperties.PROTECTION__LOCKAGAINSTGROUPING, 17039620));
opt.AddEscherProperty(new EscherBoolProperty(EscherProperties.TEXT__SIZE_TEXT_TO_FIT_SHAPE, 0x00080008));
opt.AddEscherProperty(new EscherBoolProperty(EscherProperties.LINESTYLE__NOLINEDRAWDASH, 0x00080000));
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.GROUPSHAPE__PRINT, 0x00020000));
HSSFClientAnchor userAnchor = (HSSFClientAnchor)shape.Anchor;
userAnchor.AnchorType = 1;
EscherRecord anchor = CreateAnchor(userAnchor);
clientData.RecordId = (EscherClientDataRecord.RECORD_ID);
clientData.Options = ((short)0x0000);
spContainer.AddChildRecord(sp);
spContainer.AddChildRecord(opt);
spContainer.AddChildRecord(anchor);
spContainer.AddChildRecord(clientData);
return(spContainer);
}
/// <summary>
/// Sets standard escher options for a comment.
/// This method is responsible for Setting default background,
/// shading and other comment properties.
/// </summary>
/// <param name="shape">The highlevel shape.</param>
/// <param name="opt">The escher records holding the proerties</param>
/// <returns>The number of escher options added</returns>
protected override int AddStandardOptions(HSSFShape shape, EscherOptRecord opt)
{
base.AddStandardOptions(shape, opt);
//Remove Unnecessary properties inherited from TextboxShape
for (int i = 0; i < opt.EscherProperties.Count; i++)
{
EscherProperty prop = opt.EscherProperties[i];
switch (prop.Id)
{
case EscherProperties.TEXT__TEXTLEFT:
case EscherProperties.TEXT__TEXTRIGHT:
case EscherProperties.TEXT__TEXTTOP:
case EscherProperties.TEXT__TEXTBOTTOM:
case EscherProperties.GROUPSHAPE__PRINT:
case EscherProperties.Fill__FillBACKCOLOR:
case EscherProperties.LINESTYLE__COLOR:
opt.EscherProperties.Remove(prop);
i--;
break;
}
}
HSSFComment comment = (HSSFComment)shape;
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.GROUPSHAPE__PRINT, comment.Visible ? 0x000A0000 : 0x000A0002));
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.SHADOWSTYLE__SHADOWOBSURED, 0x00030003));
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.SHADOWSTYLE__COLOR, 0x00000000));
opt.SortProperties();
return(opt.EscherProperties.Count); // # options Added
}
/**
* Get the value of a simple escher property for this shape.
*
* @param propId The id of the property. One of the constants defined in EscherOptRecord.
*/
public int GetEscherProperty(short propId, int defaultValue)
{
EscherOptRecord opt = (EscherOptRecord)GetEscherChild(_escherContainer, EscherOptRecord.RECORD_ID);
EscherSimpleProperty prop = (EscherSimpleProperty)GetEscherProperty(opt, propId);
return(prop == null ? defaultValue : prop.PropertyValue);
}
private void CheckSerializeSimple()
{
EscherOptRecord r = new EscherOptRecord();
r.Options = (short)0x0033;
r.RecordId = unchecked ((short)0xF00B);
EscherBoolProperty prop1 = new EscherBoolProperty(EscherProperties.TEXT__SIZE_TEXT_TO_FIT_SHAPE, 1);
EscherRGBProperty prop2 = new EscherRGBProperty(EscherProperties.FILL__FILLCOLOR, 0x08000009);
EscherRGBProperty prop3 = new EscherRGBProperty(EscherProperties.LINESTYLE__COLOR, 0x08000040);
r.AddEscherProperty(prop1);
r.AddEscherProperty(prop2);
r.AddEscherProperty(prop3);
byte[] data = new byte[26];
int bytesWritten = r.Serialize(0, data);
string dataStr = "[33, 00, " +
"0B, F0, " +
"12, 00, 00, 00, " +
"BF, 00, 01, 00, 00, 00, " +
"81, 01, 09, 00, 00, 08, " +
"C0, 01, 40, 00, 00, 08]";
Assert.AreEqual(dataStr, HexDump.ToHex(data));
Assert.AreEqual(26, bytesWritten);
}
private void CheckSerializeComplex()
{
//Complex escher record
EscherOptRecord r = new EscherOptRecord();
r.Options = (short)0x0033;
r.RecordId = unchecked ((short)0xF00B);
EscherBoolProperty prop1 = new EscherBoolProperty(EscherProperties.TEXT__SIZE_TEXT_TO_FIT_SHAPE, 1);
EscherComplexProperty prop2 = new EscherComplexProperty((short)1, false, new byte[] { 0x01, 0x02 });
EscherBoolProperty prop3 = new EscherBoolProperty(EscherProperties.TEXT__SIZE_TEXT_TO_FIT_SHAPE, 1);
r.AddEscherProperty(prop1);
r.AddEscherProperty(prop2);
r.AddEscherProperty(prop3);
byte[] data = new byte[28];
int bytesWritten = r.Serialize(0, data);
Assert.AreEqual(28, bytesWritten);
string dataStr = "[33, 00, " +
"0B, F0, " +
"14, 00, 00, 00, " +
"BF, 00, 01, 00, 00, 00, " +
"01, 80, 02, 00, 00, 00, " +
"BF, 00, 01, 00, 00, 00, " +
"01, 02]";
Assert.AreEqual(dataStr, HexDump.ToHex(data));
}
/**
* Returns line style. One of the constants defined in this class.
*
* @return style of the line.
*/
public int GetLineStyle()
{
EscherOptRecord opt = (EscherOptRecord)GetEscherChild(_escherContainer, EscherOptRecord.RECORD_ID);
EscherSimpleProperty prop = (EscherSimpleProperty)GetEscherProperty(opt, EscherProperties.LINESTYLE__LINESTYLE);
return(prop == null ? Line.LINE_SIMPLE : prop.PropertyValue);
}
/**
* Returns width of the line in in points
*/
public double GetLineWidth()
{
EscherOptRecord opt = (EscherOptRecord)GetEscherChild(_escherContainer, EscherOptRecord.RECORD_ID);
EscherSimpleProperty prop = (EscherSimpleProperty)GetEscherProperty(opt, EscherProperties.LINESTYLE__LINEWIDTH);
double width = prop == null ? DEFAULT_LINE_WIDTH : (double)prop.PropertyValue / EMU_PER_POINT;
return(width);
}
/// <summary>
/// Create a new shape with the specified parent and anchor.
/// </summary>
/// <param name="parent">The parent.</param>
/// <param name="anchor">The anchor.</param>
public HSSFShape(HSSFShape parent, HSSFAnchor anchor)
{
this.parent = parent;
this.anchor = anchor;
this._escherContainer = CreateSpContainer();
_optRecord = (EscherOptRecord)_escherContainer.GetChildById(EscherOptRecord.RECORD_ID);
_objRecord = CreateObjRecord();
}
/**
* Gets line dashing. One of the PEN_* constants defined in this class.
*
* @return dashing of the line.
*/
public int GetLineDashing()
{
EscherOptRecord opt = (EscherOptRecord)GetEscherChild(_escherContainer, EscherOptRecord.RECORD_ID);
EscherSimpleProperty prop = (EscherSimpleProperty)GetEscherProperty(opt, EscherProperties.LINESTYLE__LINEDASHING);
return(prop == null ? Line.PEN_SOLID : prop.PropertyValue);
}
protected override EscherContainerRecord CreateSpContainer()
{
EscherContainerRecord spContainer = base.CreateSpContainer();
EscherOptRecord opt = (EscherOptRecord)spContainer.GetChildById(EscherOptRecord.RECORD_ID);
opt.RemoveEscherProperty(EscherProperties.LINESTYLE__LINEDASHING);
opt.RemoveEscherProperty(EscherProperties.LINESTYLE__NOLINEDRAWDASH);
spContainer.RemoveChildRecord(spContainer.GetChildById(EscherTextboxRecord.RECORD_ID));
return(spContainer);
}
protected override EscherContainerRecord CreateSpContainer()
{
EscherContainerRecord spContainer = base.CreateSpContainer();
EscherOptRecord opt = (EscherOptRecord)spContainer.GetChildById(EscherOptRecord.RECORD_ID);
opt.RemoveEscherProperty(EscherProperties.TEXT__TEXTLEFT);
opt.RemoveEscherProperty(EscherProperties.TEXT__TEXTRIGHT);
opt.RemoveEscherProperty(EscherProperties.TEXT__TEXTTOP);
opt.RemoveEscherProperty(EscherProperties.TEXT__TEXTBOTTOM);
opt.SetEscherProperty(new EscherSimpleProperty(EscherProperties.GROUPSHAPE__PRINT, false, false, GROUP_SHAPE_PROPERTY_DEFAULT_VALUE));
return(spContainer);
}
/// <summary>
/// Creates the lowerlevel escher records for this shape.
/// </summary>
/// <param name="hssfShape">The HSSF shape.</param>
/// <param name="shapeId">The shape id.</param>
/// <returns></returns>
private EscherContainerRecord CreateSpContainer(HSSFTextbox hssfShape, int shapeId)
{
HSSFTextbox shape = hssfShape;
EscherContainerRecord spContainer = new EscherContainerRecord();
EscherSpRecord sp = new EscherSpRecord();
EscherOptRecord opt = new EscherOptRecord();
EscherRecord anchor = new EscherClientAnchorRecord();
EscherClientDataRecord clientData = new EscherClientDataRecord();
escherTextbox = new EscherTextboxRecord();
spContainer.RecordId = EscherContainerRecord.SP_CONTAINER;
spContainer.Options = (short)0x000F;
sp.RecordId = EscherSpRecord.RECORD_ID;
sp.Options = (short)((EscherAggregate.ST_TEXTBOX << 4) | 0x2);
sp.ShapeId = shapeId;
sp.Flags = EscherSpRecord.FLAG_HAVEANCHOR | EscherSpRecord.FLAG_HASSHAPETYPE;
opt.RecordId = EscherOptRecord.RECORD_ID;
// opt.AddEscherProperty( new EscherBoolProperty( EscherProperties.PROTECTION__LOCKAGAINSTGROUPING, 262144 ) );
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.TEXT__TEXTID, 0));
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.TEXT__TEXTLEFT, shape.MarginLeft));
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.TEXT__TEXTRIGHT, shape.MarginRight));
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.TEXT__TEXTBOTTOM, shape.MarginBottom));
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.TEXT__TEXTTOP, shape.MarginTop));
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.TEXT__WRAPTEXT, 0));
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.TEXT__ANCHORTEXT, 0));
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.GROUPSHAPE__PRINT, 0x00080000));
AddStandardOptions(shape, opt);
HSSFAnchor userAnchor = shape.Anchor;
// if (userAnchor.IsHorizontallyFlipped())
// sp.Flags(sp.Flags | EscherSpRecord.FLAG_FLIPHORIZ);
// if (userAnchor.IsVerticallyFlipped())
// sp.Flags(sp.Flags | EscherSpRecord.FLAG_FLIPVERT);
anchor = CreateAnchor(userAnchor);
clientData.RecordId = EscherClientDataRecord.RECORD_ID;
clientData.Options = (short)0x0000;
escherTextbox.RecordId = EscherTextboxRecord.RECORD_ID;
escherTextbox.Options = (short)0x0000;
spContainer.AddChildRecord(sp);
spContainer.AddChildRecord(opt);
spContainer.AddChildRecord(anchor);
spContainer.AddChildRecord(clientData);
spContainer.AddChildRecord(escherTextbox);
return(spContainer);
}
/**
* Generates the shape records for this shape.
*/
protected override EscherContainerRecord CreateSpContainer()
{
EscherContainerRecord spContainer = new EscherContainerRecord();
EscherSpRecord sp = new EscherSpRecord();
EscherOptRecord opt = new EscherOptRecord();
EscherClientDataRecord clientData = new EscherClientDataRecord();
spContainer.RecordId = (EscherContainerRecord.SP_CONTAINER);
spContainer.Options = ((short)0x000F);
sp.RecordId = (EscherSpRecord.RECORD_ID);
sp.Options = ((short)((EscherAggregate.ST_NOT_PRIMATIVE << 4) | 0x2));
if (Parent == null)
{
sp.Flags = (EscherSpRecord.FLAG_HAVEANCHOR | EscherSpRecord.FLAG_HASSHAPETYPE);
}
else
{
sp.Flags = (EscherSpRecord.FLAG_CHILD | EscherSpRecord.FLAG_HAVEANCHOR | EscherSpRecord.FLAG_HASSHAPETYPE);
}
opt.RecordId = (EscherOptRecord.RECORD_ID);
opt.SetEscherProperty(new EscherSimpleProperty(EscherProperties.TRANSFORM__ROTATION, false, false, 0));
opt.SetEscherProperty(new EscherSimpleProperty(EscherProperties.GEOMETRY__RIGHT, false, false, 100));
opt.SetEscherProperty(new EscherSimpleProperty(EscherProperties.GEOMETRY__BOTTOM, false, false, 100));
opt.SetEscherProperty(new EscherShapePathProperty(EscherProperties.GEOMETRY__SHAPEPATH, EscherShapePathProperty.COMPLEX));
opt.SetEscherProperty(new EscherSimpleProperty(EscherProperties.GEOMETRY__FILLOK, false, false, 0x00010001));
opt.SetEscherProperty(new EscherSimpleProperty(EscherProperties.LINESTYLE__LINESTARTARROWHEAD, false, false, 0x0));
opt.SetEscherProperty(new EscherSimpleProperty(EscherProperties.LINESTYLE__LINEENDARROWHEAD, false, false, 0x0));
opt.SetEscherProperty(new EscherSimpleProperty(EscherProperties.LINESTYLE__LINEENDCAPSTYLE, false, false, 0x0));
opt.SetEscherProperty(new EscherSimpleProperty(EscherProperties.LINESTYLE__LINEDASHING, LINESTYLE_SOLID));
opt.SetEscherProperty(new EscherBoolProperty(EscherProperties.LINESTYLE__NOLINEDRAWDASH, 0x00080008));
opt.SetEscherProperty(new EscherSimpleProperty(EscherProperties.LINESTYLE__LINEWIDTH, LINEWIDTH_DEFAULT));
opt.SetEscherProperty(new EscherRGBProperty(EscherProperties.FILL__FILLCOLOR, FILL__FILLCOLOR_DEFAULT));
opt.SetEscherProperty(new EscherRGBProperty(EscherProperties.LINESTYLE__COLOR, LINESTYLE__COLOR_DEFAULT));
opt.SetEscherProperty(new EscherBoolProperty(EscherProperties.FILL__NOFILLHITTEST, 1));
opt.SetEscherProperty(new EscherBoolProperty(EscherProperties.GROUPSHAPE__PRINT, 0x080000));
EscherRecord anchor = Anchor.GetEscherAnchor();
clientData.RecordId = (EscherClientDataRecord.RECORD_ID);
clientData.Options = ((short)0x0000);
spContainer.AddChildRecord(sp);
spContainer.AddChildRecord(opt);
spContainer.AddChildRecord(anchor);
spContainer.AddChildRecord(clientData);
return(spContainer);
}
public void Test41946()
{
string dataStr1 =
"03 08 0B F0 00 03 00 00 81 00 30 65 01 00 82 00 98 B2 00 00 83 00 30 65 01 " +
"00 84 00 98 B2 00 00 85 00 00 00 00 00 87 00 01 00 00 00 88 00 00 00 00 00 " +
"89 00 00 00 00 00 BF 00 00 00 0F 00 0C 01 F4 00 00 10 0D 01 00 00 00 20 0E " +
"01 00 00 00 20 80 01 00 00 00 00 81 01 04 00 00 08 82 01 00 00 01 00 83 01 " +
"00 00 00 08 84 01 00 00 01 00 85 01 00 00 00 20 86 41 00 00 00 00 87 C1 00 " +
"00 00 00 88 01 00 00 00 00 89 01 00 00 00 00 8A 01 00 00 00 00 8B 01 00 00 " +
"00 00 8C 01 00 00 00 00 8D 01 00 00 00 00 8E 01 00 00 00 00 8F 01 00 00 00 " +
"00 90 01 00 00 00 00 91 01 00 00 00 00 92 01 00 00 00 00 93 01 00 00 00 00 " +
"94 01 00 00 00 00 95 01 00 00 00 00 96 01 00 00 00 00 97 C1 00 00 00 00 98 " +
"01 00 00 00 00 99 01 00 00 00 00 9A 01 00 00 00 00 9B 01 00 00 00 00 9C 01 " +
"03 00 00 40 BF 01 0C 00 1E 00 C0 01 01 00 00 08 C1 01 00 00 01 00 C2 01 FF " +
"FF FF 00 C3 01 00 00 00 20 C4 01 00 00 00 00 C5 41 00 00 00 00 C6 C1 00 00 " +
"00 00 C7 01 00 00 00 00 C8 01 00 00 00 00 C9 01 00 00 00 00 CA 01 00 00 00 " +
"00 CB 01 35 25 00 00 CC 01 00 00 08 00 CD 01 00 00 00 00 CE 01 00 00 00 00 " +
"CF C1 00 00 00 00 D7 01 02 00 00 00 FF 01 06 00 0E 00 00 02 00 00 00 00 01 " +
"02 02 00 00 08 02 02 CB CB CB 00 03 02 00 00 00 20 04 02 00 00 01 00 05 02 " +
"38 63 00 00 06 02 38 63 00 00 07 02 00 00 00 00 08 02 00 00 00 00 09 02 00 " +
"00 01 00 0A 02 00 00 00 00 0B 02 00 00 00 00 0C 02 00 00 01 00 0D 02 00 00 " +
"00 00 0E 02 00 00 00 00 0F 02 00 01 00 00 10 02 00 00 00 00 11 02 00 00 00 " +
"00 3F 02 00 00 03 00 80 02 00 00 00 00 81 02 00 00 01 00 82 02 05 00 00 00 " +
"83 02 9C 31 00 00 84 02 00 00 00 00 85 02 F0 F9 06 00 86 02 00 00 00 00 87 " +
"02 F7 00 00 10 88 02 00 00 00 20 BF 02 01 00 0F 00 C0 02 00 00 00 00 C1 02 " +
"00 00 00 00 C2 02 64 00 00 00 C3 02 00 00 00 00 C4 02 00 00 00 00 C5 02 00 " +
"00 00 00 C6 02 00 00 00 00 C7 02 00 00 00 00 C8 02 00 00 00 00 C9 02 00 00 " +
"00 00 CA 02 30 75 00 00 CB 02 D0 12 13 00 CC 02 30 ED EC FF CD 02 40 54 89 " +
"00 CE 02 00 80 00 00 CF 02 00 80 FF FF D0 02 00 00 79 FF D1 02 32 00 00 00 " +
"D2 02 20 4E 00 00 D3 02 50 C3 00 00 D4 02 00 00 00 00 D5 02 10 27 00 00 D6 " +
"02 70 94 00 00 D7 02 B0 3C FF FF D8 02 00 00 00 00 D9 02 10 27 00 00 DA 02 " +
"70 94 00 00 FF 02 16 00 1F 00 04 03 01 00 00 00 41 03 A8 29 01 00 42 03 00 " +
"00 00 00 43 03 03 00 00 00 44 03 7C BE 01 00 45 03 00 00 00 00 7F 03 00 00 " +
"0F 00 84 03 7C BE 01 00 85 03 00 00 00 00 86 03 7C BE 01 00 87 03 00 00 00 " +
"00";
EscherOptRecord r = new EscherOptRecord();
byte[] data = HexRead.ReadFromString(dataStr1);
r.FillFields(data, 0, new DefaultEscherRecordFactory());
Assert.AreEqual(unchecked ((short)0xF00B), r.RecordId);
byte[] data1 = r.Serialize();
EscherOptRecord opt2 = new EscherOptRecord();
opt2.FillFields(data1, new DefaultEscherRecordFactory());
byte[] data2 = opt2.Serialize();
Assert.IsTrue(Arrays.Equals(data1, data2));
}
public void TestOpt()
{
HSSFWorkbook wb = new HSSFWorkbook();
// create a sheet with a text box
HSSFSheet sheet = wb.CreateSheet() as HSSFSheet;
HSSFPatriarch patriarch = sheet.CreateDrawingPatriarch() as HSSFPatriarch;
HSSFTextbox textbox = patriarch.CreateTextbox(new HSSFClientAnchor()) as HSSFTextbox;
EscherOptRecord opt1 = HSSFTestHelper.GetOptRecord(textbox);
EscherOptRecord opt2 = HSSFTestHelper.GetEscherContainer(textbox).GetChildById(EscherOptRecord.RECORD_ID) as EscherOptRecord;
Assert.AreSame(opt1, opt2);
}
/**
* Returns escher property by id.
*
* @return escher property or <code>null</code> if not found.
*/
public static EscherProperty GetEscherProperty(EscherOptRecord opt, int propId)
{
if (opt != null)
{
for (List <EscherProperty> .Enumerator iterator = opt.EscherProperties.GetEnumerator(); iterator.MoveNext();)
{
EscherProperty prop = (EscherProperty)iterator.Current;
if (prop.PropertyNumber == propId)
{
return(prop);
}
}
}
return(null);
}
/**
* Sets the color of line
*
* @param color new color of the line
*/
public void SetLineColor(Color color)
{
EscherOptRecord opt = (EscherOptRecord)GetEscherChild(_escherContainer, EscherOptRecord.RECORD_ID);
if (color == null)
{
SetEscherProperty(opt, EscherProperties.LINESTYLE__NOLINEDRAWDASH, 0x80000);
}
else
{
int rgb = new Color(color.Blue, color.Green, color.Red, 0).GetRGB();
SetEscherProperty(opt, EscherProperties.LINESTYLE__COLOR, rgb);
SetEscherProperty(opt, EscherProperties.LINESTYLE__NOLINEDRAWDASH, color == null ? 0x180010 : 0x180018);
}
}
protected override EscherContainerRecord CreateSpContainer()
{
EscherContainerRecord spContainer = new EscherContainerRecord();
EscherSpRecord sp = new EscherSpRecord();
EscherOptRecord opt = new EscherOptRecord();
EscherClientDataRecord clientData = new EscherClientDataRecord();
EscherTextboxRecord escherTextbox = new EscherTextboxRecord();
spContainer.RecordId = (EscherContainerRecord.SP_CONTAINER);
spContainer.Options = ((short)0x000F);
sp.RecordId = (EscherSpRecord.RECORD_ID);
sp.Options = ((short)((EscherAggregate.ST_TEXTBOX << 4) | 0x2));
sp.Flags = (EscherSpRecord.FLAG_HAVEANCHOR | EscherSpRecord.FLAG_HASSHAPETYPE);
opt.RecordId = (EscherOptRecord.RECORD_ID);
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.TEXT__TEXTID, 0));
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.TEXT__WRAPTEXT, 0));
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.TEXT__ANCHORTEXT, 0));
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.GROUPSHAPE__PRINT, 0x00080000));
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.TEXT__TEXTLEFT, 0));
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.TEXT__TEXTRIGHT, 0));
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.TEXT__TEXTTOP, 0));
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.TEXT__TEXTBOTTOM, 0));
opt.SetEscherProperty(new EscherSimpleProperty(EscherProperties.LINESTYLE__LINEDASHING, LINESTYLE_SOLID));
opt.SetEscherProperty(new EscherBoolProperty(EscherProperties.LINESTYLE__NOLINEDRAWDASH, 0x00080008));
opt.SetEscherProperty(new EscherSimpleProperty(EscherProperties.LINESTYLE__LINEWIDTH, LINEWIDTH_DEFAULT));
opt.SetEscherProperty(new EscherRGBProperty(EscherProperties.FILL__FILLCOLOR, FILL__FILLCOLOR_DEFAULT));
opt.SetEscherProperty(new EscherRGBProperty(EscherProperties.LINESTYLE__COLOR, LINESTYLE__COLOR_DEFAULT));
opt.SetEscherProperty(new EscherBoolProperty(EscherProperties.FILL__NOFILLHITTEST, NO_FILLHITTEST_FALSE));
opt.SetEscherProperty(new EscherBoolProperty(EscherProperties.GROUPSHAPE__PRINT, 0x080000));
EscherRecord anchor = Anchor.GetEscherAnchor();
clientData.RecordId = (EscherClientDataRecord.RECORD_ID);
clientData.Options = ((short)0x0000);
escherTextbox.RecordId = (EscherTextboxRecord.RECORD_ID);
escherTextbox.Options = ((short)0x0000);
spContainer.AddChildRecord(sp);
spContainer.AddChildRecord(opt);
spContainer.AddChildRecord(anchor);
spContainer.AddChildRecord(clientData);
spContainer.AddChildRecord(escherTextbox);
return(spContainer);
}
protected override EscherContainerRecord CreateSpContainer()
{
EscherContainerRecord spgrContainer = new EscherContainerRecord();
EscherContainerRecord spContainer = new EscherContainerRecord();
EscherSpgrRecord spgr = new EscherSpgrRecord();
EscherSpRecord sp = new EscherSpRecord();
EscherOptRecord opt = new EscherOptRecord();
EscherRecord anchor;
EscherClientDataRecord clientData = new EscherClientDataRecord();
spgrContainer.RecordId = (EscherContainerRecord.SPGR_CONTAINER);
spgrContainer.Options = ((short)0x000F);
spContainer.RecordId = (EscherContainerRecord.SP_CONTAINER);
spContainer.Options = (short)0x000F;
spgr.RecordId = (EscherSpgrRecord.RECORD_ID);
spgr.Options = (short)0x0001;
spgr.RectX1 = (0);
spgr.RectY1 = (0);
spgr.RectX2 = (1023);
spgr.RectY2 = (255);
sp.RecordId = (EscherSpRecord.RECORD_ID);
sp.Options = (short)0x0002;
if (this.Anchor is HSSFClientAnchor)
{
sp.Flags = (EscherSpRecord.FLAG_GROUP | EscherSpRecord.FLAG_HAVEANCHOR);
}
else
{
sp.Flags = (EscherSpRecord.FLAG_GROUP | EscherSpRecord.FLAG_HAVEANCHOR | EscherSpRecord.FLAG_CHILD);
}
opt.RecordId = (EscherOptRecord.RECORD_ID);
opt.Options = ((short)0x0023);
opt.AddEscherProperty(new EscherBoolProperty(EscherProperties.PROTECTION__LOCKAGAINSTGROUPING, 0x00040004));
opt.AddEscherProperty(new EscherBoolProperty(EscherProperties.GROUPSHAPE__PRINT, 0x00080000));
anchor = Anchor.GetEscherAnchor();
clientData.RecordId = (EscherClientDataRecord.RECORD_ID);
clientData.Options = ((short)0x0000);
spgrContainer.AddChildRecord(spContainer);
spContainer.AddChildRecord(spgr);
spContainer.AddChildRecord(sp);
spContainer.AddChildRecord(opt);
spContainer.AddChildRecord(anchor);
spContainer.AddChildRecord(clientData);
return(spgrContainer);
}
public void TestEmptyArrayProperty()
{
EscherOptRecord r = new EscherOptRecord();
EscherArrayProperty p = new EscherArrayProperty(unchecked ((short)(EscherProperties.FILL__SHADECOLORS + 0x8000)), new byte[0]);
Assert.AreEqual(0, p.NumberOfElementsInArray);
r.AddEscherProperty(p);
byte[] data1 = r.Serialize();
EscherOptRecord opt2 = new EscherOptRecord();
opt2.FillFields(data1, new DefaultEscherRecordFactory());
p = (EscherArrayProperty)opt2.EscherProperties[0];
Assert.AreEqual(0, p.NumberOfElementsInArray);
byte[] data2 = opt2.Serialize();
Assert.IsTrue(Arrays.Equals(data1, data2));
}
/**
* Set an escher property for this shape.
*
* @param opt The opt record to Set the properties to.
* @param propId The id of the property. One of the constants defined in EscherOptRecord.
* @param value value of the property. If value = -1 then the property is Removed.
*/
public static void SetEscherProperty(EscherOptRecord opt, short propId, int value)
{
List <EscherProperty> props = opt.EscherProperties;
for (List <EscherProperty> .Enumerator iterator = props.GetEnumerator(); iterator.MoveNext();)
{
EscherProperty prop = (EscherProperty)iterator.Current;
if (prop.Id == propId)
{
props.Remove(iterator.Current);
}
}
if (value != -1)
{
opt.AddEscherProperty(new EscherSimpleProperty(propId, value));
opt.SortProperties();
}
}
/// <summary>
/// Creates the lowerlevel escher records for this shape.
/// </summary>
/// <param name="hssfShape">The HSSF shape.</param>
/// <param name="shapeId">The shape id.</param>
/// <returns></returns>
private EscherContainerRecord CreateSpContainer(HSSFSimpleShape hssfShape, int shapeId)
{
HSSFPicture shape = (HSSFPicture)hssfShape;
EscherContainerRecord spContainer = new EscherContainerRecord();
EscherSpRecord sp = new EscherSpRecord();
EscherOptRecord opt = new EscherOptRecord();
EscherRecord anchor;
EscherClientDataRecord clientData = new EscherClientDataRecord();
spContainer.RecordId = EscherContainerRecord.SP_CONTAINER;
spContainer.Options = (short)0x000F;
sp.RecordId = EscherSpRecord.RECORD_ID;
sp.Options = (short)((EscherAggregate.ST_PICTUREFRAME << 4) | 0x2);
sp.ShapeId = shapeId;
sp.Flags = EscherSpRecord.FLAG_HAVEANCHOR | EscherSpRecord.FLAG_HASSHAPETYPE;
opt.RecordId = EscherOptRecord.RECORD_ID;
// opt.AddEscherProperty( new EscherBoolProperty( EscherProperties.PROTECTION__LOCKAGAINSTGROUPING, 0x00800080 ) ;
opt.AddEscherProperty(new EscherSimpleProperty(EscherProperties.BLIP__BLIPTODISPLAY, false, true, shape.PictureIndex));
// opt.AddEscherProperty( new EscherComplexProperty( EscherProperties.BLIP__BLIPFILENAME, true, new byte[] { (byte)0x74, (byte)0x00, (byte)0x65, (byte)0x00, (byte)0x73, (byte)0x00, (byte)0x74, (byte)0x00, (byte)0x00, (byte)0x00 } ) ;
// opt.AddEscherProperty( new EscherSimpleProperty( EscherProperties.Fill__FillTYPE, 0x00000003 ) ;
AddStandardOptions(shape, opt);
HSSFAnchor userAnchor = shape.Anchor;
if (userAnchor.IsHorizontallyFlipped)
{
sp.Flags = sp.Flags | EscherSpRecord.FLAG_FLIPHORIZ;
}
if (userAnchor.IsVerticallyFlipped)
{
sp.Flags = sp.Flags | EscherSpRecord.FLAG_FLIPVERT;
}
anchor = CreateAnchor(userAnchor);
clientData.RecordId = EscherClientDataRecord.RECORD_ID;
clientData.Options = (short)0x0000;
spContainer.AddChildRecord(sp);
spContainer.AddChildRecord(opt);
spContainer.AddChildRecord(anchor);
spContainer.AddChildRecord(clientData);
return(spContainer);
}
protected override EscherContainerRecord CreateSpContainer()
{
EscherContainerRecord spContainer = new EscherContainerRecord();
spContainer.RecordId = EscherContainerRecord.SP_CONTAINER;
spContainer.Options = ((short)0x000F);
EscherSpRecord sp = new EscherSpRecord();
sp.RecordId = (EscherSpRecord.RECORD_ID);
sp.Flags = (EscherSpRecord.FLAG_HAVEANCHOR | EscherSpRecord.FLAG_HASSHAPETYPE);
sp.Version = ((short)0x2);
EscherClientDataRecord clientData = new EscherClientDataRecord();
clientData.RecordId = (EscherClientDataRecord.RECORD_ID);
clientData.Options = ((short)(0x0000));
EscherOptRecord optRecord = new EscherOptRecord();
optRecord.SetEscherProperty(new EscherSimpleProperty(EscherProperties.LINESTYLE__LINEDASHING, LINESTYLE_SOLID));
optRecord.SetEscherProperty(new EscherBoolProperty(EscherProperties.LINESTYLE__NOLINEDRAWDASH, 0x00080008));
// optRecord.SetEscherProperty(new EscherSimpleProperty(EscherProperties.LINESTYLE__LINEWIDTH, LINEWIDTH_DEFAULT));
optRecord.SetEscherProperty(new EscherRGBProperty(EscherProperties.FILL__FILLCOLOR, FILL__FILLCOLOR_DEFAULT));
optRecord.SetEscherProperty(new EscherRGBProperty(EscherProperties.LINESTYLE__COLOR, LINESTYLE__COLOR_DEFAULT));
optRecord.SetEscherProperty(new EscherBoolProperty(EscherProperties.FILL__NOFILLHITTEST, NO_FILLHITTEST_FALSE));
optRecord.SetEscherProperty(new EscherBoolProperty(EscherProperties.LINESTYLE__NOLINEDRAWDASH, 0x00080008));
optRecord.SetEscherProperty(new EscherShapePathProperty(EscherProperties.GEOMETRY__SHAPEPATH, EscherShapePathProperty.COMPLEX));
optRecord.SetEscherProperty(new EscherBoolProperty(EscherProperties.GROUPSHAPE__PRINT, 0x080000));
optRecord.RecordId = EscherOptRecord.RECORD_ID;
EscherTextboxRecord escherTextbox = new EscherTextboxRecord();
escherTextbox.RecordId = (EscherTextboxRecord.RECORD_ID);
escherTextbox.Options = (short)0x0000;
spContainer.AddChildRecord(sp);
spContainer.AddChildRecord(optRecord);
spContainer.AddChildRecord(this.Anchor.GetEscherAnchor());
spContainer.AddChildRecord(clientData);
spContainer.AddChildRecord(escherTextbox);
return(spContainer);
}
