I have an UltraGridColumn with a datatype of "text" and a formula of string "2513694865213849663". When the CalcManager finishes its calculation I end up with String: "2.51369486521385E+18".
This blows an error in my application as I need this to be a string value with all numeric characters. Any way to make the CalcManager realize this should be treated as text and not numeric? I figured that by making the datatype of the column text this would solve it but evidently not.
I'm a little confused. What is the formula being applied to? A grid cell?
You would probably be better off making the cell a Double of a Decimal type rather than a string, but it's hard to say without knowing exactly what you are doing, where the value comes from, and where it's being written to.
Yes the formula is being applied to a grid cell. The data type needs to be a string because there cannot be a limitation on the number of numeric values entered. No matter how big the value, it must stay in the format it is inputted in and not convert to scientific notation.