Links
Comment on page

Named ranges

Name ranges and use it in formulas
Pass namedRanges object to SheetGrid, so that it can suggest named ranges when user enters a formula
import {
SpreadsheetProvider,
CanvasGrid,
NamedRange,
} from "@rowsncolumns/spreadsheet";
import { useState } from "react";
import { useSpreadsheetState } from "@rowsncolumns/spreadsheet-state";
const MySpreadsheet = () => {
const [namedRanges, onChangeNamedRanges] = useState<NamedRange[]>([]);
// Removed for brevity
const {...} = useSpreadsheetState({
namedRanges,
});
return <CanvasGrid namedRanges={namedRanges} />;
};
const App = () => (
<SpreadsheetProvider>
<MySpreadsheet />
</SpreadsheetProvider>
);
Currently, there is no UI to add/edit named ranges