本帖最后由 Fiooona 于 2020-7-22 14:06 编辑
- spread.suspendPaint();
- for (var i = 0; i < 10; i++) {
- sheet.setValue(i, 0, i);
- }
- sheet.rowFilter(new GC.Spread.Sheets.Filter.HideRowFilter(new GC.Spread.Sheets.Range(1, 0, 10, 1)));
-
- //显示自带过滤按钮时,点击button弹出过滤弹框,但自带过滤按钮不显示,点击button不显示过滤弹框,且报错
- // var rowFilter= sheet.rowFilter().filterButtonVisible(true);
- var rowFilter= sheet.rowFilter().filterButtonVisible(false);
- spread.resumePaint();
- $("#btn").click(function () {
- // sheet.rowFilter().openFilterDialog();
- var row = 0, col = 0;
- sheet.getCellRect(row, col);
- //Rect {x: 412, y: 60, width: 62, height: 20}
- var celRect = sheet.getCellRect(row, col);
- var filterInfo = {
- "rowFilter": rowFilter,
- "row": row,
- "col": col,
- "sheetArea": 3,
- "x": celRect.x + celRect.width - 20,
- "y": celRect.y,
- "width": 20,
- "height": 20
- }
- rowFilter.openFilterDialog(filterInfo)
- // sheet.rowFilter().openFilterDialog(sheet.hitTest(97, 30).filterButtonHitInfo);
-
- })
复制代码 给 openFilterDialog方法传参做了一些修改,可以实现您的需求 |