spread自定义按钮触发过滤事件

收藏

问题：隐藏表单自带的过滤按钮，如何实现点击自定义按钮，弹出过滤弹框？？
（代码如下）

<html>
<head>
<meta charset="UTF-8" />
<link rel="stylesheet" type="text/css" href="https://cdn.grapecity.com.cn/spreadjs/css/gc.spread.sheets.12.0.6.css">
<script src="https://cdn.grapecity.com.cn/spreadjs/scripts/jquery-1.11.1.min.js" type="text/javascript"></script>
<script src="https://cdn.grapecity.com.cn/spreadjs/scripts/gc.spread.sheets.all.12.0.6.min.js" type="text/javascript"></script>
<script src="https://cdn.grapecity.com.cn/spreadjs/scripts/resources/zh/gc.spread.sheets.resources.zh.12.0.6.min.js" type="text/javascript"></script>
<style>
      .sample-tutorial {
         position: relative;
         height: 100%;
         overflow: hidden;
      }
</style>
</head>
<body>
<div id="ss" style="width:100%;height:500px;border:1px solid gray"></div>
<input type="button" id="btn" value="Click" />
<script>

$(document).ready(function () {
      var spread = new GC.Spread.Sheets.Workbook($("#ss").get(0));
      var sheet = spread.getActiveSheet();
      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不显示过滤弹框，且报错
      // sheet.rowFilter().filterButtonVisible(true);
      sheet.rowFilter().filterButtonVisible(false);
      spread.resumePaint();
      $("#btn").click(function () {
         // sheet.rowFilter().openFilterDialog();
         sheet.rowFilter().openFilterDialog(sheet.hitTest(97, 30).filterButtonHitInfo);
      })
});

</script>
</body>
</html>

Fiooona · Fiooona

本帖最后由 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方法传参做了一些修改，可以实现您的需求

		自动登录	找回密码
密码			立即注册

[已处理] spread自定义按钮触发过滤事件

1 个回复

微信认证勋章