/*******************************************************************************
|
* 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 2010-06-01
|
* Jan Källman License changed GPL-->LGPL 2011-12-16
|
*******************************************************************************/
|
using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Xml;
|
using System.Globalization;
|
using System.Drawing;
|
|
namespace HH.WMS.Utils.EPPlus.Drawing.Vml
|
{
|
/// <summary>
|
/// Drawing object used for comments
|
/// </summary>
|
public class ExcelVmlDrawingComment : ExcelVmlDrawingBase, IRangeID
|
{
|
internal ExcelVmlDrawingComment(XmlNode topNode, ExcelRangeBase range, XmlNamespaceManager ns) :
|
base(topNode, ns)
|
{
|
Range = range;
|
SchemaNodeOrder = new string[] { "fill", "stroke", "shadow", "path", "textbox", "ClientData", "MoveWithCells", "SizeWithCells", "Anchor", "Locked", "AutoFill", "LockText", "TextHAlign", "TextVAlign", "Row", "Column", "Visible" };
|
}
|
internal ExcelRangeBase Range { get; set; }
|
//public string Id
|
//{
|
// get
|
// {
|
// return GetXmlNodeString("@id");
|
// }
|
// set
|
// {
|
// SetXmlNodeString("@id",value);
|
// }
|
//}
|
const string VERTICAL_ALIGNMENT_PATH="x:ClientData/x:TextVAlign";
|
/// <summary>
|
/// Vertical alignment for text
|
/// </summary>
|
public eTextAlignVerticalVml VerticalAlignment
|
{
|
get
|
{
|
switch (GetXmlNodeString(VERTICAL_ALIGNMENT_PATH))
|
{
|
case "Center":
|
return eTextAlignVerticalVml.Center;
|
case "Bottom":
|
return eTextAlignVerticalVml.Bottom;
|
default:
|
return eTextAlignVerticalVml.Top;
|
}
|
}
|
set
|
{
|
switch (value)
|
{
|
case eTextAlignVerticalVml.Center:
|
SetXmlNodeString(VERTICAL_ALIGNMENT_PATH, "Center");
|
break;
|
case eTextAlignVerticalVml.Bottom:
|
SetXmlNodeString(VERTICAL_ALIGNMENT_PATH, "Bottom");
|
break;
|
default:
|
DeleteNode(VERTICAL_ALIGNMENT_PATH);
|
break;
|
}
|
}
|
}
|
const string HORIZONTAL_ALIGNMENT_PATH="x:ClientData/x:TextHAlign";
|
/// <summary>
|
/// Horizontal alignment for text
|
/// </summary>
|
public eTextAlignHorizontalVml HorizontalAlignment
|
{
|
get
|
{
|
switch (GetXmlNodeString(HORIZONTAL_ALIGNMENT_PATH))
|
{
|
case "Center":
|
return eTextAlignHorizontalVml.Center;
|
case "Right":
|
return eTextAlignHorizontalVml.Right;
|
default:
|
return eTextAlignHorizontalVml.Left;
|
}
|
}
|
set
|
{
|
switch (value)
|
{
|
case eTextAlignHorizontalVml.Center:
|
SetXmlNodeString(HORIZONTAL_ALIGNMENT_PATH, "Center");
|
break;
|
case eTextAlignHorizontalVml.Right:
|
SetXmlNodeString(HORIZONTAL_ALIGNMENT_PATH, "Right");
|
break;
|
default:
|
DeleteNode(HORIZONTAL_ALIGNMENT_PATH);
|
break;
|
}
|
}
|
}
|
const string VISIBLE_PATH = "x:ClientData/x:Visible";
|
/// <summary>
|
/// If the drawing object is visible.
|
/// </summary>
|
public bool Visible
|
{
|
get
|
{
|
return (TopNode.SelectSingleNode(VISIBLE_PATH, NameSpaceManager)!=null);
|
}
|
set
|
{
|
if (value)
|
{
|
CreateNode(VISIBLE_PATH);
|
Style = SetStyle(Style,"visibility", "visible");
|
}
|
else
|
{
|
DeleteNode(VISIBLE_PATH);
|
Style = SetStyle(Style,"visibility", "hidden");
|
}
|
}
|
}
|
const string BACKGROUNDCOLOR_PATH = "@fillcolor";
|
const string BACKGROUNDCOLOR2_PATH = "v:fill/@color2";
|
/// <summary>
|
/// Background color
|
/// </summary>
|
public Color BackgroundColor
|
{
|
get
|
{
|
string col = GetXmlNodeString(BACKGROUNDCOLOR_PATH);
|
if (col == "")
|
{
|
return Color.FromArgb(0xff, 0xff, 0xe1);
|
}
|
else
|
{
|
if(col.StartsWith("#")) col=col.Substring(1,col.Length-1);
|
int res;
|
if (int.TryParse(col,System.Globalization.NumberStyles.AllowHexSpecifier, CultureInfo.InvariantCulture, out res))
|
{
|
return Color.FromArgb(res);
|
}
|
else
|
{
|
return Color.Empty;
|
}
|
}
|
}
|
set
|
{
|
string color = "#" + value.ToArgb().ToString("X").Substring(2, 6);
|
SetXmlNodeString(BACKGROUNDCOLOR_PATH, color);
|
//SetXmlNode(BACKGROUNDCOLOR2_PATH, color);
|
}
|
}
|
const string LINESTYLE_PATH="v:stroke/@dashstyle";
|
const string ENDCAP_PATH = "v:stroke/@endcap";
|
/// <summary>
|
/// Linestyle for border
|
/// </summary>
|
public eLineStyleVml LineStyle
|
{
|
get
|
{
|
string v=GetXmlNodeString(LINESTYLE_PATH);
|
if (v == "")
|
{
|
return eLineStyleVml.Solid;
|
}
|
else if (v == "1 1")
|
{
|
v = GetXmlNodeString(ENDCAP_PATH);
|
return (eLineStyleVml)Enum.Parse(typeof(eLineStyleVml), v, true);
|
}
|
else
|
{
|
return (eLineStyleVml)Enum.Parse(typeof(eLineStyleVml), v, true);
|
}
|
}
|
set
|
{
|
if (value == eLineStyleVml.Round || value == eLineStyleVml.Square)
|
{
|
SetXmlNodeString(LINESTYLE_PATH, "1 1");
|
if (value == eLineStyleVml.Round)
|
{
|
SetXmlNodeString(ENDCAP_PATH, "round");
|
}
|
else
|
{
|
DeleteNode(ENDCAP_PATH);
|
}
|
}
|
else
|
{
|
string v = value.ToString();
|
v = v.Substring(0, 1).ToLower() + v.Substring(1, v.Length - 1);
|
SetXmlNodeString(LINESTYLE_PATH, v);
|
DeleteNode(ENDCAP_PATH);
|
}
|
}
|
}
|
const string LINECOLOR_PATH="@strokecolor";
|
/// <summary>
|
/// Line color
|
/// </summary>
|
public Color LineColor
|
{
|
get
|
{
|
string col = GetXmlNodeString(LINECOLOR_PATH);
|
if (col == "")
|
{
|
return Color.Black;
|
}
|
else
|
{
|
if (col.StartsWith("#")) col = col.Substring(1, col.Length - 1);
|
int res;
|
if (int.TryParse(col, System.Globalization.NumberStyles.AllowHexSpecifier, CultureInfo.InvariantCulture, out res))
|
{
|
return Color.FromArgb(res);
|
}
|
else
|
{
|
return Color.Empty;
|
}
|
}
|
}
|
set
|
{
|
string color = "#" + value.ToArgb().ToString("X").Substring(2, 6);
|
SetXmlNodeString(LINECOLOR_PATH, color);
|
}
|
}
|
const string LINEWIDTH_PATH="@strokeweight";
|
/// <summary>
|
/// Width of the border
|
/// </summary>
|
public Single LineWidth
|
{
|
get
|
{
|
string wt=GetXmlNodeString(LINEWIDTH_PATH);
|
if (wt == "") return (Single).75;
|
if(wt.EndsWith("pt")) wt=wt.Substring(0,wt.Length-2);
|
|
Single ret;
|
if(Single.TryParse(wt,System.Globalization.NumberStyles.Any, CultureInfo.InvariantCulture, out ret))
|
{
|
return ret;
|
}
|
else
|
{
|
return 0;
|
}
|
}
|
set
|
{
|
SetXmlNodeString(LINEWIDTH_PATH, value.ToString(CultureInfo.InvariantCulture) + "pt");
|
}
|
}
|
///// <summary>
|
///// Width of the Comment
|
///// </summary>
|
//public Single Width
|
//{
|
// get
|
// {
|
// string v;
|
// GetStyle("width", out v);
|
// if(v.EndsWith("pt"))
|
// {
|
// v = v.Substring(0, v.Length - 2);
|
// }
|
// short ret;
|
// if (short.TryParse(v,System.Globalization.NumberStyles.Any, CultureInfo.InvariantCulture, out ret))
|
// {
|
// return ret;
|
// }
|
// else
|
// {
|
// return 0;
|
// }
|
// }
|
// set
|
// {
|
// SetStyle("width", value.ToString("N2",CultureInfo.InvariantCulture) + "pt");
|
// }
|
//}
|
///// <summary>
|
///// Height of the Comment
|
///// </summary>
|
//public Single Height
|
//{
|
// get
|
// {
|
// string v;
|
// GetStyle("height", out v);
|
// if (v.EndsWith("pt"))
|
// {
|
// v = v.Substring(0, v.Length - 2);
|
// }
|
// short ret;
|
// if (short.TryParse(v, System.Globalization.NumberStyles.Any, CultureInfo.InvariantCulture, out ret))
|
// {
|
// return ret;
|
// }
|
// else
|
// {
|
// return 0;
|
// }
|
// }
|
// set
|
// {
|
// SetStyle("height", value.ToString("N2", CultureInfo.InvariantCulture) + "pt");
|
// }
|
//}
|
const string TEXTBOX_STYLE_PATH = "v:textbox/@style";
|
/// <summary>
|
/// Autofits the drawingobject
|
/// </summary>
|
public bool AutoFit
|
{
|
get
|
{
|
string value;
|
GetStyle(GetXmlNodeString(TEXTBOX_STYLE_PATH), "mso-fit-shape-to-text", out value);
|
return value=="t";
|
}
|
set
|
{
|
SetXmlNodeString(TEXTBOX_STYLE_PATH, SetStyle(GetXmlNodeString(TEXTBOX_STYLE_PATH),"mso-fit-shape-to-text", value?"t":""));
|
}
|
}
|
const string LOCKED_PATH = "x:ClientData/x:Locked";
|
/// <summary>
|
/// If the object is locked when the sheet is protected
|
/// </summary>
|
public bool Locked
|
{
|
get
|
{
|
return GetXmlNodeBool(LOCKED_PATH, false);
|
}
|
set
|
{
|
SetXmlNodeBool(LOCKED_PATH, value, false);
|
}
|
}
|
const string LOCK_TEXT_PATH = "x:ClientData/x:LockText";
|
/// <summary>
|
/// Specifies that the object's text is locked
|
/// </summary>
|
public bool LockText
|
{
|
get
|
{
|
return GetXmlNodeBool(LOCK_TEXT_PATH, false);
|
}
|
set
|
{
|
SetXmlNodeBool(LOCK_TEXT_PATH, value, false);
|
}
|
}
|
ExcelVmlDrawingPosition _from = null;
|
/// <summary>
|
/// From position. For comments only when Visible=true.
|
/// </summary>
|
public ExcelVmlDrawingPosition From
|
{
|
get
|
{
|
if (_from == null)
|
{
|
_from = new ExcelVmlDrawingPosition(NameSpaceManager, TopNode.SelectSingleNode("x:ClientData", NameSpaceManager), 0);
|
}
|
return _from;
|
}
|
}
|
ExcelVmlDrawingPosition _to = null;
|
/// <summary>
|
/// To position. For comments only when Visible=true.
|
/// </summary>
|
public ExcelVmlDrawingPosition To
|
{
|
get
|
{
|
if (_to == null)
|
{
|
_to = new ExcelVmlDrawingPosition(NameSpaceManager, TopNode.SelectSingleNode("x:ClientData", NameSpaceManager), 4);
|
}
|
return _to;
|
}
|
}
|
const string STYLE_PATH = "@style";
|
internal string Style
|
{
|
get
|
{
|
return GetXmlNodeString(STYLE_PATH);
|
}
|
set
|
{
|
SetXmlNodeString(STYLE_PATH, value);
|
}
|
}
|
#region IRangeID Members
|
|
ulong IRangeID.RangeID
|
{
|
get
|
{
|
return ExcelCellBase.GetCellID(Range.Worksheet.SheetID, Range.Start.Row, Range.Start.Column);
|
}
|
set
|
{
|
|
}
|
}
|
|
#endregion
|
}
|
}
|
