We have created a report template on similar lines as Generic Reports 2.template.xls provided in the samples - except the formatting part. In the sample file the formatting for date is applied based on the column name - but in our case since the report template is used across different datasets we cannot have condition based formatting i.e the <#if(<#columns.name>="OrderDate";<#format cell(longdate)>;)> is not possible.
When we generate the report now it displays date as numbers (and the excel column type is general). Is there a way to get the column type so we can apply the format conditions? Or is there any other method we can use to get the date format working.
The same is the case for currency (but less critical).