Formula protection

Add extra layer of protection to prevent users from copying formulas

Enabling formula protection mode prevents users from viewing, copying or editing formulas on the Spreadsheet

This is useful if you want to share a Spreadsheet with the team, but not give them access to formulas due to confidential reasons

To enable protection mode, set protectFormulas={true}

import { SpreadsheetProvider, CanvasGrid } from "@rowsncolumns/spreadsheet";
import { useSpreadsheetState } from "@rowsncolumns/spreadsheet-state";

const MySpreadsheet = () => {
  const { getCellData } = useSpreadsheetState()

  
  return (
    <CanvasGrid
      protectFormulas={true}
    />
  );
};

const App = () => (
  <SpreadsheetProvider>
    <MySpreadsheet />
  </SpreadsheetProvider>
);