Basic filter or Excel AutoFilter
Use a Basic filter or Autofilter to quickly find, filter and sort tabular data
To create a filter from your data,
Select a selection or focus on a cell which has some data around it
Press
Ctrl/Cmd + Shift + F
Or Right click on the cell and select
Create a filter
This will convert a selection to a filter

Wiring up autofilter using useSpreadsheetState
import {
SpreadsheetProvider,
CanvasGrid,
Sheet
} from "@rowsncolumns/spreadsheet";
import { useState } from "react";
import { useSpreadsheetState } from "@rowsncolumns/spreadsheet-state";
const MySpreadsheet = () => {
const [ sheets, onChangeSheets ] = useState<Sheet[]>([])
const { basicFilter, onCreateBasicFilter } = useSpreadsheetState({
sheets,
});
return (
<CanvasGrid
basicFilter={basicFilter}
onCreateBasicFilter={onCreateBasicFilter}
/>
);
};
const App = () => (
<SpreadsheetProvider>
<MySpreadsheet />
</SpreadsheetProvider>
);
Last updated
Was this helpful?