All numeric values put in a spreadsheet (ods) will be strings.

[GoogleCodeExporter]

What steps will reproduce the problem?
1. freemarker template ods containing
[#list sheet.rows as row][#list row.cells as cell]${cell.value} [/#list]
[/#list]

2. Model object with:   public int  value;

What is the expected output? What do you see instead?

Would like to see cells populated with integers instead I get strings.

What version of the product are you using? On what operating system?

xdocreports 1.0.0, Linux

Please provide any additional information below.

A spreadsheet with strings is not so useful .... :-(

I also tried to add formulas they are interpreted as strings to...

Is there something I am missing or a workaround?

Regards

Hans Höök

Original issue reported on code.google.com by hans.h...@altrusoft.se on 4 Oct 2013 at 3:00

[GoogleCodeExporter]

Hi Hans,

I had developped spreadsheet (ods) just to validate the architecture of 
XDocReport (to manage any ooxml, odf documents). But as you have seen, it 
doesn't manage list etc. The big problem with ods, xsls, it that you cannot use 
mergefield/input field and it's hard to detect the field name in the document.

We have a lot of work about docx/odt reporting and I have no time today to 
improve ods. 

Any contribution are welcome!

Regards Angelo

Original comment by angelo.z...@gmail.com on 4 Oct 2013 at 11:48

• Changed state: Accepted