How to load automatically in numerical format, the values that were exported in excel from Ireport?

Question

How to load automatically in numerical format, the values that were exported in excel from Ireport?

Navigation

#1 by (0 votes)

0

When exporting a report made in Ireport as excel, there are certain numerical values that are loaded as text when opened in excel, even though these cells are in BigDecimal format in the ireport. My question is, is it possible to configure automatically for Excel to load them in numerical format?

Thank you in advance for any contribution.

ireport

asked by Fabian Peñaloza 22.11.2018 в 17:14

source

1 answer

Compare session times between different systems Redirect Index.php

score 0 · Answer 1

By doing a little research I found this post that I found useful

link

In which you specify that you must edit the .jxrml file and add this property to your content Finally when generating the report all the values were automatically loaded in numeric format.