Ejemplo n.º 1
0
        /// <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);
        }
Ejemplo n.º 2
0
        /// <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);
                }
            }
        }
Ejemplo n.º 3
0
        /// <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);
                }
            }
        }