Hi,
We are not able to get the custom added/registered column values in exported excel file.
Here is the column definition
const columnDef: Partial<ColumnStoreConfig>[] | object[] = [
{type: 'activityidcolumn'},
{
type: 'name',
field: 'name',
text: 'Activity Name',
width: 350,
editor: false,
},
{ type: 'statuscolumn' },
{ type: 'date', field: 'startDate', text: 'Start Date', editor: false },
{ type: 'date', field: 'endDate', text: 'End Date', editor: false },
{ type: 'duration', field: 'duration', editor: false },
{
type: 'percentdone',
field: 'percentDone',
text: 'Progress',
editor: false,
},
{ field: 'critical', text: 'Is Critical', editor: false, hidden: true },
{
type : 'resourceassignment',
itemTpl : (assignment: { resourceName: string; }) => assignment.resourceName,
editor: false,
}
];
And here is how we have registered the status column -
StatusColumn.js
import { Column, ColumnStore } from '@bryntum/gantt'
export class StatusColumn extends Column {
static get $name() {
return 'StatusColumn'
}
static get type() {
return 'statuscolumn'
}
static get isGanttColumn() {
return true
}
static get defaults() {
return {
field: '_data.status',
text: 'Status',
editor: false,
cellCls: 'b-status-column-cell',
htmlEncode: false,
exportedType: 'string',
filterable: ({value, record}) => {
value = value.replace(/[.*+?^${}()|[\]\\]/g, '\\$&');
if(record._data.status?.match(new RegExp(value, 'i'))){
return record
}
}
}
}
}
Here is the excel snapshot
Here is the Gantt preview