Our blazing fast Grid component built with pure JavaScript


Post by tegus-engineering »

Hello,

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)
 }

Thank you,


Post by tasnim »

Yes. You could achieve it. The way you showed in the above code, it looks correct. The column should be available. Is it not working?


Post by tegus-engineering »

Hi!

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.


Post by alex.l »

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.

All the best,
Alex


Post by tegus-engineering »

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>
Attachments
excel0.png
excel0.png (26.44 KiB) Viewed 294 times
excel1.png
excel1.png (59.99 KiB) Viewed 294 times

Post by mats »

Can you please share your code so we can try to reproduce this, it sounds like a bug somewhere.


Post Reply