/// <summary>
/// Constructs a picture object.
/// </summary>
/// <param name="parent">The parent.</param>
/// <param name="anchor">The anchor.</param>
public HSSFPicture(HSSFShape parent, HSSFAnchor anchor)
: base(parent, anchor)
{
base.ShapeType = (OBJECT_TYPE_PICTURE);
CommonObjectDataSubRecord cod = (CommonObjectDataSubRecord)GetObjRecord().SubRecords[0];
cod.ObjectType = CommonObjectType.PICTURE;
}
/// <summary>
/// Construct a new textbox with the given parent and anchor.
/// </summary>
/// <param name="parent">The parent.</param>
/// <param name="anchor">One of HSSFClientAnchor or HSSFChildAnchor</param>
public HSSFTextbox(HSSFShape parent, HSSFAnchor anchor)
: base(parent, anchor)
{
HorizontalAlignment = HorizontalTextAlignment.Left;
VerticalAlignment = VerticalTextAlignment.Top;
this.String = (new HSSFRichTextString(""));
}
/**
* 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>
/// Creates the anchor.
/// </summary>
/// <param name="userAnchor">The user anchor.</param>
/// <returns></returns>
public static EscherRecord CreateAnchor(HSSFAnchor userAnchor)
{
if (userAnchor is HSSFClientAnchor)
{
HSSFClientAnchor a = (HSSFClientAnchor)userAnchor;
EscherClientAnchorRecord anchor = new EscherClientAnchorRecord();
anchor.RecordId=EscherClientAnchorRecord.RECORD_ID;
anchor.Options=(short)0x0000;
anchor.Flag=(short)a.AnchorType;
anchor.Col1=(short)Math.Min(a.Col1, a.Col2);
anchor.Dx1=(short)a.Dx1;
anchor.Row1=(short)Math.Min(a.Row1, a.Row2);
anchor.Dy1=(short)a.Dy1;
anchor.Col2=(short)Math.Max(a.Col1, a.Col2);
anchor.Dx2=(short)a.Dx2;
anchor.Row2=(short)Math.Max(a.Row1, a.Row2);
anchor.Dy2=(short)a.Dy2;
return anchor;
}
else
{
HSSFChildAnchor a = (HSSFChildAnchor)userAnchor;
EscherChildAnchorRecord anchor = new EscherChildAnchorRecord();
anchor.RecordId=EscherChildAnchorRecord.RECORD_ID;
anchor.Options=(short)0x0000;
anchor.Dx1=(short)Math.Min(a.Dx1, a.Dx2);
anchor.Dy1=(short)Math.Min(a.Dy1, a.Dy2);
anchor.Dx2=(short)Math.Max(a.Dx2, a.Dx1);
anchor.Dy2=(short)Math.Max(a.Dy2, a.Dy1);
return anchor;
}
}
/// <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();
}
public HSSFCombobox(HSSFShape parent, HSSFAnchor anchor)
: base(parent, anchor)
{
base.ShapeType = (OBJECT_TYPE_COMBO_BOX);
CommonObjectDataSubRecord cod = (CommonObjectDataSubRecord)GetObjRecord().SubRecords[0];
cod.ObjectType = CommonObjectType.COMBO_BOX;
}
/**
* Constructs a cell comment.
*
* @param anchor the client anchor describes how this comment is attached
* to the sheet.
* @return the newly created comment.
*/
public HSSFComment CreateComment(HSSFAnchor anchor)
{
HSSFComment shape = new HSSFComment(null, anchor);
AddShape(shape);
OnCreate(shape);
return(shape);
}
/**
* YK: used to create autofilters
*
* @see org.apache.poi.hssf.usermodel.HSSFSheet#setAutoFilter(int, int, int, int)
*/
public HSSFSimpleShape CreateComboBox(HSSFAnchor anchor)
{
HSSFCombobox shape = new HSSFCombobox(null, anchor);
AddShape(shape);
OnCreate(shape);
return(shape);
}
public HSSFCombobox(HSSFShape parent, HSSFAnchor anchor)
: base(parent, anchor)
{
base.ShapeType = (OBJECT_TYPE_COMBO_BOX);
CommonObjectDataSubRecord cod = (CommonObjectDataSubRecord)GetObjRecord().SubRecords[0];
cod.ObjectType = CommonObjectType.ComboBox;
}
/// <summary>
/// Constructs a picture object.
/// </summary>
/// <param name="parent">The parent.</param>
/// <param name="anchor">The anchor.</param>
public HSSFPicture(HSSFShape parent, HSSFAnchor anchor)
: base(parent, anchor)
{
base.ShapeType = (OBJECT_TYPE_PICTURE);
CommonObjectDataSubRecord cod = (CommonObjectDataSubRecord)GetObjRecord().SubRecords[0];
cod.ObjectType = CommonObjectType.PICTURE;
}
/// <summary>
/// Construct a new textbox with the given parent and anchor.
/// </summary>
/// <param name="parent">The parent.</param>
/// <param name="anchor">One of HSSFClientAnchor or HSSFChildAnchor</param>
public HSSFTextbox(HSSFShape parent, HSSFAnchor anchor)
: base(parent, anchor)
{
HorizontalAlignment = (HORIZONTAL_ALIGNMENT_LEFT);
VerticalAlignment = (VERTICAL_ALIGNMENT_TOP);
this.String = (new HSSFRichTextString(""));
}
/// <summary>
/// Construct a new textbox with the given parent and anchor.
/// </summary>
/// <param name="parent">The parent.</param>
/// <param name="anchor">One of HSSFClientAnchor or HSSFChildAnchor</param>
public HSSFTextbox(HSSFShape parent, HSSFAnchor anchor):base(parent, anchor)
{
ShapeType = (OBJECT_TYPE_TEXT);
halign = HORIZONTAL_ALIGNMENT_LEFT;
valign = VERTICAL_ALIGNMENT_TOP;
}
/**
* 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);
}
/// <summary>
/// Construct a new comment with the given parent and anchor.
/// </summary>
/// <param name="parent"></param>
/// <param name="anchor">defines position of this anchor in the sheet</param>
public HSSFComment(HSSFShape parent, HSSFAnchor anchor) : base(parent, anchor)
{
this.ShapeType = (OBJECT_TYPE_COMMENT);
//default color for comments
this.FillColor = 0x08000050;
//by default comments are hidden
visible = false;
author = "";
}
/// <summary>
/// Construct a new comment with the given parent and anchor.
/// </summary>
/// <param name="parent"></param>
/// <param name="anchor">defines position of this anchor in the sheet</param>
public HSSFComment(HSSFShape parent, HSSFAnchor anchor)
: base(parent, anchor)
{
this.ShapeType = (OBJECT_TYPE_COMMENT);
//default color for comments
this.FillColor = 0x08000050;
//by default comments are hidden
visible = false;
author = "";
}
/// <summary>
/// Construct a new comment with the given parent and anchor.
/// </summary>
/// <param name="parent"></param>
/// <param name="anchor">defines position of this anchor in the sheet</param>
public HSSFComment(HSSFShape parent, HSSFAnchor anchor)
: base(parent, anchor)
{
_note = CreateNoteRecord();
//default color for comments
this.FillColor = 0x08000050;
//by default comments are hidden
Visible = false;
Author = "";
CommonObjectDataSubRecord cod = (CommonObjectDataSubRecord)GetObjRecord().SubRecords[0];
cod.ObjectType = CommonObjectType.COMMENT;
}
/// <summary>
/// Construct a new comment with the given parent and anchor.
/// </summary>
/// <param name="parent"></param>
/// <param name="anchor">defines position of this anchor in the sheet</param>
public HSSFComment(HSSFShape parent, HSSFAnchor anchor)
: base(parent, anchor)
{
_note = CreateNoteRecord();
//default color for comments
this.FillColor = 0x08000050;
//by default comments are hidden
Visible = false;
Author = "";
CommonObjectDataSubRecord cod = (CommonObjectDataSubRecord)GetObjRecord().SubRecords[0];
cod.ObjectType = CommonObjectType.Comment;
}
/**
* 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;
}
/// <summary>
/// Initializes a new instance of the <see cref="HSSFSimpleShape"/> class.
/// </summary>
/// <param name="parent">The parent.</param>
/// <param name="anchor">The anchor.</param>
public HSSFSimpleShape(HSSFShape parent, HSSFAnchor anchor)
: base(parent, anchor)
{
_textObjectRecord = CreateTextObjRecord();
}
public HSSFShapeGroup(HSSFShape parent, HSSFAnchor anchor)
: base(parent, anchor)
{
_spgrRecord = (EscherSpgrRecord)((EscherContainerRecord)GetEscherContainer().GetChild(0)).GetChildById(EscherSpgrRecord.RECORD_ID);
}
/// <summary>
/// Initializes a new instance of the <see cref="HSSFSimpleShape"/> class.
/// </summary>
/// <param name="parent">The parent.</param>
/// <param name="anchor">The anchor.</param>
public HSSFSimpleShape(HSSFShape parent, HSSFAnchor anchor)
:base(parent, anchor)
{
_textObjectRecord = CreateTextObjRecord();
}
/// <summary>
/// Construct a new comment with the given parent and anchor.
/// </summary>
/// <param name="parent"></param>
/// <param name="anchor">defines position of this anchor in the sheet</param>
public HSSFComment(HSSFShape parent, HSSFAnchor anchor) :
this(parent, anchor, CreateNoteRecord())
{
}
public static EscherRecord GetEscherAnchor(HSSFAnchor anchor)
{
return anchor.GetEscherAnchor();
}
/// <summary>
/// Constructs a picture object.
/// </summary>
/// <param name="parent">The parent.</param>
/// <param name="anchor">The anchor.</param>
public HSSFPicture(HSSFShape parent, HSSFAnchor anchor)
: base(parent, anchor)
{
this.ShapeType = (OBJECT_TYPE_PICTURE);
}
/**
* YK: used to create autofilters
*
* @see org.apache.poi.hssf.usermodel.HSSFSheet#setAutoFilter(int, int, int, int)
*/
public HSSFSimpleShape CreateComboBox(HSSFAnchor anchor)
{
HSSFCombobox shape = new HSSFCombobox(null, anchor);
AddShape(shape);
OnCreate(shape);
return shape;
}
/// <summary>
/// Constructs a cell comment.
/// </summary>
/// <param name="anchor">the client anchor describes how this comment is attached
/// to the sheet.</param>
/// <returns>the newly created comment.</returns>
public HSSFComment CreateComment(HSSFAnchor anchor)
{
HSSFComment shape = new HSSFComment(null, anchor);
shape.Anchor = anchor;
shapes.Add(shape);
return shape;
}
public HSSFShapeGroup(HSSFShape parent, HSSFAnchor anchor):base(parent, anchor)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="HSSFSimpleShape"/> class.
/// </summary>
/// <param name="parent">The parent.</param>
/// <param name="anchor">The anchor.</param>
public HSSFSimpleShape(HSSFShape parent, HSSFAnchor anchor):base(parent, anchor)
{
}
/// <summary>
/// Constructs a picture object.
/// </summary>
/// <param name="parent">The parent.</param>
/// <param name="anchor">The anchor.</param>
public HSSFPicture(HSSFShape parent, HSSFAnchor anchor)
: base(parent, anchor)
{
this.ShapeType = (OBJECT_TYPE_PICTURE);
}
/// <summary>
/// Create a new shape with the specified parent and anchor.
/// </summary>
/// <param name="parent">The parent.</param>
/// <param name="anchor">The anchor.</param>
protected HSSFShape(Shape parent, HSSFAnchor anchor)
{
this.parent = parent;
this.Anchor = anchor;
}
public HSSFShapeGroup(HSSFShape parent, HSSFAnchor anchor) : base(parent, anchor)
{
}
/// <summary>
/// Creates an escher anchor record from a HSSFAnchor.
/// </summary>
/// <param name="userAnchor">The high level anchor to Convert.</param>
/// <returns>An escher anchor record.</returns>
protected virtual EscherRecord CreateAnchor(HSSFAnchor userAnchor)
{
return ConvertAnchor.CreateAnchor(userAnchor);
}
public HSSFPolygon(HSSFShape parent, HSSFAnchor anchor)
: base(parent, anchor)
{
}
/**
* Constructs a cell comment.
*
* @param anchor the client anchor describes how this comment is attached
* to the sheet.
* @return the newly created comment.
*/
public HSSFComment CreateComment(HSSFAnchor anchor)
{
HSSFComment shape = new HSSFComment(null, anchor);
AddShape(shape);
OnCreate(shape);
return shape;
}
public HSSFShapeGroup(HSSFShape parent, HSSFAnchor anchor)
: base(parent, anchor)
{
_spgrRecord = (EscherSpgrRecord)((EscherContainerRecord)GetEscherContainer().GetChild(0)).GetChildById(EscherSpgrRecord.RECORD_ID);
}
/// <summary>
/// Initializes a new instance of the <see cref="HSSFSimpleShape"/> class.
/// </summary>
/// <param name="parent">The parent.</param>
/// <param name="anchor">The anchor.</param>
public HSSFSimpleShape(HSSFShape parent, HSSFAnchor anchor) : base(parent, anchor)
{
}
/// <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();
}
/// <summary>
/// Create a new shape with the specified parent and anchor.
/// </summary>
/// <param name="parent">The parent.</param>
/// <param name="anchor">The anchor.</param>
protected HSSFShape(HSSFShape parent, HSSFAnchor anchor)
{
this.parent = parent;
this.anchor = anchor;
}
public HSSFPolygon(HSSFShape parent, HSSFAnchor anchor)
: base(parent, anchor)
{
}