Hello,
I need to sum numeric data in generated Excel sheet but I encountered a problem:
1. When I use formatted data (<wr:out select=\"self::node()/@att2\" type=\"NUMBER\" pattern=\"#,##0.00\"/>), I can sum numeric data in range (0,1000) (i.e. only positive numbers without thousand separator)
2. Without formatting, I can sum only positive numbers.
I've attached a sample file.
Is there any way to generate an Excel sheet, where the numeric fields can be used as numbers?
We are running version 4.1.65
Thanks,
Jan