I'm trying to do a custom export to Excel whereby I can customise the column headings and not use the standard FileMaker field names, as well as including a total summary row at the end. To do this I've created a reporting table that I populate with the required records, including a total record at the end and the first record contains the column headings.
When I export these records to Excel I've got 2 issues that I can't seem to work around:
1. the FileMaker field names are still included on the first row of the Export
2. I have some fields as numbers as they contain currency values and I want these recognised as number cells in Excel so the users can perform further calculations on them in Excel, but the custom column heading in the first reow shows up as "0" instead of "Price ex Tax" etc, presumably as I'm trying to include a text value in a number field.
Anyone have any suggestions for possible ways to get around this?