Example #1
0
 public override void BringCellToVisible(CompositePosition position)
 {
     if ((!position.IsEmpty && (position.Type == DataSheetElementType.Cell)) && (_excel.ActiveSheet != null))
     {
         NavigatorHelper.BringCellToVisible(_excel, position.Row, position.Column);
     }
 }
Example #2
0
 public override void BringCellToVisible(TabularPosition position)
 {
     if ((!position.IsEmpty && (position.Area == SheetArea.Cells)) && (_excel.ActiveSheet != null))
     {
         NavigatorHelper.BringCellToVisible(_excel, position.Row, position.Column);
     }
 }
Example #3
0
 public override void ScrollToPreviousPageOfRows()
 {
     NavigatorHelper.ScrollToPreviousPageOfRows(_excel);
 }
Example #4
0
 public override void ScrollToNextPageOfRows()
 {
     NavigatorHelper.ScrollToNextPageOfRows(_excel);
 }
Example #5
0
        CellRange KeyboardThroughSelect(CellRange currentRange, NavigationDirection direction)
        {
            int       row         = (currentRange.Row < 0) ? 0 : currentRange.Row;
            int       column      = (currentRange.Column < 0) ? 0 : currentRange.Column;
            int       rowCount    = (currentRange.Row < 0) ? _excel.ActiveSheet.RowCount : currentRange.RowCount;
            int       columnCount = (currentRange.Column < 0) ? _excel.ActiveSheet.ColumnCount : currentRange.ColumnCount;
            CellRange activeCell  = GetActiveCell();
            CellRange range2      = null;

            if (direction == NavigationDirection.Home)
            {
                range2 = new CellRange(row, 0, rowCount, activeCell.Column + activeCell.ColumnCount);
            }
            else if (direction == NavigationDirection.End)
            {
                range2 = new CellRange(row, activeCell.Column, rowCount, _excel.ActiveSheet.ColumnCount - activeCell.Column);
            }
            else if (direction == NavigationDirection.Top)
            {
                range2 = new CellRange(0, column, activeCell.Row + activeCell.RowCount, columnCount);
            }
            else if (direction == NavigationDirection.Bottom)
            {
                range2 = new CellRange(activeCell.Row, column, _excel.ActiveSheet.RowCount - activeCell.Row, columnCount);
            }
            else if (direction == NavigationDirection.First)
            {
                range2 = new CellRange(_excel.ActiveSheet.FrozenRowCount, _excel.ActiveSheet.FrozenColumnCount, (activeCell.Row + activeCell.RowCount) - _excel.ActiveSheet.FrozenRowCount, (activeCell.Column + activeCell.ColumnCount) - _excel.ActiveSheet.FrozenColumnCount);
            }
            else if (direction == NavigationDirection.Last)
            {
                range2 = new CellRange(activeCell.Row, activeCell.Column, (_excel.ActiveSheet.RowCount - _excel.ActiveSheet.FrozenTrailingRowCount) - activeCell.Row, (_excel.ActiveSheet.ColumnCount - _excel.ActiveSheet.FrozenTrailingColumnCount) - activeCell.Column);
            }
            if (range2 != null)
            {
                int viewCellRow    = range2.Row;
                int num6           = (range2.Row + range2.RowCount) - 1;
                int viewCellColumn = range2.Column;
                int num8           = (range2.Column + range2.ColumnCount) - 1;
                if ((direction == NavigationDirection.Top) || (direction == NavigationDirection.First))
                {
                    NavigatorHelper.BringCellToVisible(_excel, viewCellRow, viewCellColumn);
                    return(range2);
                }
                if ((direction == NavigationDirection.Home) || (direction == NavigationDirection.End))
                {
                    int activeRowViewportIndex = _excel.GetActiveRowViewportIndex();
                    int viewportTopRow         = _excel.GetViewportTopRow(activeRowViewportIndex);
                    int viewportBottomRow      = _excel.GetViewportBottomRow(activeRowViewportIndex);
                    if (direction == NavigationDirection.Home)
                    {
                        if (num6 < viewportTopRow)
                        {
                            NavigatorHelper.BringCellToVisible(_excel, row, viewCellColumn);
                            return(range2);
                        }
                        if (viewCellRow > viewportBottomRow)
                        {
                            NavigatorHelper.BringCellToVisible(_excel, num6, viewCellColumn);
                            return(range2);
                        }
                        NavigatorHelper.BringCellToVisible(_excel, viewportTopRow, viewCellColumn);
                        return(range2);
                    }
                    if (num6 < viewportTopRow)
                    {
                        NavigatorHelper.BringCellToVisible(_excel, row, num8);
                        return(range2);
                    }
                    if (viewCellRow > viewportBottomRow)
                    {
                        NavigatorHelper.BringCellToVisible(_excel, num6, num8);
                        return(range2);
                    }
                    NavigatorHelper.BringCellToVisible(_excel, viewportTopRow, num8);
                    return(range2);
                }
                if ((direction == NavigationDirection.Bottom) || (direction == NavigationDirection.Last))
                {
                    NavigatorHelper.BringCellToVisible(_excel, num6, num8);
                }
            }
            return(range2);
        }
