react-data-export icon indicating copy to clipboard operation
react-data-export copied to clipboard

How use formula in dataSat

Open mbohovic opened this issue 6 years ago • 0 comments

My dataset is

dataSet =  [{
                columns: [
                    {title: "A", style: {font: {bold: true}}, width: {wpx: 200}}, // pixels width
                    {title: "B", style: {font: {bold: true}}, width: {wch: 10}}, // char width
                    {title: "C", style: {font: {bold: true}}, width: {wpx: 90}},
                ],
                data: this.props.sourceData.reduce((acc, item) => {
                    acc.push([
                        {value: item.A},
                        {value: item.B},
                        {value: =SUM(item.A;item.B)},
                    ])
                    return acc
                }, [])
            }]
...
<ExcelSheet dataSet={dataSet)} />

How set =SUM(itemA;itemB) ??

Thanks

mbohovic avatar Jun 04 '19 09:06 mbohovic