/*******************************************************************************
* You may amend and distribute as you like, but don't remove this header!
*
* EPPlus provides server-side generation of Excel 2007/2010 spreadsheets.
* See http://www.codeplex.com/EPPlus for details.
*
* Copyright (C) 2011 Jan Källman
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
* See the GNU Lesser General Public License for more details.
*
* The GNU Lesser General Public License can be viewed at http://www.opensource.org/licenses/lgpl-license.php
* If you unfamiliar with this license or have questions about it, here is an http://www.gnu.org/licenses/gpl-faq.html
*
* All code and executables are provided "as is" with no warranty either express or implied.
* The author accepts no liability for any damage or loss of business that this product may cause.
*
* Code change notes:
*
* Author Change Date
* ******************************************************************************
* Jan Källman Initial Release 2009-10-01
* Jan Källman License changed GPL-->LGPL 2011-12-16
*******************************************************************************/
using System;
using System.Collections.Generic;
using System.Globalization;
using System.Text;
using System.Xml;
using OfficeOpenXml.Style.XmlAccess;
using OfficeOpenXml.Drawing;
using OfficeOpenXml.Style;
/// <summary>
/// Shape style
/// </summary>
public enum eShapeStyle
{
AccentBorderCallout1,
AccentBorderCallout2,
AccentBorderCallout3,
AccentCallout1,
AccentCallout2,
AccentCallout3,
ActionButtonBackPrevious,
ActionButtonBeginning,
ActionButtonBlank,
ActionButtonDocument,
ActionButtonEnd,
ActionButtonForwardNext,
ActionButtonHelp,
ActionButtonHome,
ActionButtonInformation,
ActionButtonMovie,
ActionButtonReturn,
ActionButtonSound,
Arc,
BentArrow,
BentConnector2,
BentConnector3,
BentConnector4,
BentConnector5,
BentUpArrow,
Bevel,
BlockArc,
BorderCallout1,
BorderCallout2,
BorderCallout3,
BracePair,
BracketPair,
Callout1,
Callout2,
Callout3,
Can,
ChartPlus,
ChartStar,
ChartX,
Chevron,
Chord,
CircularArrow,
Cloud,
CloudCallout,
Corner,
CornerTabs,
Cube,
CurvedConnector2,
CurvedConnector3,
CurvedConnector4,
CurvedConnector5,
CurvedDownArrow,
CurvedLeftArrow,
CurvedRightArrow,
CurvedUpArrow,
Decagon,
DiagStripe,
Diamond,
Dodecagon,
Donut,
DoubleWave,
DownArrow,
DownArrowCallout,
Ellipse,
EllipseRibbon,
EllipseRibbon2,
FlowChartAlternateProcess,
FlowChartCollate,
FlowChartConnector,
FlowChartDecision,
FlowChartDelay,
FlowChartDisplay,
FlowChartDocument,
FlowChartExtract,
FlowChartInputOutput,
FlowChartInternalStorage,
FlowChartMagneticDisk,
FlowChartMagneticDrum,
FlowChartMagneticTape,
FlowChartManualInput,
FlowChartManualOperation,
FlowChartMerge,
FlowChartMultidocument,
FlowChartOfflineStorage,
FlowChartOffpageConnector,
FlowChartOnlineStorage,
FlowChartOr,
FlowChartPredefinedProcess,
FlowChartPreparation,
FlowChartProcess,
FlowChartPunchedCard,
FlowChartPunchedTape,
FlowChartSort,
FlowChartSummingJunction,
FlowChartTerminator,
FoldedCorner,
Frame,
Funnel,
Gear6,
Gear9,
HalfFrame,
Heart,
Heptagon,
Hexagon,
HomePlate,
HorizontalScroll,
IrregularSeal1,
IrregularSeal2,
LeftArrow,
LeftArrowCallout,
LeftBrace,
LeftBracket,
LeftCircularArrow,
LeftRightArrow,
LeftRightArrowCallout,
LeftRightCircularArrow,
LeftRightRibbon,
LeftRightUpArrow,
LeftUpArrow,
LightningBolt,
Line,
LineInv,
MathDivide,
MathEqual,
MathMinus,
MathMultiply,
MathNotEqual,
MathPlus,
Moon,
NonIsoscelesTrapezoid,
NoSmoking,
NotchedRightArrow,
Octagon,
Parallelogram,
Pentagon,
Pie,
PieWedge,
Plaque,
PlaqueTabs,
Plus,
QuadArrow,
QuadArrowCallout,
Rect,
Ribbon,
Ribbon2,
RightArrow,
RightArrowCallout,
RightBrace,
RightBracket,
Round1Rect,
Round2DiagRect,
Round2SameRect,
RoundRect,
RtTriangle,
SmileyFace,
Snip1Rect,
Snip2DiagRect,
Snip2SameRect,
SnipRoundRect,
SquareTabs,
Star10,
Star12,
Star16,
Star24,
Star32,
Star4,
Star5,
Star6,
Star7,
Star8,
StraightConnector1,
StripedRightArrow,
Sun,
SwooshArrow,
Teardrop,
Trapezoid,
Triangle,
UpArrow,
UpArrowCallout,
UpDownArrow,
UpDownArrowCallout,
UturnArrow,
Wave,
WedgeEllipseCallout,
WedgeRectCallout,
WedgeRoundRectCallout,
VerticalScroll
}
/// <summary>
/// Text alignment
/// </summary>
public enum eTextAlignment
{
Left,
Center,
Right,
Distributed,
Justified,
JustifiedLow,
ThaiDistributed
}
/// <summary>
/// Fillstyle.
/// </summary>
public enum eFillStyle
{
NoFill,
SolidFill,
GradientFill,
PatternFill,
BlipFill,
GroupFill
}
namespace OfficeOpenXml.Drawing
{
/// <summary>
/// An Excel shape.
/// </summary>
public sealed class ExcelShape : ExcelDrawing
{
internal ExcelShape(ExcelDrawings drawings, XmlNode node) :
base(drawings, node, "xdr:sp/xdr:nvSpPr/xdr:cNvPr/@name")
{
init();
}
internal ExcelShape(ExcelDrawings drawings, XmlNode node, eShapeStyle style) :
base(drawings, node, "xdr:sp/xdr:nvSpPr/xdr:cNvPr/@name")
{
init();
XmlElement shapeNode = node.OwnerDocument.CreateElement("xdr", "sp", ExcelPackage.schemaSheetDrawings);
shapeNode.SetAttribute("macro", "");
shapeNode.SetAttribute("textlink", "");
node.AppendChild(shapeNode);
shapeNode.InnerXml = ShapeStartXml();
node.AppendChild(shapeNode.OwnerDocument.CreateElement("xdr", "clientData", ExcelPackage.schemaSheetDrawings));
}
private void init()
{
SchemaNodeOrder = new string[] { "prstGeom", "ln", "pPr", "defRPr", "solidFill", "uFill", "latin", "cs", "r", "rPr", "t" };
}
#region "public methods"
const string ShapeStylePath = "xdr:sp/xdr:spPr/a:prstGeom/@prst";
/// <summary>
/// Shape style
/// </summary>
public eShapeStyle Style
{
get
{
string v = GetXmlNodeString(ShapeStylePath);
try
{
return (eShapeStyle)Enum.Parse(typeof(eShapeStyle), v, true);
}
catch
{
throw (new Exception(string.Format("Invalid shapetype {0}", v)));
}
}
set
{
string v = value.ToString();
v = v.Substring(0, 1).ToLower(CultureInfo.InvariantCulture) + v.Substring(1, v.Length - 1);
SetXmlNodeString(ShapeStylePath, v);
}
}
ExcelDrawingFill _fill = null;
/// <summary>
/// Fill
/// </summary>
public ExcelDrawingFill Fill
{
get
{
if (_fill == null)
{
_fill = new ExcelDrawingFill(NameSpaceManager, TopNode, "xdr:sp/xdr:spPr");
}
return _fill;
}
}
ExcelDrawingBorder _border = null;
/// <summary>
/// Border
/// </summary>
public ExcelDrawingBorder Border
{
get
{
if (_border == null)
{
_border = new ExcelDrawingBorder(NameSpaceManager, TopNode, "xdr:sp/xdr:spPr/a:ln");
}
return _border;
}
}
string[] paragraphNodeOrder = new string[] { "pPr", "defRPr", "solidFill", "uFill", "latin", "cs", "r", "rPr", "t" };
const string PARAGRAPH_PATH = "xdr:sp/xdr:txBody/a:p";
ExcelTextFont _font=null;
public ExcelTextFont Font
{
get
{
if (_font == null)
{
XmlNode node = TopNode.SelectSingleNode(PARAGRAPH_PATH, NameSpaceManager);
if(node==null)
{
Text=""; //Creates the node p element
node = TopNode.SelectSingleNode(PARAGRAPH_PATH, NameSpaceManager);
}
_font = new ExcelTextFont(NameSpaceManager, TopNode, "xdr:sp/xdr:txBody/a:p/a:pPr/a:defRPr", paragraphNodeOrder);
}
return _font;
}
}
const string TextPath = "xdr:sp/xdr:txBody/a:p/a:r/a:t";
/// <summary>
/// Text inside the shape
/// </summary>
public string Text
{
get
{
return GetXmlNodeString(TextPath);
}
set
{
SetXmlNodeString(TextPath, value);
}
}
string lockTextPath = "xdr:sp/@fLocksText";
/// <summary>
/// Lock drawing
/// </summary>
public bool LockText
{
get
{
return GetXmlNodeBool(lockTextPath, true);
}
set
{
SetXmlNodeBool(lockTextPath, value);
}
}
ExcelParagraphCollection _richText = null;
/// <summary>
/// Richtext collection. Used to format specific parts of the text
/// </summary>
public ExcelParagraphCollection RichText
{
get
{
if (_richText == null)
{
//XmlNode node=TopNode.SelectSingleNode(PARAGRAPH_PATH, NameSpaceManager);
//if (node == null)
//{
// CreateNode(PARAGRAPH_PATH);
//}
_richText = new ExcelParagraphCollection(NameSpaceManager, TopNode, PARAGRAPH_PATH, paragraphNodeOrder);
}
return _richText;
}
}
const string TextAnchoringPath = "xdr:sp/xdr:txBody/a:bodyPr/@anchor";
/// <summary>
/// Text Anchoring
/// </summary>
public eTextAnchoringType TextAnchoring
{
get
{
return GetTextAchoringEnum(GetXmlNodeString(TextAnchoringPath));
}
set
{
SetXmlNodeString(TextAnchoringPath, GetTextAchoringText(value));
}
}
const string TextAnchoringCtlPath = "xdr:sp/xdr:txBody/a:bodyPr/@anchorCtr";
/// <summary>
/// Specifies the centering of the text box.
/// </summary>
public bool TextAnchoringControl
{
get
{
return GetXmlNodeBool(TextAnchoringCtlPath);
}
set
{
if (value)
{
SetXmlNodeString(TextAnchoringCtlPath, "1");
}
else
{
SetXmlNodeString(TextAnchoringCtlPath, "0");
}
}
}
const string TEXT_ALIGN_PATH = "xdr:sp/xdr:txBody/a:p/a:pPr/@algn";
/// <summary>
/// How the text is aligned
/// </summary>
public eTextAlignment TextAlignment
{
get
{
switch(GetXmlNodeString(TEXT_ALIGN_PATH))
{
case "ctr":
return eTextAlignment.Center;
case "r":
return eTextAlignment.Right;
case "dist":
return eTextAlignment.Distributed;
case "just":
return eTextAlignment.Justified;
case "justLow":
return eTextAlignment.JustifiedLow;
case "thaiDist":
return eTextAlignment.ThaiDistributed;
default:
return eTextAlignment.Left;
}
}
set
{
switch (value)
{
case eTextAlignment.Right:
SetXmlNodeString(TEXT_ALIGN_PATH, "r");
break;
case eTextAlignment.Center:
SetXmlNodeString(TEXT_ALIGN_PATH, "ctr");
break;
case eTextAlignment.Distributed:
SetXmlNodeString(TEXT_ALIGN_PATH, "dist");
break;
case eTextAlignment.Justified:
SetXmlNodeString(TEXT_ALIGN_PATH, "just");
break;
case eTextAlignment.JustifiedLow:
SetXmlNodeString(TEXT_ALIGN_PATH, "justLow");
break;
case eTextAlignment.ThaiDistributed:
SetXmlNodeString(TEXT_ALIGN_PATH, "thaiDist");
break;
default:
DeleteNode(TEXT_ALIGN_PATH);
break;
}
}
}
const string INDENT_ALIGN_PATH = "xdr:sp/xdr:txBody/a:p/a:pPr/@lvl";
/// <summary>
/// Indentation
/// </summary>
public int Indent
{
get
{
return GetXmlNodeInt(INDENT_ALIGN_PATH);
}
set
{
if (value < 0 || value > 8)
{
throw(new ArgumentOutOfRangeException("Indent level must be between 0 and 8"));
}
SetXmlNodeString(INDENT_ALIGN_PATH, value.ToString());
}
}
const string TextVerticalPath = "xdr:sp/xdr:txBody/a:bodyPr/@vert";
/// <summary>
/// Vertical text
/// </summary>
public eTextVerticalType TextVertical
{
get
{
return GetTextVerticalEnum(GetXmlNodeString(TextVerticalPath));
}
set
{
SetXmlNodeString(TextVerticalPath, GetTextVerticalText(value));
}
}
#endregion
#region "Private Methods"
private string ShapeStartXml()
{
StringBuilder xml = new StringBuilder();
xml.AppendFormat("<xdr:nvSpPr><xdr:cNvPr id=\"{0}\" name=\"{1}\" /><xdr:cNvSpPr /></xdr:nvSpPr><xdr:spPr><a:prstGeom prst=\"rect\"><a:avLst /></a:prstGeom></xdr:spPr><xdr:style><a:lnRef idx=\"2\"><a:schemeClr val=\"accent1\"><a:shade val=\"50000\" /></a:schemeClr></a:lnRef><a:fillRef idx=\"1\"><a:schemeClr val=\"accent1\" /></a:fillRef><a:effectRef idx=\"0\"><a:schemeClr val=\"accent1\" /></a:effectRef><a:fontRef idx=\"minor\"><a:schemeClr val=\"lt1\" /></a:fontRef></xdr:style><xdr:txBody><a:bodyPr vertOverflow=\"clip\" rtlCol=\"0\" anchor=\"ctr\" /><a:lstStyle /><a:p></a:p></xdr:txBody>", _id, Name);
return xml.ToString();
}
#endregion
internal new string Id
{
get { return Name + Text; }
}
}
}