コード例 #1
0
ファイル: ExcelWriter.cs プロジェクト: Daoting/dt
        public void GetPane(short sheet, ref int x, ref int y, ref int rwTop, ref int columnLeft, ref int activePane)
        {
            IExcelWorksheet worksheet = this._workbook.Worksheets[sheet];

            ExcelWorksheet.ExcelViewportInfo defaultViewport = worksheet.DefaultViewport;
            if (defaultViewport != null)
            {
                double num             = 0.0;
                double num2            = 0.0;
                int    rowPaneCount    = defaultViewport.RowPaneCount;
                int    columnPaneCount = defaultViewport.ColumnPaneCount;
                if ((rowPaneCount == 2) || (columnPaneCount == 2))
                {
                    bool flag  = true;
                    bool flag2 = true;
                    if (rowPaneCount == 2)
                    {
                        if (defaultViewport.ActiveRowPane == 1)
                        {
                            flag = false;
                        }
                        if (defaultViewport.PreferredHeight[0] == -1)
                        {
                            y = 0x12;
                        }
                        else
                        {
                            y = defaultViewport.PreferredHeight[0] + 0x12;
                        }
                        num   = (Convert.ToDouble((int)y, (IFormatProvider)CultureInfo.InvariantCulture) * 1440.0) / 96.0;
                        y     = Convert.ToInt32((double)num, (IFormatProvider)CultureInfo.InvariantCulture);
                        rwTop = defaultViewport.TopRow[1];
                    }
                    else
                    {
                        y = 0;
                    }
                    if (columnPaneCount == 2)
                    {
                        if (defaultViewport.ActiveColumnPane == 1)
                        {
                            flag2 = false;
                        }
                        if (defaultViewport.PreferredWidth[0] == -1)
                        {
                            x = 0x22;
                        }
                        else
                        {
                            x = defaultViewport.PreferredWidth[0] + 0x22;
                        }
                        num2       = (Convert.ToDouble((int)x, (IFormatProvider)CultureInfo.InvariantCulture) * 1440.0) / 96.0;
                        x          = Convert.ToInt32((double)num2, (IFormatProvider)CultureInfo.InvariantCulture);
                        columnLeft = defaultViewport.LeftColumn[1];
                    }
                    else
                    {
                        x = 0;
                    }
                    if (flag)
                    {
                        if (flag2)
                        {
                            activePane = 3;
                        }
                        else
                        {
                            activePane = 1;
                        }
                    }
                    else if (flag2)
                    {
                        activePane = 2;
                    }
                    else
                    {
                        activePane = 0;
                    }
                }
            }
        }
コード例 #2
0
ファイル: ExcelWriter.cs プロジェクト: Daoting/dt
        public bool GetSelectionList(short sheet, List <GcRect> selectionList, ref GcPoint activeCell, ref PaneType paneIndex)
        {
            IExcelWorksheet worksheet         = this._workbook.Worksheets[sheet];
            int             frozenRowCount    = worksheet.FrozenRowCount;
            int             frozenColumnCount = worksheet.FrozenColumnCount;

            activeCell.X = worksheet.ActiveColumnIndex;
            activeCell.Y = worksheet.ActiveRowIndex;
            ExcelWorksheet.ExcelViewportInfo defaultViewport = worksheet.DefaultViewport;
            if (defaultViewport != null)
            {
                int rowPaneCount    = defaultViewport.RowPaneCount;
                int columnPaneCount = defaultViewport.ColumnPaneCount;
                if ((paneIndex != PaneType.TopLeft) && ((rowPaneCount > 2) || (columnPaneCount > 2)))
                {
                    return(false);
                }
                if (paneIndex == PaneType.BottomRight)
                {
                    if (((rowPaneCount <= 1) || (columnPaneCount <= 1)) && ((frozenRowCount <= 0) || (frozenColumnCount <= 0)))
                    {
                        return(false);
                    }
                }
                else if (paneIndex == PaneType.TopRight)
                {
                    if ((columnPaneCount <= 1) && (frozenColumnCount <= 0))
                    {
                        return(false);
                    }
                }
                else if (paneIndex == PaneType.BottomLeft)
                {
                    if ((rowPaneCount <= 1) && (frozenRowCount <= 0))
                    {
                        return(false);
                    }
                }
                else
                {
                    int num1 = (int)paneIndex;
                }
                if (selectionList != null)
                {
                    if ((worksheet.Selections != null) && (worksheet.Selections.Count > 0))
                    {
                        foreach (ISelectionRange range in worksheet.Selections)
                        {
                            if (range.activePaneType == paneIndex)
                            {
                                GcRect rect = new GcRect((range.Column > 0) ? ((double)range.Column) : ((double)0), (range.Row > 0) ? ((double)range.Row) : ((double)0), (range.ColumnSpan > 0) ? ((double)range.ColumnSpan) : ((double)0x4000), (range.RowSpan > 0) ? ((double)range.RowSpan) : ((double)0x100000));
                                selectionList.Add(rect);
                            }
                        }
                    }
                    else
                    {
                        selectionList.Add(new GcRect(activeCell.X, activeCell.Y, 1.0, 1.0));
                    }
                }
            }
            return(true);
        }
コード例 #3
0
        public void SetPane(short sheet, int x, int y, int rwTop, int columnLeft, int pnnAct, bool isPanesFrozen)
        {
            this._workbook.ActivePaneIndex = pnnAct;
            IExcelWorksheet worksheet = this._workbook.Worksheets[sheet];

            if (isPanesFrozen)
            {
                worksheet.FrozenColumnCount = x;
                worksheet.FrozenRowCount    = y;
            }
            else
            {
                int num  = 0;
                int num2 = 0;
                if (x > 0)
                {
                    double num3 = (Convert.ToDouble((int)x, (IFormatProvider)CultureInfo.InvariantCulture) * 96.0) / 1440.0;
                    num3 -= 34.0;
                    num   = Convert.ToInt32((double)num3, (IFormatProvider)CultureInfo.InvariantCulture);
                }
                if (y > 0)
                {
                    double num4 = (Convert.ToDouble((int)y, (IFormatProvider)CultureInfo.InvariantCulture) * 96.0) / 1440.0;
                    num4 -= 18.0;
                    num2  = Convert.ToInt32((double)num4, (IFormatProvider)CultureInfo.InvariantCulture);
                }
                ExcelWorksheet.ExcelViewportInfo defaultViewport = worksheet.DefaultViewport;
                switch (pnnAct)
                {
                case 0:
                    defaultViewport.ActiveColumnPane = 1;
                    defaultViewport.ActiveRowPane    = 1;
                    break;

                case 1:
                    defaultViewport.ActiveColumnPane = 1;
                    defaultViewport.ActiveRowPane    = 0;
                    break;

                case 2:
                    defaultViewport.ActiveColumnPane = 0;
                    defaultViewport.ActiveRowPane    = 1;
                    break;

                case 3:
                    defaultViewport.ActiveColumnPane = 0;
                    defaultViewport.ActiveRowPane    = 0;
                    break;
                }
                if (x > 0)
                {
                    defaultViewport.ColumnPaneCount++;
                    int[] numArray = new int[2];
                    numArray[1] = columnLeft;
                    defaultViewport.LeftColumn     = numArray;
                    defaultViewport.PreferredWidth = new int[] { num, -1 };
                }
                if (y > 0)
                {
                    defaultViewport.RowPaneCount++;
                    int[] numArray3 = new int[2];
                    numArray3[1]                    = rwTop;
                    defaultViewport.TopRow          = numArray3;
                    defaultViewport.PreferredHeight = new int[] { num2, -1 };
                }
            }
        }