Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

XLS Output - Numbers are coming out as strings - RB 12.05

edited October 2011 in General
Hey Guys,

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.

Regards,
Brenton

Comments

  • edited October 2011

    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
This discussion has been closed.