Localisation
Add text in any language in the Spreadsheet
CanvasGrid renders what you pass it as a formattedValue of CellData object.
Date format
If you are using useSpreadsheetState for state management of Spreadsheet, you can pass in a locale prop to cater for date format in different regions
Locale is auto-detected from Intl JavaScript object if its not provided
import { useSpreadsheetState } from "@rowsncolumns/spreadsheet-state"
const Spreadsheet = () => {
const { } = useSpreadsheetState({
locale: 'en-US'
})
}
export const App = () => {
<SpreadsheetProvider>
<Spreadsheet />
<SpreadsheetProvider>
}Last updated
Was this helpful?