asked on January 28, 2021
Hi
When exporting to excel, if you have two or more rows they will appear in the same column with an indent to indicate the relationship between the data. This makes sense from a logic perspective. But we've had a request to show the rows as columns in excel. So that they are displayed similarly as they do in Flexmonster. Is this
possible?
Please see attached pictures for current, and desired display.
Best regards
Kim-Andre
⋅ January 28, 2021
Hello, Kim-Andre,
Thank you for reaching out to us.
We suggest checking out the classic form supported by Flexmonster.
It allocates a separate column for each expanded/drilled hierarchy, as the first screenshot demonstrates.
Please see the JSFiddle demonstrating the classic form. Try exporting the grid to Excel in order to make sure the structure is preserved.
The classic form can be configured in the Options Object:
options: {
grid: {
type: "classic"
}
}
Please let us know if it helps.
Feel free to contact us in case other questions arise.
Kind regards,