I would like to create an Excel report that includes TMG memo fields longer than 254 characters. Regardless of the column width I set in the Report Options, the Excel column contents are truncated, and when I return to the Report Options screen, the column width has been reset to 254. I am using TMG v. 8.08 and Windows 7. I use Excel 2013, but of course, the TMG output is to Excel v5.
I have no problem with truncated fields when creating spreadsheets directly in Excel 2013, so is this limit a TMG thing or an Excel v5 thing? If the former, are there any plans to increase the column width limit in the TMG report options? If the latter, are there any plans to add a later version of Excel - one that doesn't impose a 254 character limit to a cell - to the report output file list? In testing TMG v. 9, I noticed nothing different in this report.
The problem could be me, so is there some option I'm missing? Does anyone have an efficient work-around?
Thank you for your help.