在之前的版本,如果设置了底部冻结行,同时,表格中的数据行数比较少时,冻结行和数据行中间会有空白区域,在新版中,提供了一个选项开关来决定底部冻结行的位置,如下图所示:
#在现有版本中,如果数据行足够多,冻结行会在最下部显示
#在现有版本中,如果数据行比较少
#在即将发布的新版本中,通过选项开关,冻结行会显示在数据行的下方
API 如下:
- ///* function frozenTrailingRowCount(rowCount?: number, stickToEdge?: boolean): any
- /**
- * Gets or sets the number of trailing frozen rows of the sheet.
- * @param {number} [rowCount] The number of rows to freeze at the bottom of the sheet.
- * @param {boolean} [stickToEdge] Whether the frozenTrailingRow stick to the bottom edge of viewport area. By default is true.
- * @returns {number|GC.Spread.Sheets.Worksheet} If no value is set, returns the number of trailing frozen rows; otherwise, returns the worksheet.
- * @example
- * sheet.frozenTrailingRowCount(1, false);
- */
- frozenTrailingRowCount(rowCount ? : number, stickToEdge ? : boolean): any
- ///* function frozenTrailingColumnCount(colCount?: number, stickToEdge?: boolean): any
- /**
- * Gets or sets the number of trailing frozen columns of the sheet.
- * @param {number} [colCount] The number of columns to freeze at the right side of the sheet.
- * @param {boolean} [stickToEdge] Whether the frozenTrailingColumn stick to the right edge of viewport area. By default is true.
- * @returns {number|GC.Spread.Sheets.Worksheet} If no value is set, returns the number of trailing frozen columns; otherwise, returns the worksheet.
- * @example
- * sheet.frozenTrailingColumnCount(1, false);
- */
- frozenTrailingColumnCount(colCount ? : number, stickToEdge ? : boolean): any
复制代码
|
|