Features

Filtering

Filtering

FlexSheet uses the FlexGridFilter extension to handle the filtering of each column.

Features

Filtering

FlexSheet uses the FlexGridFilter extension to handle the filtering of each column.
When the showColumnFilter() method of FlexSheet is invoked, it will display the filter UI of the selected column.

using Microsoft.AspNetCore.Mvc;

namespace FlexSheetExplorer.Controllers
{
    public partial class FlexSheetController : Controller
    {
        public ActionResult Filtering()
        {
            return View(SALES);
        }
    }
}
@model IEnumerable<Sale>

@section Scripts{<script type="text/javascript" src="~/Scripts/flexSheet/filtering.js"></script>}
<div>
    <div class="copy">
<h3>@Html.Raw(FlexSheetRes.Filtering_Text2)</h3>

<p>@Html.Raw(FlexSheetRes.Filtering_Text0)</p>

    </div>
    <button type="button" id="filterBtn" class="btn btn-default" onclick="showFilter()">@Html.Raw(FlexSheetRes.Filtering_Text3)</button>
    <div>
        <c1-flex-sheet class="flexSheet" id="filterSheet" selected-sheet-changed="sheetChanged">
            <c1-bound-sheet>
                <c1-items-source source-collection="@Model"></c1-items-source>
            </c1-bound-sheet>
        </c1-flex-sheet>
    </div>
</div>
@section Summary{
<p>@Html.Raw(FlexSheetRes.Filtering_Text1)</p>

}