Excel auto-formatting is disabled, how to enable?

[dtrobert]

 Hi,

 A while back we encountered problems with XLS output where long numbers (phone numbers) would be converted into sci-fi notation so we disabled the auto-formatting of all reports.  

 

However, now we see that it has a negative impact when it comes to say timestamps because, when sorting in Excel, it just performs a basic alphanumerical sort instead of intelligently knowing these are timestamps (10:01 sorts because 9:54 because 1 < 9 ).  

 

Does anyone know of a way to enable/disable this behavior per textfield?

 

Thanks!

[lucianc]

Setting the IS_DETECT_CELL_TYPE export parameter to true should take care of this.

Regards,

Lucian

[dtrobert]

Lucian,

I'm not familiar with export parameters. Can you please give me a simple example?

[lucianc]

See below.  And also check the samples shipped with the JR distribution.

HTH,

Lucian

Code:

JExcelApiExporter xlsExporter = new JExcelApiExporter();xlsExporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);