When we are printing to an XLS Data or Report the currency numbers are coming out as text so you can't perform any sums on them. From what I can see we don't have any custom code in this area.
For a data-ware component such as DBText, the value, datatype, and format are exported as separate cell attributes. Variable components are treated similarly.
If the OnGetText event of a component is implemented, this implies the Text is being assigned in custom code and therefore the exact text string is exported, the datatype is overridden to string, no format.
- Nard Moseley Digital Metaphors www.digital-metaphors.com
Best regards,
Nard Moseley Digital Metaphors www.digital-metaphors.com
Comments
For a data-ware component such as DBText, the value, datatype, and format
are exported as separate cell attributes. Variable components are treated
similarly.
If the OnGetText event of a component is implemented, this implies the Text
is being assigned in custom code and therefore the exact text string is
exported, the datatype is overridden to string, no format.
-
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com