/************** *****************************************************************
* 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
{
///
/// The title of a chart
///
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 = "";
}
TopNode = topNode;
SchemaNodeOrder = new string[] { "tx","bodyPr", "lstStyle", "layout", "overlay" };
}
const string titlePath = "c:tx/c:rich/a:p/a:r/a:t";
///
/// The text
///
public string Text
{
get
{
//return GetXmlNode(titlePath);
return RichText.Text;
}
set
{
//SetXmlNode(titlePath, value);
RichText.Text = value;
}
}
ExcelDrawingBorder _border = null;
///
/// A reference to the border properties
///
public ExcelDrawingBorder Border
{
get
{
if (_border == null)
{
_border = new ExcelDrawingBorder(NameSpaceManager, TopNode, "c:spPr/a:ln");
}
return _border;
}
}
ExcelDrawingFill _fill = null;
///
/// A reference to the fill properties
///
public ExcelDrawingFill Fill
{
get
{
if (_fill == null)
{
_fill = new ExcelDrawingFill(NameSpaceManager, TopNode, "c:spPr");
}
return _fill;
}
}
//ExcelTextFont _font = null;
///
/// A reference to the font properties
///
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;
///
/// Richtext
///
public ExcelParagraphCollection RichText
{
get
{
if (_richText == null)
{
_richText = new ExcelParagraphCollection(NameSpaceManager, TopNode, "c:tx/c:rich/a:p", paragraphNodeOrder);
}
return _richText;
}
}
///
/// Show without overlaping the chart.
///
public bool Overlay
{
get
{
return GetXmlNodeBool("c:overlay/@val");
}
set
{
SetXmlNodeBool("c:overlay/@val", value);
}
}
///
/// 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.
///
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";
///
/// Vertical text
///
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));
}
}
///
/// Rotation in degrees (0-360)
///
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());
}
}
}
}