List of autoFilter() Examples

Examples of autoFilter()

org.zkoss.zss.model.Range.autoFilter()

Filters a list specified by this Range and returns an AutoFilter object. @param field offset of the field on which you want to base the filter on (1-based; i.e. leftmost column in this range is field 1). @param criteria1 "=" to find blank fields, "<>" to find non-blank fields. If null, means ALL. If filterOp == AutoFilter#FILTEROP_TOP10, then this shall specifies the number of items (e.g. "10"). @param filterOp see Range#FILTEROP_xxx. Use FILTEROP_AND and FILTEROP_OR with criteria1 and criterial2 to construct compound criteria. @param criteria2 2nd criteria; used with criteria1 and filterOP to construct compound criteria. @param visibleDropDown true to show the autoFilter drop-down arrow for the filtered field; false to hide the autoFilter drop-down arrow; nullto keep as is. @return the applied AutoFiltering

    final String cellRangeAddr = (String) data.get("range");
    final int field = (Integer) data.get("field");
    final Range range = Ranges.range(worksheet, cellRangeAddr);
    
    if (selectAll) {
      range.autoFilter(field, null, AutoFilter.FILTEROP_VALUES, null, null);
    } else { //partial selection
      JSONArray ary = (JSONArray) data.get("criteria");
      range.autoFilter(field, ary.toArray(new String[ary.size()]), AutoFilter.FILTEROP_VALUES, null, null);
    }
  }

    
    if (selectAll) {
      range.autoFilter(field, null, AutoFilter.FILTEROP_VALUES, null, null);
    } else { //partial selection
      JSONArray ary = (JSONArray) data.get("criteria");
      range.autoFilter(field, ary.toArray(new String[ary.size()]), AutoFilter.FILTEROP_VALUES, null, null);
    }
  }
}

        switch (selection.getSelectionType()) {
        case Rect.SELECT_ROW:
          range.getRows().autoFilter();
          break;
        default:
          range.autoFilter();
          break;
        }
        
        clearClipboard();  
      } else {

    int top = selection.getTop();
    int btm = selection.getBottom();
    
    Range rng = Utils.getRange(sheet, top, left, btm, right);
        
    rng.autoFilter();
  }
  
  /**
   * Sort in selection range
   * @param sheet the sheet to sort

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.

Examples of autoFilter()

Examples of org.zkoss.zss.model.Range.autoFilter()

Examples of org.zkoss.zss.model.Range.autoFilter()

Examples of org.zkoss.zss.model.Range.autoFilter()

Examples of org.zkoss.zss.model.Range.autoFilter()