| /************** ***************************************************************** | |
| * 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 Added 2009-10-01 | |
| * Jan Källman License changed GPL-->LGPL 2011-12-16 | |
| *******************************************************************************/ | |
| using System; | |
| using System.Collections.Generic; | |
| using System.Text; | |
| using System.Xml; | |
| using OfficeOpenXml.Style; | |
| namespace OfficeOpenXml.Drawing.Chart | |
| { | |
| /// <summary> | |
| /// The title of a chart | |
| /// </summary> | |
| public class ExcelChartTitle : XmlHelper | |
| { | |
| internal ExcelChartTitle(XmlNamespaceManager nameSpaceManager, XmlNode node) : | |
| base(nameSpaceManager, node) | |
| { | |
| XmlNode topNode = node.SelectSingleNode("c:title", NameSpaceManager); | |
| if (topNode == null) | |
| { | |
| topNode = node.OwnerDocument.CreateElement("c", "title", ExcelPackage.schemaChart); | |
| node.InsertBefore(topNode, node.ChildNodes[0]); | |
| topNode.InnerXml = "<c:tx><c:rich><a:bodyPr /><a:lstStyle /><a:p><a:pPr><a:defRPr sz=\"1800\" b=\"0\" /></a:pPr><a:r><a:t /></a:r></a:p></c:rich></c:tx><c:layout /><c:overlay val=\"0\" />"; | |
| } | |
| TopNode = topNode; | |
| SchemaNodeOrder = new string[] { "tx","bodyPr", "lstStyle", "layout", "overlay" }; | |
| } | |
| const string titlePath = "c:tx/c:rich/a:p/a:r/a:t"; | |
| /// <summary> | |
| /// The text | |
| /// </summary> | |
| public string Text | |
| { | |
| get | |
| { | |
| //return GetXmlNode(titlePath); | |
| return RichText.Text; | |
| } | |
| set | |
| { | |
| //SetXmlNode(titlePath, value); | |
| RichText.Text = value; | |
| } | |
| } | |
| ExcelDrawingBorder _border = null; | |
| /// <summary> | |
| /// A reference to the border properties | |
| /// </summary> | |
| public ExcelDrawingBorder Border | |
| { | |
| get | |
| { | |
| if (_border == null) | |
| { | |
| _border = new ExcelDrawingBorder(NameSpaceManager, TopNode, "c:spPr/a:ln"); | |
| } | |
| return _border; | |
| } | |
| } | |
| ExcelDrawingFill _fill = null; | |
| /// <summary> | |
| /// A reference to the fill properties | |
| /// </summary> | |
| public ExcelDrawingFill Fill | |
| { | |
| get | |
| { | |
| if (_fill == null) | |
| { | |
| _fill = new ExcelDrawingFill(NameSpaceManager, TopNode, "c:spPr"); | |
| } | |
| return _fill; | |
| } | |
| } | |
| //ExcelTextFont _font = null; | |
| /// <summary> | |
| /// A reference to the font properties | |
| /// </summary> | |
| public ExcelTextFont Font | |
| { | |
| get | |
| { | |
| //if (_font == null) | |
| //{ | |
| // _font = new ExcelTextFont(NameSpaceManager, TopNode, "c:tx/c:rich/a:p/a:r/a:rPr", new string[] { "rPr", "solidFill", "uFill", "latin", "cs", "r", "rPr", "t" }); | |
| //} | |
| //return _font; | |
| if (_richText==null || _richText.Count == 0) | |
| { | |
| RichText.Add(""); | |
| } | |
| return _richText[0]; | |
| } | |
| } | |
| string[] paragraphNodeOrder = new string[] { "pPr", "defRPr", "solidFill", "uFill", "latin", "cs", "r", "rPr", "t" }; | |
| ExcelParagraphCollection _richText = null; | |
| /// <summary> | |
| /// Richtext | |
| /// </summary> | |
| public ExcelParagraphCollection RichText | |
| { | |
| get | |
| { | |
| if (_richText == null) | |
| { | |
| _richText = new ExcelParagraphCollection(NameSpaceManager, TopNode, "c:tx/c:rich/a:p", paragraphNodeOrder); | |
| } | |
| return _richText; | |
| } | |
| } | |
| /// <summary> | |
| /// Show without overlaping the chart. | |
| /// </summary> | |
| public bool Overlay | |
| { | |
| get | |
| { | |
| return GetXmlNodeBool("c:overlay/@val"); | |
| } | |
| set | |
| { | |
| SetXmlNodeBool("c:overlay/@val", value); | |
| } | |
| } | |
| /// <summary> | |
| /// Specifies the centering of the text box. | |
| /// The way it works fundamentally is to determine the smallest possible "bounds box" for the text and then to center that "bounds box" accordingly. | |
| /// This is different than paragraph alignment, which aligns the text within the "bounds box" for the text. | |
| /// This flag is compatible with all of the different kinds of anchoring. | |
| /// If this attribute is omitted, then a value of 0 or false is implied. | |
| /// </summary> | |
| public bool AnchorCtr | |
| { | |
| get | |
| { | |
| return GetXmlNodeBool("c:tx/c:rich/a:bodyPr/@anchorCtr", false); | |
| } | |
| set | |
| { | |
| SetXmlNodeBool("c:tx/c:rich/a:bodyPr/@anchorCtr", value, false); | |
| } | |
| } | |
| public eTextAnchoringType Anchor | |
| { | |
| get | |
| { | |
| return ExcelDrawing.GetTextAchoringEnum(GetXmlNodeString("c:tx/c:rich/a:bodyPr/@anchor")); | |
| } | |
| set | |
| { | |
| SetXmlNodeString("c:tx/c:rich/a:bodyPr/@anchorCtr", ExcelDrawing.GetTextAchoringText(value)); | |
| } | |
| } | |
| const string TextVerticalPath = "xdr:sp/xdr:txBody/a:bodyPr/@vert"; | |
| /// <summary> | |
| /// Vertical text | |
| /// </summary> | |
| public eTextVerticalType TextVertical | |
| { | |
| get | |
| { | |
| return ExcelDrawing.GetTextVerticalEnum(GetXmlNodeString("c:tx/c:rich/a:bodyPr/@vert")); | |
| } | |
| set | |
| { | |
| SetXmlNodeString("c:tx/c:rich/a:bodyPr/@vert", ExcelDrawing.GetTextVerticalText(value)); | |
| } | |
| } | |
| /// <summary> | |
| /// Rotation in degrees (0-360) | |
| /// </summary> | |
| public double Rotation | |
| { | |
| get | |
| { | |
| var i=GetXmlNodeInt("c:tx/c:rich/a:bodyPr/@rot"); | |
| if (i < 0) | |
| { | |
| return 360 - (i / 60000); | |
| } | |
| else | |
| { | |
| return (i / 60000); | |
| } | |
| } | |
| set | |
| { | |
| int v; | |
| if(value <0 || value > 360) | |
| { | |
| throw(new ArgumentOutOfRangeException("Rotation must be between 0 and 360")); | |
| } | |
| if (value > 180) | |
| { | |
| v = (int)((value - 360) * 60000); | |
| } | |
| else | |
| { | |
| v = (int)(value * 60000); | |
| } | |
| SetXmlNodeString("c:tx/c:rich/a:bodyPr/@rot", v.ToString()); | |
| } | |
| } | |
| } | |
| } |