Is there plans to allow renderer to be used properly on Table Exporter?
Currently, we're exporting numbers as it is (see below), but it would be nice to be able to also use column in renderer with our custom function without just doing if (isExport) return value.
renderer: ({ value, column, isExport }) => {
if (isExport) return value
return formatValue(value, column.format, isExport)
}
What I meant is that the export works with if (isExport) return value line, but Excel displays errors if I try exporting with format by removing the line.
Hi,
So what's your request? renderer returns a text that will be rendered into a cell. If that text cannot be recognized by Excel as a number, try to use format that Excel will be able to recognize.
The problem is with Excel complaining about the export when it has cell formats. It has to be repaired every time.
<repairedRecords summary="Following is a list of repairs:"><repairedRecord>Repaired Records: Cell information from /xl/worksheets/sheet1.xml part</repairedRecord></repairedRecords>