Example #6
0
        CellRange KeyboardPageSelect(CellRange currentRange, NavigationDirection direction)
        {
            int row                       = (currentRange.Row < 0) ? 0 : currentRange.Row;
            int rowCount                  = (currentRange.Row < 0) ? _excel.ActiveSheet.RowCount : currentRange.RowCount;
            int column                    = (currentRange.Column < 0) ? 0 : currentRange.Column;
            int columnCount               = (currentRange.Column < 0) ? _excel.ActiveSheet.ColumnCount : currentRange.ColumnCount;
            int num5                      = (row + rowCount) - 1;
            int num6                      = (column + columnCount) - 1;
            int activeRowViewportIndex    = _excel.GetActiveRowViewportIndex();
            int activeColumnViewportIndex = _excel.GetActiveColumnViewportIndex();
            int num9                      = _excel.ActiveSheet.RowCount;
            int num10                     = _excel.ActiveSheet.ColumnCount;
            int viewportTopRow            = _excel.GetViewportTopRow(activeRowViewportIndex);

            _excel.GetViewportBottomRow(activeRowViewportIndex);
            int viewportLeftColumn = _excel.GetViewportLeftColumn(activeColumnViewportIndex);

            _excel.GetViewportRightColumn(activeColumnViewportIndex);
            int       num13 = GetActiveCell().Row;
            int       num14 = GetActiveCell().Column;
            CellRange range = null;

            if (direction == NavigationDirection.PageDown)
            {
                NavigatorHelper.ScrollToNextPageOfRows(_excel);
                int num15             = _excel.GetViewportTopRow(activeRowViewportIndex);
                int viewportBottomRow = _excel.GetViewportBottomRow(activeRowViewportIndex);
                int num17             = num15 - viewportTopRow;
                if (num17 > 0)
                {
                    int num18 = num13;
                    int num19 = num5 + num17;
                    if (row != num13)
                    {
                        num18 = row + num17;
                        num19 = num5;
                        if (num18 >= num13)
                        {
                            num18 = num13;
                            num19 = num5 + (num17 - (num13 - row));
                        }
                    }
                    if (num19 < num15)
                    {
                        num19 = num15;
                    }
                    else if (num18 > viewportBottomRow)
                    {
                        num18 = viewportBottomRow;
                        num19 = num13;
                    }
                    else if ((num19 > viewportBottomRow) && (num13 <= viewportBottomRow))
                    {
                        num19 = viewportBottomRow;
                    }
                    return(new CellRange(num18, column, (num19 - num18) + 1, columnCount));
                }
                int num20 = (num9 - row) - rowCount;
                if ((num20 > 0) && (_excel.ActiveSheet.FrozenTrailingRowCount == 0))
                {
                    int num21 = num13;
                    int num22 = num9 - 1;
                    range = new CellRange(num21, column, (num22 - num21) + 1, columnCount);
                }
                return(range);
            }
            if (direction == NavigationDirection.PageUp)
            {
                NavigatorHelper.ScrollToPreviousPageOfRows(_excel);
                int num23 = _excel.GetViewportTopRow(activeRowViewportIndex);
                int num24 = _excel.GetViewportBottomRow(activeRowViewportIndex);
                int num25 = viewportTopRow - num23;
                if (num25 > 0)
                {
                    int num26 = row - num25;
                    int num27 = num5;
                    if (num5 != num13)
                    {
                        num26 = row;
                        num27 = num5 - num25;
                        if (num27 <= num13)
                        {
                            num26 = row - (num25 - (num5 - num13));
                            num27 = num13;
                        }
                    }
                    if (num27 < num23)
                    {
                        num26 = num13;
                        num27 = num23;
                    }
                    else if (num26 > num24)
                    {
                        num26 = num24;
                    }
                    else if ((num26 < num23) && (num13 >= num23))
                    {
                        num26 = num23;
                    }
                    return(new CellRange(num26, column, (num27 - num26) + 1, columnCount));
                }
                if ((row > 0) && (_excel.ActiveSheet.FrozenRowCount == 0))
                {
                    int num28 = 0;
                    int num29 = num13;
                    range = new CellRange(num28, column, (num29 - num28) + 1, columnCount);
                }
                return(range);
            }
            if (direction == NavigationDirection.PageRight)
            {
                NavigatorHelper.ScrollToNextPageOfColumns(_excel);
                int num30 = _excel.GetViewportLeftColumn(activeColumnViewportIndex);
                int viewportRightColumn = _excel.GetViewportRightColumn(activeColumnViewportIndex);
                int num32 = num30 - viewportLeftColumn;
                if (num32 > 0)
                {
                    int num33 = num14;
                    int num34 = num6 + num32;
                    if (column != num14)
                    {
                        num33 = column + num32;
                        num34 = num6;
                        if (num33 >= num14)
                        {
                            num33 = num14;
                            num34 = num6 + (num32 - (num14 - column));
                        }
                    }
                    if (num34 < num30)
                    {
                        num34 = num30;
                    }
                    else if (num33 > viewportRightColumn)
                    {
                        num33 = viewportRightColumn;
                        num34 = num14;
                    }
                    else if ((num34 > viewportRightColumn) && (num14 <= viewportRightColumn))
                    {
                        num34 = viewportRightColumn;
                    }
                    return(new CellRange(row, num33, rowCount, (num34 - num33) + 1));
                }
                int num35 = (num10 - column) - columnCount;
                if ((num35 > 0) && (_excel.ActiveSheet.FrozenTrailingColumnCount == 0))
                {
                    int num36 = num14;
                    int num37 = num10 - 1;
                    range = new CellRange(row, num36, rowCount, (num37 - num36) + 1);
                }
                return(range);
            }
            if (direction == NavigationDirection.PageLeft)
            {
                NavigatorHelper.ScrollToPreviousPageOfColumns(_excel);
                int num38 = _excel.GetViewportLeftColumn(activeColumnViewportIndex);
                int num39 = _excel.GetViewportRightColumn(activeColumnViewportIndex);
                int num40 = viewportLeftColumn - num38;
                if (num40 > 0)
                {
                    int num41 = column - num40;
                    int num42 = num6;
                    if (num6 != num14)
                    {
                        num41 = column;
                        num42 = num6 - num40;
                        if (num42 <= num14)
                        {
                            num41 = column - (num40 - (num6 - num14));
                            num42 = num14;
                        }
                    }
                    if (num42 < num38)
                    {
                        num41 = num14;
                        num42 = num38;
                    }
                    else if (num41 > num39)
                    {
                        num41 = num39;
                    }
                    else if ((num41 < num38) && (num14 >= num38))
                    {
                        num41 = num38;
                    }
                    return(new CellRange(row, num41, rowCount, (num42 - num41) + 1));
                }
                if ((column > 0) && (_excel.ActiveSheet.FrozenColumnCount == 0))
                {
                    int num43 = 0;
                    int num44 = num14;
                    range = new CellRange(row, num43, rowCount, (num44 - num43) + 1);
                }
            }
            return(range);
        }
