We have a boolean attribute that we show in a layout grid. In the browser it correctly says 'Ja' or 'Nee', depending on the value of the boolean. We use an action button to download the information from the page into a CSV file. In the microflow, the entities are retrieved and added to a file using java actions from the Simple CSV Exporter module. The resulting download shows the boolean values as 'true' or 'false'. MS Excel might show the values as 'true' and 'false' or as 'WAAR' and 'ONWAAR', depending on settings in Excel. But what we really want is 'Ja' and 'Nee', the same thing that is shown in the browser. Can this be done without changing the attribute from boolean to enum and without users having to access their Excel settings?
asked
Frederic Petrignani
1 answers
1
First solution I have in mind is to add an extra string attribute and fill that bases on the value of the boolean with 'Ja' or 'Nee' and use that attribute in your export to csv/excel