chumansky Posted November 10, 2009 Share Posted November 10, 2009 I'm using iReport to make report and to convert it to ExcelMy query brings me above others BigDecimal values, but output Excel file understans BigDecimals only as text, whatever pattern I use for the cell.How to make it clear to Excel that I want to see a number in a cell, not text.And how I can tell Excel I need special format for the cell, not general Link to comment Share on other sites More sharing options...
chumansky Posted November 11, 2009 Author Share Posted November 11, 2009 Dear sirs!Is there no solution at all? Link to comment Share on other sites More sharing options...
cn73 Posted November 11, 2009 Share Posted November 11, 2009 Both xls exporters suppot the IS_DETECTE_CELL_TYPE parameter, wich forxes the ricreation of the original cell value ina ccordance with its declared data type, as specified in the report template. ;) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now