Excel Exporter make the data rows have text format
0
hi everyone, i want to ask for how to make the all data rows with using excel exporter is having "text" format. its because the data that i want to show is possible to have "0" in the front of the data. Its okay when user export the file in the beginning, but when they edit the data, its possible that the "0" is dissapear because excel think its a decimal/number format
asked
Yohanes Yohanes
2 answers
1
Maybe use a template file with the correct format set? This does work for styling, so would assume this also works for formatting.
answered
Johan Flikweert
1
Please try a different way of exporting via updating the data widgets module and using the javascript action to export to excel from a data grid 2 widget.