您好,请问您是不是将那些单元格设置为了文本单元格呢?我这边试了一下是可以实现的,如下图所示:
参考代码:
- window.onload = function () {
- var spread = new GC.Spread.Sheets.Workbook(
- document.getElementById("spread-container"),
- { sheetCount: 1 }
- );
- var sheet = spread.getActiveSheet();
- sheet.setRowCount(200);
- sheet.setColumnCount(50);
- // sheet.getCell(0, 0).text("Hello World");
- sheet.setValue(0, 0, new Date(2013, 3, 1));
- sheet.setFormatter(0, 0, "yyyy-mm-dd");
- var range = new GC.Spread.Sheets.Range(-1, 0, -1, 1);
- var rowFilter = new GC.Spread.Sheets.Filter.HideRowFilter(range);
- sheet.rowFilter(rowFilter);
- };
复制代码 |