AlexZ 发表于 2021-3-2 15:53:30

【V14 Update1 新功能预览】底部冻结行增强

在之前的版本,如果设置了底部冻结行,同时,表格中的数据行数比较少时,冻结行和数据行中间会有空白区域,在新版中,提供了一个选项开关来决定底部冻结行的位置,如下图所示:

#在现有版本中,如果数据行足够多,冻结行会在最下部显示


#在现有版本中,如果数据行比较少


#在即将发布的新版本中,通过选项开关,冻结行会显示在数据行的下方


API 如下:
///* function frozenTrailingRowCount(rowCount?: number, stickToEdge?: boolean): any
/**
* Gets or sets the number of trailing frozen rows of the sheet.
* @param {number} The number of rows to freeze at the bottom of the sheet.
* @param {boolean} 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} The number of columns to freeze at the right side of the sheet.
* @param {boolean} 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

页: [1]
查看完整版本: 【V14 Update1 新功能预览】底部冻结行增强