使用指南
鼠标功能
- 点击单元格 获取单元格焦点和编辑它.
- 右键单击单元格 显示弹出菜单
- 鼠标滚轮 表格内容上下滚动.
- Dragging by right mouse button scrolls grid section under mouse cursor in the move direction(s)
- 点击选择或反选行记录
- 点击顶部的 选择或反选所有行记录
- Ctrl + 点击顶部的 反向选择所有行记录
- 拖动连续选择行记录
- Ctrl + 拖动单元格 连续选择多行或反向选择多行记录
- Ctrl + 点击 选择单行或反向选择单行记录
- Shift + 点击 连续选择多行或反向选择多行记录
- 点击 删除或取消删除行记录
- 点击顶部的 删除或取消删除所有行记录
- 点击 增行、复行或复制已经选择的行记录
- Dragging 移动行到新位置,tmoves row to new position, always moves single row, not selected rows
- Draggingby right mouse button copies row to new position, always moves single row, not selected rows
- Ctrl + Draggingby right mouse button copies row and its children to new position, always moves single row, not selected rows
- 拖动单元格 移动行记录到新位置(根据树图标指示) :
不能放到到这个位置,
放到此行上面,
放到此行下面,
作为此行的子节点.
如果拖动选定的行,则所选中的行一起拖到新的位置,但前提是他们都是同一类型的(同一节点)。
你可以在多格表格之间拖动,甚至你可以拖动主-从结构的行记录,可以将明细表格中的行记录拖到另一个主表格的明细行中去。
当鼠标拖动时,下面的功能是有效的:
- 当鼠标上方显示图标时,该拖动行作为它的子行出现.
- 当鼠标向上拖动时,表格自动向下滚动,你也可以使用鼠标滚轮滚动表格内容.
- 当鼠标移到上面一页时,表格会自动切换到鼠标所在页面.
- 点击表格过滤器 显示过滤器条件菜单,如:等于、大于、小于等
- 点击表格过滤器 允许或停用过滤功能
- 点击表格过滤器 表示允许勾选,
显示 表示已选中,显示
时表示未选中
- 点击表格标题 此列将升序排序,再点一次则降序排序 .
排序的方向和顺序由图标指示:未排序,
首列升序 ,
首列降序,
第二列 ,
第三列.
- Ctrl + 点击多个标题 自动将这些列按点击先后顺序排序.
- 拖动列头的边缘 改变列的宽度,拖动表格右侧边缘改变表格大小.
- 拖动列头的标题 将此列移到新的位置显示.
拖动列到新位置时,该位置由蓝色箭头和红色箭头标示.
- 拖动列到复合标题列时 将合并该列为复合标题组.
拖动列到复合标题列一组时,将自动合并为复合标题.
拖动列到复合标题组之外时,将解除复合标题,使之变成单行列标题.
- Dragging separator between horizontal sections (left/middle and middle/right) resizes / shrinks the column sections
- 点击 显示日历拾取器,可以改变编辑框中的日期值
- 点击 显示下拉列表值
- 点击 展开行子节点
- 点击 收起行子节点
- 点击列头 展开列子点节点
- 点击列头 收起列子节点
- 在第一个单元按住Shift键往其它单格拖动时,第一个单元格的值将复制到其它已经被选中的单元格中
甘特图的鼠标功能
- Dragging bar edge resizes the bar. Resizing the bar to zero width deletes the bar.
- Dragging bar or icon moves the item inside the cell
- Only the Run bars or flag icons can be moved to another row or grid, this behavior is not set by default, but can be done by any mouse dragging action.
- Dragging from bar or milestone icon outside the row to another bar or milestone icon creates new dependency between the items.
- Dragging on empty space creates new bar.
- Right button Dragging selects Run boxes inside rectangle.
- Ctrl + Click to bar or icon or dependency end deletes the item
- Double Click to bar or item or dependency end changes the item, e.g. lets enter text of the bar, lets assign resources, lets enter dependency lag etc. Or it can select Run box.
- Double Click to empty space creates new icon at the point
- Ctrl + Right Click to bar changes percentage completion to the selected point
- Shift + Right Click to bar lets enter the percentage completion
- Right Click to cell shows popup menu with all action items related to Gantt item under mouse cursor
- Dragging Gantt header zooms to selected date range
- Click to Gantt header zooms to selected date
- Right Click to Gantt header unzooms back to previous zoom level or zooms out
触摸屏功能(尤其是苹果iPad平板电脑和Android平板电脑)
- 触摸板支持所有标准的鼠标功能,除了鼠标右键、控制键Ctrl和Shift键。
- 滚动条行为类似于标准的浏览器滚动条。
拖动滑块滚动更简单,
触摸箭头滚动相对较慢,
触摸滑块相对于箭头更快些.
滚动条大小 可以用户配置菜单中选择.
- Dragging not focused cell by one finger scrolls tablet surface as standard iPad feature. Or scrolls grid horizontally and tablet vertically.
- Tap to cell focuses the cell.
- Dragging focused cell by one finger moves the row to another position or selects or fills the cell values.
- Tap to focused cell starts editing the cell.
- Finish editing - editing finishes by tapping enter on keyboard or tapping outside the cell.
There is no escape, you can cancel the changes by tapping Undo on keyboard or accept the changes and click to TreeGrid Undo button .
- Tapping focused cell by two fingers shows popup menu for the cell, if defined. Tap by one finger while the second finger is touching pad.
- Dragging cell by two fingers zooms page as standard iPad feature.
- Draggingby one finger moves row to new position like dragging by mouse
- Draggingby two fingers copies row like dragging by mouse right button
- Draggingby three fingers copies row and its children like dragging by mouse right button with ctrl
- Draggingby one finger inverts selection in continuous range of rows like dragging by mouse
- Dragging header by one finger behaves like by mouse, resizes column by dragging edge, moves or groups column by dragging body. Including pager header.
- Dragging separator between horizontal sections by one finger (left/middle and middle/right) resizes / shrinks the column sections
Touch screen functions in Gantt chart (especially for Apple iPad tablets and Android tablets)
- On touch screen there should be editing menu or toolbar to choose which bars and editing actions will be permitted, to simplify editing.
- Tap to bar, icon or dependency focuses the item. It also focused the Gantt cell.
- Tap to empty space or inactive item focuses the Gantt cell.
- Tap to focused bar, icon or depencency shows popup menu to choose the action to do.
- Tap to empty space in focused cell shows popup menu to choose the action to do.
- Dragging focused bar edge resizes the bar.
- Dragging focused bar or icon moves the item. If the item cannot be moved and supports dependencies, it creates new dependency.
- Dragging empty space in focused celll creates new bar.
- Dragging Gantt header by one finger zooms to selected date range
- Tap to Gantt header by one finger shows popup menu to choose the action to do.
Control keys
- Arrow keys 光标在单元格中移动
- Tab 将光标移至下一个单元格
- Shift + Tab 将光标移至上一个单元格
- Tab 在编辑模式将光标移至下一个可编辑的单元格
- Shift + Tab 在编辑模式将光标移至上一个可编辑的单元格
- 任何字符键 开始编辑光标所在的单元格
- 回车键 or F2 开始编辑光标所在的单元格
- 回车键 在编辑模式下确认所做的修改
- Alt + 回车键 在编辑模式下确认所做的修改
- Ctrl + 回车键 在编辑模式下确认所做的修改
- Esc 在编辑模式下取消所做的修改
- 空格键 选择或反选行记录
- Ctrl + 空格键 选择或反选所有行记录
- Del 删除或反删除行记录
- Ctrl + Del 删除或反删除选择的行记录
- Ins 在当前光标位置前插入入新的空白行
- Ctrl + Ins 给当前行记录插入子节点空白行
- Shift + Ins 从上一行复制到新行
- Shift + Ctrl + Ins 从子节点的上一行开始复制到新行
- Ctrl + 回车键 展开/收起节点
- Home 光标移至第一行
- End 光标移至最后一行
- Page Up 向上翻一页
- Page Down 向下翻一页
- Ctrl + 回车键 非编辑模式下展开/收起子节点
- Ctrl + Z 撤销最后修改的数据
- Ctrl + Y 重做被撤销的数据
- Ctrl + 下光标键 显示缺省的下拉列表或日期拾取器(当前单元格已经定义这类控件的情况下)
复制 & 粘贴
- Ctrl + C 将所选定的行记录值复制到剪贴板,如果没选定行记录,则仅复制当前行。
如果在非编辑模式下,数据是明文,单元格的值是被Tab键分隔,行与行记录之间被“回车键”(CR or LF)分隔。
这些数据可以粘贴到表格中、任何文本编辑器软件、或MS Excel sheet表格中(不支持Opera浏览器)。
- Ctrl + V将剪贴板的值粘贴到所选定的行记录中去,如果没有选定行记录,则仅复制到当前行。
如果在非编辑模式下, 单元格中的数据是被Tab键分隔的,行与行记录之间被“回车键”(CR or LF)分隔,只能修改可编辑的单元格。
如果粘贴的数据个数小于表格的列数,仅将粘贴的值填充到表格中实际存在的列数,否则从表格第一列开始填充(不支持Opera浏览器)。
工具条
这些按钮仅在有权限时才会显示,所列示的按钮也可能显示在一个或更多的行记录中。
-
保存数据 将所修改的数据提交到服务器,并由服务器验证数据合法性,如果验证通过,则保存成功,否则提示保存失败的错误信息。
-
重载数据 重新从服务器加载数据至页面中。
-
渲染所有页面 或关闭渲染所有页面
-
打印表格内容 打开新的浏览器窗口并打印表格的内容。
-
导出所有数据到PDF文件
-
导出所有数据 到电子表格
-
撤销 最后修改的数据
-
重做 最后撤销的数据
-
增行 到光标所在行记录(如果父节点允许增加子节点)。
或如果选中了行,则菜单显示你可以移动、复制行或忽略所选中的行记录而新增行。
-
增行 作为当前光标所有行的子节点(如果当前行允许增加子节点).
或如果选中了行,则菜单显示你可以移动、复制行或忽略所选中的行记录而新增行。
-
合并单元格 将所有选定的单元格合并(连接)在一起
-
拆分单元格 将合并(连接)在一起的单元格拆分出来。
-
升级节点 将当前节点提升一级,使之与父节点平级
-
降级节点 将当前节点降一级,使之放到子节点的最后一级。
-
Enables or disables sorting. When enabling sorting, re-sorts grid according to actual sorting.
You can disable sorting, if you need to choose new sorting according to more columns to avoid multiple re-sorting, especially in paged grids.
-
Enables or disables calculations. When enabling calculations, re-calculates all cells.
You can disable calculations when editing large grids.
-
Expands all rows.
For large grids expands only some rows to avoid locking browser. Starts expanding from focused row.
-
Collapses all rows.
-
Corrects all dependency errors in Gantt chart.
-
Zooms in Gantt chart.
-
Zooms out Gantt chart.
-
Zooms to fit to window size the Gantt chart.
-
Goes to the first page
-
Goes to the previous page
-
Goes to the next page
-
Goes to the last page
-
Displays menu to choose which columns will be displayed.
-
Displays TreeGrid configuration window.
These settings are saved to client cookies and therefore are persistent. See Configuration description below.
-
Displays this help
-
Displays debug window
-
You can resize grid by mouse dragging this icon on the right bottom corner. By double click you can restore to original size.
Configuration
The item is shown only if the grid permits the action.
- Show deleted rows (in red).
If checked, deleted rows are still visible and colored and can be undeleted. If you check Auto updates, this option have no sense.
- Reversed tree (like in MS Excel).
If checked, parent row's children are shown above the parent row instead of below.
- Auto sort rows after change.
If checked, after user modify value in column according to is grid sorted, row is sorted and moved to the new position
- Sort click. How sorting can be set by clicking to column caption.
- Auto update changes to server.
If checked, all modifications (value changing, rows moving, adding, deleting) are immediately uploaded to server.
Does not wait for server response, grid is still accessible. After server response clears changed flags.
If it is not checked, updates can be send by submit button.
- Check for updates on server. How often the grid checks new data on server when used synchronization with server.
- Scrollbars type. Scrollbars size (none, thin, standard, wide), especially for touch screens (iPad).
- Scroll by. The way of scrolling by dragging content at touch screen (iPad). (none, by one finger, two fingers, three fingers).
- Mouse hover. What blinks under mouse cursor. Hovering all cells can slow down browser responses.
- Show dragged object. If checked, dragging rows or moving columns are attached to the mouse cursor.
- Show row's left panel. If it is not checked, the left panel
is hidden and its functions can be performed by keys only.
- Show pager. If checked, the pager with page names is visible on the right of the grid.
- Show all pages. If checked, all pages are visible at once and can be accessed by sliding scrollbar or moving cursor.
The page is rendered only when is scrolled to the window.
If it is not checked, only one page is visible at a time and other pages can be accessed by clicking on pager or by PgUp and PgUp keys.
Configuration items for Gantt chart
The item is shown only if the grid permits the action.
- Circular dependencies. If creating circular dependencies is permitted, like A -> B -> C -> A.
- Starting tasks on holidays. If permitted to start tasks on excluded dates. Just "visual" setting, all calculations in chart are always done only in non excluded dates.
- Incorrect manual inputs. How the changes done in Gantt source cells are handled, if violate the Gantt constraints and other restrictions.
- Schedule tasks. If the tasks are scheduled automatically or manually after any change in Gantt chart.
- Schedule tasks from. Scheduling direction, from project start or finish.
- Schedule tasks method. How much the tasks are moved to satisfy their dependencies and constraints.
- Auto schedule also the changed task. For "on" it can move also the tasks, its change invoked the correcting dependencies. For "off" this task is never moved.
- Schedule also already started tasks. For "off" it never moves tasks with percentage complete > 0. For "on" it ignores percentage completion when correcting dependencies.
- Show holidays in chart. For "off" all the excluded dates are removed from display.
- Can move objects before project start. If Gantt bars and icons can be moved by a user to start before project start
- Can move objects after project finish. If Gantt bars and icons can be moved by a user to end after project finish
- Project start is preferred to constraints. What is preferred when correcting dependencies and there is no room for the task due constraint and project start violation.
- Project finish is preferred to constraints. What is preferred when correcting dependencies and there is no room for the task due constraint and project finish violation.
- Minimal slack for critical task. If tasks's slack is less than or equal to this value, the task is marked as critical. Slack means, how much can be the task moved right (to be late) to not affect the project finish.
- Minimal slack bound for error task. If tasks's slack is less than this value, the task is marked as error task. It means it should be moved left to correct the project finish violation.
- Calculate critical path individually. For "on" the project finish is calculated for every independent group of tasks. For "off" there will be only one global project finish.
Filter row
- Filter row is special row, usually displayed on the top, under header.
There can be set filter conditions for every column.
If other rows has in this column value which satisfies the filter condition, the row is displayed, otherwise is hidden.
- Filtered can be only variable rows. Some rows can be marked as always visible.
These are often rows with children rows in tree to filter only some levels.
- A cell in filter row contains filter operator and its parameter value.
Some operators are used for some column types only. Filtering is fired after operator or value changes.
- You can select filter operator from menu.
By default filter is disabled:.
Group row
- Group row is special row, usually displayed on the top, under header and fixed rows.
You can group rows to tree according same values in appropriate column(s).
- Grouped can be only variable rows. Some rows can be marked that cannot be grouped.
In tree there will be only one level of rows to be grouped.
- You can select predefined grouping from select box.
- Or you can drag column caption to the group row to be grouped by this column. If some column(s) are placed there already,
you can put the new column to appropriate place. To remove column from grouping, just drag its caption from group row outside.
Search row
- Search row is special row, usually displayed on the top, under header and fixed rows.
- You can search rows or cells in grid for simple string like Google or by complex formula.
- The found rows can be filtered, selected, colored or focused.
- Or you can select predefined search formulas from select box.
- There are many settings to more specify the searching options.
Other
- If you move focus to another cell in edit mode, the changed value is accepted as if you pressed Enter.
- After confirm new value after edit, calculated cells are recalculated.
If Auto sort is set and sorting is enabled by this column, row is moved to another position by sort order.
If Auto update is set, value is submitted to server.
Colors
- - Deleted row
- - Added row
- - Moved row - row has been moved to another parent
- - Changed row - any cell value has been changed
- - Changed cell
- - Selected row
- - Focused row
- - Focused cell
- - Focused cell in edit mode
- - Focused cell in read only edit mode
- - Cell cannot be focused
- - Read only cell
- - Master row in master / detail relationship
- - Master row displayed in detail table
- - Child page
- - Row under mouse cursor
- - Cell under mouse cursor
More info