excel - Jasper Reports JExcelApi Exports Numbers As Text -


I have a Jasper report which is being successfully exported to Excel, although all numeric columns (currently type java .math.BigDecimal) appear in the form of "normal" in Excel, making it possible to perform numerical operations on columns (like adding additional 0) - even if you first convert the format of cell into a number Are i different for the column Try using Awa types, but to no avail.

Does anyone know that any numerical cells should be numerically sorted in Excel to specify in Jasper?

It has been found that you need to set the following parameters on the JExcelApi Exporter

< Pre> JExcelApiExporterParameter.IS_DETECT_CELL_TYPE

True


Comments

Popular posts from this blog

c# - ListView onScroll event -

PHP - get image from byte array -

Linux Terminal Problem with Non-Canonical Terminal I/O app -