Renderer for Check Column not called when exporting

[matsbryntse]

Forum post

I am using the Gantt though not sure if this is just a grid thing. If I try to use renderer with a check column it never gets called during export. It exports out a checkbox in excel and I want some text instead. Is there a way to get this to happen?

[ExtAnimal]

Probably the exporter class could be configured with its own renderers for columns which need special treatment only for exporting.

Rather than use the column's renderer, if it has its own renderer registered for a column use that.

That would save implementing if/else renderers in columns which would have to know who's doing the rendering.

[FlowIT-JIT]

The column renderers seems to be called only for name, duration, and our read only columns when exporting to Excel. Our renderer is not called for the wbs column, not for our date columns, and not for our checkbox columns. This unfortunately prevents us from using this feature.

@matsbryntse Are you able to prioritize and plan a fix for a patch release in the near future ? I'm fine with the use of args.isExport in the renderer to distinguish between HTML rendering and Excel rendering. - Thanks

EDIT: Renderer was not registered on the wbs column, so ignore that statement.

[matsbryntse]

We'll have a look. WBSColumn seems to work fine for me. What version are you on?

[matsbryntse]

For date columns to have your renderer be called, please configure your Export feature with:
exportDateAsInstance : false

[FlowIT-JIT]

@matsbryntse
How do we use this with the Excel Exporter feature? TypeScript definitions have not been updated it seems, so not much help there. I have tried the following approach using https://bryntum.com/products/gantt/examples/exporttoexcel/

The renderer is registered for wbs, name, and startDate, and gets called for all three columns when rendering to the screen. But when exporting, the renderer is only called for wbs and name.

[matsbryntse]

Like so:

features : {
       excelExporter : {
         exporterConfig : {
               exportDateAsInstance : false
}

       }
   },

[FlowIT-JIT]

Thanks, @matsbryntse 😊