Comment on page
Calculate on-demand
Trigger a full recalc whenever you need it.
If you are uploading an excel file or replacing the state of the spreadsheet, you will have to manually trigger a full recalc.
To do so,
useSpreadsheetState
exposes calculateNow
function.import {
SpreadsheetProvider,
CanvasGrid,
} from "@rowsncolumns/spreadsheet";
import { useSpreadsheetState } from "@rowsncolumns/spreadsheet-state";
const MySpreadsheet = () => {
const { calculateNow } = useSpreadsheetState({
...
});
return (
<div>
<input type="file" onChange={() => {
// Update sheets
// update sheet Data
// Update table
calculateNow()
})
<CanvasGrid />
</div>
);
};
const App = () => (
<SpreadsheetProvider>
<MySpreadsheet />
</SpreadsheetProvider>
);
Last modified 6mo ago