[#10431] - Exporting to ODS always format number as text cells not to number cells

Category:
Bug report
Priority:
High
Status:
Confirmed
Project: Severity:
Minor
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:

With JasperReports server 6.4.2.

Exporting to ODS always format number as text cells not to number cells.

Text fields for that cells are BigDecimal and Long types, even formatted like numbers with Pattern property.

Always starts with a quote (') each value cell and have to convert manually for number operations.

Excel exporter do it well.

Mariano

v6.4.2
mlopez_1's picture
5535
Joined: Oct 21 2013 - 8:08am
Last seen: 1 week 6 days ago

3 Comments:

#1
  • Assigned:nobody» shertage
#2
  • Status:New» Confirmed
#3
  • Priority:Normal» High
  • Assigned:nobody»

6.16.0
export with hidden symbol, then number as text
if push backspace in cell after export - value sets as number

Feedback