Example #7
0
        CellRange KeyboardLineSelect(CellRange currentRange, NavigationDirection navigationDirection, bool shrink)
        {
            TabularPosition position;
            TabularPosition position2;
            TabularPosition currentCell;
            CellRange       expandIntersectedRange;
            int             row         = (currentRange.Row < 0) ? 0 : currentRange.Row;
            int             column      = (currentRange.Column < 0) ? 0 : currentRange.Column;
            int             rowCount    = (currentRange.Row < 0) ? _excel.ActiveSheet.RowCount : currentRange.RowCount;
            int             columnCount = (currentRange.Column < 0) ? _excel.ActiveSheet.ColumnCount : currentRange.ColumnCount;

            GetAdjustedEdge(row, column, rowCount, columnCount, navigationDirection, shrink, out position, out position2);
            if ((position == TabularPosition.Empty) || (position2 == TabularPosition.Empty))
            {
                return(null);
            }
            _keyboardNavigator.CurrentCell = position2;
            CellRange activeCell = GetActiveCell();

            do
            {
                if (!_keyboardNavigator.MoveCurrent(navigationDirection))
                {
                    return(null);
                }
                currentCell            = _keyboardNavigator.CurrentCell;
                expandIntersectedRange = GetExpandIntersectedRange(TabularPositionUnion(position, currentCell));
                if (!expandIntersectedRange.Contains(activeCell))
                {
                    return(null);
                }
            }while (expandIntersectedRange.Equals(row, column, rowCount, columnCount));
            bool flag                      = true;
            int  viewCellRow               = currentCell.Row;
            int  viewCellColumn            = currentCell.Column;
            int  activeRowViewportIndex    = _excel.GetActiveRowViewportIndex();
            int  activeColumnViewportIndex = _excel.GetActiveColumnViewportIndex();
            int  viewportTopRow            = _excel.GetViewportTopRow(activeRowViewportIndex);
            int  viewportBottomRow         = _excel.GetViewportBottomRow(activeRowViewportIndex);
            int  viewportLeftColumn        = _excel.GetViewportLeftColumn(activeColumnViewportIndex);
            int  viewportRightColumn       = _excel.GetViewportRightColumn(activeColumnViewportIndex);

            if ((navigationDirection == NavigationDirection.Up) || (navigationDirection == NavigationDirection.Down))
            {
                if ((expandIntersectedRange.Column == 0) && (expandIntersectedRange.ColumnCount == _excel.ActiveSheet.ColumnCount))
                {
                    if ((currentCell.Row >= viewportTopRow) && (currentCell.Row < viewportBottomRow))
                    {
                        flag = false;
                    }
                    else
                    {
                        viewCellColumn = viewportLeftColumn;
                    }
                }
            }
            else if (((navigationDirection == NavigationDirection.Left) || (navigationDirection == NavigationDirection.Right)) && ((expandIntersectedRange.Row == 0) && (expandIntersectedRange.RowCount == _excel.ActiveSheet.RowCount)))
            {
                if ((currentCell.Column >= viewportLeftColumn) && (currentCell.Column < viewportRightColumn))
                {
                    flag = false;
                }
                else
                {
                    viewCellRow = viewportTopRow;
                }
            }
            if (flag)
            {
                NavigatorHelper.BringCellToVisible(_excel, viewCellRow, viewCellColumn);
            }
            return(expandIntersectedRange);
        }