Multi-Language and Field Names for Export
We have the need for multiple languages, and our field names are in EN.
When we export data to excel, we would like to have local language field names.
The only option I could find would be to have a plain text field table, with all the same fields and insert the first record as column names, add the data, then export as excel without field names.
Issue is any numeric data appears in excel with markers for the user to tell it what the data type is. If I use a numeric field but add text anyway to the first record, the export sends only numeric data to excel.
Any ideas how I can go about this?