Tools/Options/Export Options/Excel/Common , set checkbox "Detect Cell Type" is working only if report is generating from JasperReport. If same jasper being used to generate report from a java based product it is not working and Number field appearing as text while taking excel output. Any help?