/// <summary>
/// Retrieved by specifying a name from WorkbookPart to X15.Timeline.
/// </summary>
/// <param name="workbookPart">Including X15.Timeline in WorkbookPart</param>
/// <param name="slicerName">Timeline name</param>
/// <returns>Timeline name match X15.Timeline</returns>
private X15.Timeline GetTimeLine(WorkbookPart workbookPart, string tileLineName)
{
X15.Timeline returnTimeline = null;
foreach (WorksheetPart worksheetPart in workbookPart.WorksheetParts)
{
foreach (TimeLinePart timeLinePart in worksheetPart.TimeLineParts)
{
foreach (X15.Timeline timeline in timeLinePart.Timelines)
{
if (timeline.Name == tileLineName)
{
returnTimeline = timeline;
break;
}
}
if (returnTimeline != null)
{
break;
}
}
if (returnTimeline != null)
{
break;
}
}
return(returnTimeline);
}
/// <summary>
/// Edit TimeLine attributes
/// </summary>
/// <param name="filePath">Editing target file path</param>
/// <param name="log">Logger</param>
public void EditAttributes(string filePath, VerifiableLog log)
{
using (SpreadsheetDocument package = SpreadsheetDocument.Open(filePath, true))
{
X15.Timeline timeline = null;
//ShowTimeLevel
try
{
timeline = GetTimeLine(package.WorkbookPart, this.TileLine01);
timeline.ShowTimeLevel = true;
log.Pass("Set \"ShowTimeLevel\" attribute, timeline control name is \"{0}\". set value is true.", timeline.Name);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine02);
timeline.ShowTimeLevel = false;
log.Pass("Set \"ShowTimeLevel\" attribute. timeline control name is \"{0}\". set value is false.", timeline.Name);
}
catch (Exception e)
{
log.Fail(e.Message);
}
//Cache
try
{
timeline = GetTimeLine(package.WorkbookPart, this.TileLine03);
timeline.Cache = "NativeTimeline_Date";
log.Pass("Set \"Cache\" attribute. timeline control name is \"{0}\". set value is \"NativeTimeline_Date\".", timeline.Name);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine04);
timeline.Cache = "NativeTimeline_DeliveryDate";
log.Pass("Set \"Cache\" attribute. timeline control name is \"{0}\". set value is \"NativeTimeline_DeliveryDate\".", timeline.Name);
}
catch (Exception e)
{
log.Fail(e.Message);
}
//ShowSelectionLabel
try
{
timeline = GetTimeLine(package.WorkbookPart, this.TileLine05);
timeline.ShowSelectionLabel = true;
log.Pass("Set \"ShowSelectionLabel\" attribute. timeline control name is \"{0}\". set value is true.", timeline.Name);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine06);
timeline.ShowSelectionLabel = false;
log.Pass("Set \"ShowSelectionLabel\" attribute. timeline control name is \"{0}\". set value is false.", timeline.Name);
}
catch (Exception e)
{
log.Fail(e.Message);
}
//ShowHeader
try
{
timeline = GetTimeLine(package.WorkbookPart, this.TileLine07);
timeline.ShowHeader = true;
log.Pass("Set \"ShowHeader\" attribute. timeline control name is \"{0}\". set value is true.", timeline.Name);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine08);
timeline.ShowHeader = false;
log.Pass("Set \"ShowHeader\" attribute. timeline control name is \"{0}\". set value is false.", timeline.Name);
}
catch (Exception e)
{
log.Fail(e.Message);
}
//Style
try
{
timeline = GetTimeLine(package.WorkbookPart, this.TileLine09);
timeline.Style = "TimeSlicerStyleLight2";
log.Pass("Set \"Style\" attribute. timeline control name is \"{0}\". set value is \"TimeSlicerStyleLight2\".", timeline.Name);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine10);
timeline.Style = null;
log.Pass("Set \"Style\" attribute. timeline control name is \"{0}\". set value is null.", timeline.Name);
}
catch (Exception e)
{
log.Fail(e.Message);
}
//Caption
try
{
timeline = GetTimeLine(package.WorkbookPart, this.TileLine11);
timeline.Caption = null;
log.Pass("Set \"Caption\" attribute. timeline control name is \"{0}\". set value is null.", timeline.Name);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine12);
timeline.Caption = "0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789";
log.Pass("Set \"Caption\" attribute. timeline control name is \"{0}\". set value is \"0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789\".", timeline.Name);
}
catch (Exception e)
{
log.Fail(e.Message);
}
//ScrollPosition
try
{
timeline = GetTimeLine(package.WorkbookPart, this.TileLine13);
timeline.ScrollPosition = DateTime.Parse("1900-01-01");
log.Pass("Set \"ScrollPosition\" attribute. timeline control name is \"{0}\". set value is \"1900-01-01\".", timeline.Name);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine14);
timeline.ScrollPosition = DateTime.Parse("2010-12-31");
log.Pass("Set \"ScrollPosition\" attribute. timeline control name is \"{0}\". set value is \"2010-12-31\".", timeline.Name);
}
catch (Exception e)
{
log.Fail(e.Message);
}
//Level
try
{
timeline = GetTimeLine(package.WorkbookPart, this.TileLine15);
timeline.Level.Value = 0U;
log.Pass("Set \"ScrollPosition\" attribute. timeline control name is \"{0}\". set value is 0(Years).", timeline.Name);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine16);
timeline.Level.Value = 1U;
log.Pass("Set \"ScrollPosition\" attribute. timeline control name is \"{0}\". set value is 1(Quarters).", timeline.Name);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine17);
timeline.Level.Value = 2U;
log.Pass("Set \"ScrollPosition\" attribute. timeline control name is \"{0}\". set value is 2(Months).", timeline.Name);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine18);
timeline.Level.Value = 3U;
log.Pass("Set \"ScrollPosition\" attribute. timeline control name is \"{0}\". set value is 3(Days).", timeline.Name);
}
catch (Exception e)
{
log.Fail(e.Message);
}
//ShowHorizontalScrollbar
try
{
timeline = GetTimeLine(package.WorkbookPart, this.TileLine19);
timeline.ShowHorizontalScrollbar = true;
log.Pass("Set \"ShowHorizontalScrollbar\" attribute. timeline control name is \"{0}\". set value is true.", timeline.Name);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine20);
timeline.ShowHorizontalScrollbar = false;
log.Pass("Set \"ShowHorizontalScrollbar\" attribute. timeline control name is \"{0}\". set value is false.", timeline.Name);
}
catch (Exception e)
{
log.Fail(e.Message);
}
//DefaultTimelineStyle attribute in TimelineStyle element
try
{
X15.TimelineStyles timelineStyles = package.WorkbookPart.WorkbookStylesPart.Stylesheet.StylesheetExtensionList.Descendants <X15.TimelineStyles>().Single();
timelineStyles.DefaultTimelineStyle.Value = this.timelineStyleName2;
log.Pass("Set DefaultTimelineStyle attribute value in \"X15.TimelineStyles\" element. Set value is [{0}].", this.timelineStyleName2);
}
catch (Exception e)
{
log.Fail(e.Message);
}
}
}
/// <summary>
/// Verify the TileLine attributes value.
/// </summary>
/// <param name="filePath">Target file path</param>
/// <param name="log">Logger</param>
public void VerifyEditedAttribute(string filePath, VerifiableLog log)
{
using (SpreadsheetDocument package = SpreadsheetDocument.Open(filePath, false))
{
X15.Timeline timeline = null;
//verify ShowTimeLevel
try
{
timeline = GetTimeLine(package.WorkbookPart, this.TileLine01);
log.Verify(timeline.ShowTimeLevel == true, "Timeline control in \"ShowTimeLevel\" attribute value is Verify. Name=[{0}],Value=[true].", timeline.Name);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine02);
log.Verify(timeline.ShowTimeLevel == false, "Timeline control in \"ShowTimeLevel\" attribute value is Verify. Name=[{0}],Value=[false].", timeline.Name);
}
catch (Exception e)
{
log.Fail(e.Message);
}
//Verify Cache
try
{
timeline = GetTimeLine(package.WorkbookPart, this.TileLine03);
log.Verify(timeline.Cache == "NativeTimeline_Date", "Timeline control in Cache attribute value is Verify. Name=[{0}],Value=[{1}].", timeline.Name, timeline.Cache);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine04);
log.Verify(timeline.Cache == "NativeTimeline_DeliveryDate", "Timeline control in Cache attribute value is Verify. Name=[{0}],Value=[{1}].", timeline.Name, timeline.Cache);
}
catch (Exception e)
{
log.Fail(e.Message);
}
//Verify ShowSelectionLabel
try
{
timeline = GetTimeLine(package.WorkbookPart, this.TileLine05);
log.Verify(timeline.ShowSelectionLabel, "Timeline control in \"ShowSelectionLabel\" attribute value is Verify. Name=[{0}],Value=[true].", timeline.Name);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine06);
log.Verify(timeline.ShowSelectionLabel == false, "Timeline control in \"ShowSelectionLabel\" attribute value is Verify. Name=[{0}],Value=[false].", timeline.Name);
}
catch (Exception e)
{
log.Fail(e.Message);
}
//Verify ShowHeader
try
{
timeline = GetTimeLine(package.WorkbookPart, this.TileLine07);
log.Verify(timeline.ShowHeader == true, "Timeline control in \"ShowHeader\" attribute value is Verify. Name=[{0}],Value=[true].", timeline.Name);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine08);
log.Verify(timeline.ShowHeader == false, "Timeline control in \"ShowHeader\" attribute value is Verify. Name=[{0}],Value=[false].", timeline.Name);
}
catch (Exception e)
{
log.Fail(e.Message);
}
//Verify Style
try
{
timeline = GetTimeLine(package.WorkbookPart, this.TileLine09);
log.Verify(timeline.Style == "TimeSlicerStyleLight2", "Timeline control in \"Style\" attribute value is Verify. Name=[{0}],Value=[{1}].", timeline.Name, timeline.Style);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine10);
log.Verify(timeline.Style == null, "Timeline control in \"Style\" attribute value is Verify. Name=[{0}],Value=[{1}].", timeline.Name, timeline.Style);
}
catch (Exception e)
{
log.Fail(e.Message);
}
//Verify Caption
try
{
timeline = GetTimeLine(package.WorkbookPart, this.TileLine11);
log.Verify(timeline.Caption == null, "Timeline control in \"Caption\" attribute value is Verify. Name=[{0}],Value=[{1}].", timeline.Name, timeline.Caption);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine12);
log.Verify(timeline.Caption == "0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789", "Timeline control in \"Caption\" attribute value is Verify. Name=[{0}],Value=[{1}].", timeline.Name, timeline.Caption);
}
catch (Exception e)
{
log.Fail(e.Message);
}
//Verify ScrollPosition
try
{
timeline = GetTimeLine(package.WorkbookPart, this.TileLine13);
log.Verify(timeline.ScrollPosition.Value == DateTime.Parse("1900-01-01"), "Timeline control in \"ScrollPosition\" attribute value is Verify. Name=[{0}],Value=[{1}].", timeline.Name, timeline.ScrollPosition);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine14);
log.Verify(timeline.ScrollPosition.Value == DateTime.Parse("2010-12-31"), "Timeline control in \"ScrollPosition\" attribute value is Verify. Name=[{0}],Value=[{1}].", timeline.Name, timeline.ScrollPosition);
}
catch (Exception e)
{
log.Fail(e.Message);
}
//Verify Level
try
{
timeline = GetTimeLine(package.WorkbookPart, this.TileLine15);
log.Verify(timeline.Level == 0U, "Timeline control in \"Level\" attribute value is Verify. Name=[{0}],Value=[{1}].", timeline.Name, timeline.Level);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine16);
log.Verify(timeline.Level == 1U, "Timeline control in \"Level\" attribute value is Verify. Name=[{0}],Value=[{1}].", timeline.Name, timeline.Level);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine17);
log.Verify(timeline.Level == 2U, "Timeline control in \"Level\" attribute value is Verify. Name=[{0}],Value=[{1}].", timeline.Name, timeline.Level);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine18);
log.Verify(timeline.Level == 3U, "Timeline control in \"Level\" attribute value is Verify. Name=[{0}],Value=[{1}].", timeline.Name, timeline.Level);
}
catch (Exception e)
{
log.Fail(e.Message);
}
//Verify ShowHorizontalScrollbar
try
{
timeline = GetTimeLine(package.WorkbookPart, this.TileLine19);
log.Verify(timeline.ShowHorizontalScrollbar, "Timeline control in \"ShowHorizontalScrollbar\" attribute value is Verify. Name=[{0}],Value=[true].", timeline.Name);
timeline = GetTimeLine(package.WorkbookPart, this.TileLine20);
log.Verify(timeline.ShowHorizontalScrollbar == false, "Timeline control in \"ShowHorizontalScrollbar\" attribute value is Verify. Name=[{0}],Value=[false].", timeline.Name);
}
catch (Exception e)
{
log.Fail(e.Message);
}
//Verify DefaultTimelineStyle attribute in TimelineStyle element
try
{
X15.TimelineStyles timelineStyles = package.WorkbookPart.WorkbookStylesPart.Stylesheet.StylesheetExtensionList.Descendants <X15.TimelineStyles>().Single();
log.Verify(timelineStyles.DefaultTimelineStyle == this.timelineStyleName2, "Verify \"DefaultTimelineStyle\" attribute. Value=[{0}]", timelineStyles.DefaultTimelineStyle);
}
catch (Exception e)
{
log.Fail(e.Message);
}
}
}
