Home General

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.



  • 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

    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

    Best regards,

    Nard Moseley
    Digital Metaphors
This discussion has been closed.