/**
* 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>
/// 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;
}
/// <summary>
/// Creates a simple shape. This includes such shapes as lines, rectangles,
/// and ovals.
/// </summary>
/// <param name="anchor">the client anchor describes how this Group is attached
/// to the sheet.</param>
/// <returns>the newly created shape.</returns>
public HSSFSimpleShape CreateSimpleShape(HSSFClientAnchor anchor)
{
HSSFSimpleShape shape = new HSSFSimpleShape(null, anchor);
shape.Anchor = anchor;
AddShape(shape);
return shape;
}
/// <summary>
/// Create a new simple shape Under this Group.
/// </summary>
/// <param name="anchor">the position of the shape.</param>
/// <returns>the shape</returns>
public HSSFSimpleShape CreateShape(HSSFChildAnchor anchor)
{
HSSFSimpleShape shape = new HSSFSimpleShape(this, anchor);
shape.Anchor = anchor;
shapes.Add(shape);
return shape;
}
/// <summary>
/// Create a new simple shape Under this Group.
/// </summary>
/// <param name="anchor">the position of the shape.</param>
/// <returns>the shape</returns>
public HSSFSimpleShape CreateShape(HSSFChildAnchor anchor)
{
HSSFSimpleShape shape = new HSSFSimpleShape(this, anchor);
shape.Anchor = anchor;
shapes.Add(shape);
return(shape);
}
/// <summary>
/// Creates a simple shape. This includes such shapes as lines, rectangles,
/// and ovals.
/// </summary>
/// <param name="anchor">the client anchor describes how this Group is attached
/// to the sheet.</param>
/// <returns>the newly created shape.</returns>
public HSSFSimpleShape CreateSimpleShape(HSSFClientAnchor anchor)
{
HSSFSimpleShape shape = new HSSFSimpleShape(null, anchor);
shape.Anchor = anchor;
AddShape(shape);
return(shape);
}
public void DrawLine(int x1, int y1, int x2, int y2, int width)
{
HSSFSimpleShape shape = escherGroup.CreateShape(new HSSFChildAnchor(x1, y1, x2, y2));
shape.ShapeType = (HSSFSimpleShape.OBJECT_TYPE_LINE);
shape.LineWidth = (width);
shape.SetLineStyleColor(foreground.R, foreground.G, foreground.B);
}
/**
* YK: used to create autofilters
*
* @see org.apache.poi.hssf.usermodel.HSSFSheet#setAutoFilter(int, int, int, int)
*/
public HSSFSimpleShape CreateComboBox(HSSFAnchor anchor)
{
HSSFSimpleShape shape = new HSSFSimpleShape(null, anchor);
shape.ShapeType = HSSFSimpleShape.OBJECT_TYPE_COMBO_BOX;
shape.Anchor = anchor;
AddShape(shape);
return(shape);
}
public void FillRect(int x, int y, int width, int height)
{
HSSFSimpleShape shape = escherGroup.CreateShape(new HSSFChildAnchor(x, y, x + width, y + height));
shape.ShapeType = (HSSFSimpleShape.OBJECT_TYPE_RECTANGLE);
shape.LineStyle = LineStyle.None;
shape.SetFillColor(foreground.R, foreground.G, foreground.B);
shape.SetLineStyleColor(foreground.R, foreground.G, foreground.B);
}
public void DrawOval(int x, int y, int width, int height)
{
HSSFSimpleShape shape = escherGroup.CreateShape(new HSSFChildAnchor(x, y, x + width, y + height));
shape.ShapeType = (HSSFSimpleShape.OBJECT_TYPE_OVAL);
shape.LineWidth = 0;
shape.SetLineStyleColor(foreground.R, foreground.G, foreground.B);
shape.IsNoFill = (true);
}
/// <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;
}
/// <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();
EscherRecord anchor = new EscherClientAnchorRecord();
EscherClientDataRecord clientData = new EscherClientDataRecord();
spContainer.RecordId=EscherContainerRecord.SP_CONTAINER;
spContainer.Options=(short)0x000F;
sp.RecordId=EscherSpRecord.RECORD_ID;
sp.Options=(short)((EscherAggregate.ST_LINE << 4) | 0x2);
sp.ShapeId=shapeId;
sp.Flags=EscherSpRecord.FLAG_HAVEANCHOR | EscherSpRecord.FLAG_HASSHAPETYPE;
opt.RecordId=EscherOptRecord.RECORD_ID;
opt.AddEscherProperty(new EscherShapePathProperty(EscherProperties.GEOMETRY__SHAPEPATH, EscherShapePathProperty.COMPLEX));
opt.AddEscherProperty(new EscherBoolProperty(EscherProperties.LINESTYLE__NOLINEDRAWDASH, 1048592));
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;
}
/**
* Creates the low level OBJ record for this shape.
*/
private ObjRecord CreateObjRecord(HSSFSimpleShape shape, int shapeId)
{
ObjRecord obj = new ObjRecord();
CommonObjectDataSubRecord c = new CommonObjectDataSubRecord();
c.ObjectType = CommonObjectType.COMBO_BOX;
c.ObjectId = shapeId;
c.IsLocked = true;
c.IsPrintable = false;
c.IsAutoFill = true;
c.IsAutoline = false;
FtCblsSubRecord f = new FtCblsSubRecord();
LbsDataSubRecord l = LbsDataSubRecord.CreateAutoFilterInstance();
EndSubRecord e = new EndSubRecord();
obj.AddSubRecord(c);
obj.AddSubRecord(f);
obj.AddSubRecord(l);
obj.AddSubRecord(e);
return obj;
}
/**
* Creates the low evel records for a combobox.
*
* @param hssfShape The highlevel shape.
* @param shapeId The shape id to use for this shape.
*/
public ComboboxShape(HSSFSimpleShape hssfShape, int shapeId)
{
spContainer = CreateSpContainer(hssfShape, shapeId);
objRecord = CreateObjRecord(hssfShape, shapeId);
}
/**
* YK: used to create autofilters
*
* @see org.apache.poi.hssf.usermodel.HSSFSheet#setAutoFilter(int, int, int, int)
*/
public HSSFSimpleShape CreateComboBox(HSSFAnchor anchor)
{
HSSFSimpleShape shape = new HSSFSimpleShape(null, anchor);
shape.ShapeType = HSSFSimpleShape.OBJECT_TYPE_COMBO_BOX;
shape.Anchor = anchor;
AddShape(shape);
return shape;
}