Exemplo n.º 1
0
        ThisWorkbook_SetVisualAttribute2
        (
            Object sender,
            SetVisualAttributeEventArgs e
        )
        {
            Debug.Assert(e != null);
            AssertValid();

            Microsoft.Office.Interop.Excel.Range oSelectedRange;

            if (e.VisualAttributeSet ||
                !m_oSheets1And2Helper.TryGetSelectedRange(out oSelectedRange))
            {
                return;
            }

            // See if the specified attribute is set by the helper class.

            m_oSheets1And2Helper.SetVisualAttribute(e, oSelectedRange,
                                                    EdgeTableColumnNames.Color, CommonTableColumnNames.Alpha);

            if (e.VisualAttributeSet)
            {
                return;
            }

            if (e.VisualAttribute == VisualAttributes.EdgeWidth)
            {
                EdgeWidthDialog oEdgeWidthDialog = new EdgeWidthDialog();

                if (oEdgeWidthDialog.ShowDialog() == DialogResult.OK)
                {
                    ExcelUtil.SetVisibleSelectedTableColumnData(
                        this.Edges.InnerObject, oSelectedRange,
                        EdgeTableColumnNames.Width, oEdgeWidthDialog.EdgeWidth);

                    e.VisualAttributeSet = true;
                }
            }
            else if (e.VisualAttribute == VisualAttributes.EdgeVisibility)
            {
                Debug.Assert(e.AttributeValue is EdgeWorksheetReader.Visibility);

                ExcelUtil.SetVisibleSelectedTableColumnData(
                    this.Edges.InnerObject, oSelectedRange,
                    CommonTableColumnNames.Visibility,

                    (new EdgeVisibilityConverter()).GraphToWorkbook(
                        (EdgeWorksheetReader.Visibility)e.AttributeValue)
                    );

                e.VisualAttributeSet = true;
            }
        }
Exemplo n.º 2
0
        //*************************************************************************
        //  Method: ThisWorkbook_SetVisualAttribute2()
        //
        /// <summary>
        /// Handles the SetVisualAttribute2 event on ThisWorkbook.
        /// </summary>
        ///
        /// <param name="sender">
        /// Standard event argument.
        /// </param>
        ///
        /// <param name="e">
        /// Standard event argument.
        /// </param>
        //*************************************************************************
        private void ThisWorkbook_SetVisualAttribute2(
            Object sender,
            SetVisualAttributeEventArgs e
            )
        {
            Debug.Assert(e != null);
            AssertValid();

            Microsoft.Office.Interop.Excel.Range oSelectedRange;

            if ( e.VisualAttributeSet ||
            !m_oSheets1And2Helper.TryGetSelectedRange(out oSelectedRange) )
            {
            return;
            }

            // See if the specified attribute is set by the helper class.

            m_oSheets1And2Helper.SetVisualAttribute(e, oSelectedRange,
            EdgeTableColumnNames.Color, CommonTableColumnNames.Alpha);

            if (e.VisualAttributeSet)
            {
            return;
            }

            if (e.VisualAttribute == VisualAttributes.EdgeWidth)
            {
            EdgeWidthDialog oEdgeWidthDialog = new EdgeWidthDialog();

            if (oEdgeWidthDialog.ShowDialog() == DialogResult.OK)
            {
                ExcelUtil.SetVisibleSelectedTableColumnData(
                    this.Edges.InnerObject, oSelectedRange,
                    EdgeTableColumnNames.Width, oEdgeWidthDialog.EdgeWidth);

                e.VisualAttributeSet = true;
            }
            }
            else if (e.VisualAttribute == VisualAttributes.EdgeVisibility)
            {
            Debug.Assert(e.AttributeValue is EdgeWorksheetReader.Visibility);

            ExcelUtil.SetVisibleSelectedTableColumnData(
                this.Edges.InnerObject, oSelectedRange,
                CommonTableColumnNames.Visibility,

                ( new EdgeVisibilityConverter() ).GraphToWorkbook(
                    (EdgeWorksheetReader.Visibility)e.AttributeValue)
                );

            e.VisualAttributeSet = true;
            }
        }