Hi Chris,

frustratingly I'm not able to reproduce this issue so far. I'm definitely using the Sept patch of YF 6.3.

Here is a XLS export with Keep Formatting ON, as you can see by the little red triangles in the top left corner of the cells, the numbers have been kept as text:





And now, here is an XLS export with Keep Formatting OFF. As you can see in the screenshot there are no more little red triangles in the numeric cells.





Interestingly, in both of the above images you can see that the dates are right-aligned which is the same as in your "Correct:" image.

I couldn't tell because your images were cropped, but how were the numeric cells, did they have the red triangles or not?

Also, could you please show a screenshot of the date column from Step 2 of the View Builder, this is so we can see what sort of column it is so we can maybe set up a report that is more similar to yours.

regards,
Dave

Hi David,

The report is a Freehand SQL report. Please find attached the output file with Keep Formatting OFF. Also images of the step 2 , etc.

Regards,

Chris

Hi Chris,

thanks for the screenshots, I tried to reproduce the issue using a Freehand SQL report this time, but as far as I can tell the numbers are being exported as numbers not text, and the only difference I can see with the date is that the right-align switch has been turned on:





Also, I have just tried exporting the same report on a July build of 6.3 and the resulting XLS file was exactly the same as the September build, I can't see any difference





regards,
Dave

Hi Dave,

Very odd that it is not re-produceable. Is there a jar file that I can check to verify we have the correct version of the exporter?

Thanks,
Chris