Data Formatting

Data formatting using ECMA-376 spreadsheet format codes is supported using SSF


Example

DataFormatFormatted value
12$#.00$12.00
890123#,##0.000890,123.00
650.0%65.0%
new Date()dd mm yyyy03 07 2020
import SpreadSheet from '@rowsncolumns/spreadsheet'
const initialSheets = [
{
name: 'Sheet 1',
id: 0,
cells: {
1: {
1: {
text: 100,
datatype: 'number',
format: '#.00'
}
}
}
}
]
<SpreadSheet
initialSheets={initialSheets}
/>

Demo

fx

Sheet 1