Hi,
I'm using jXLS to write out a report as a spreadsheet, and one of my bean's fields is a java.util.Date. The bean has methods to either get the raw date, or to return a formatted string.
I want the date to appear as a Date field in the output spreadsheet, so that my users can sort them by date order.
If I put ${myBean.getDate()} i.e. input the raw Date, I get an unintuitive numerical value in the spreadsheet.
If I put in ${myBean.getFormattedDate()} i.e. formatted text, the date is readable, but is inserted as a string and won't sort correctly.
I've tried formatting the cells in the input spreadsheet as dates, but that doesn't seem to do the trick either.
I'm fairly new at jXLS, have I missed something obvious?
Thanks in advance,
Dave