Trailbrake Member Posts: 11 Joined: 2/5/2004  User Profile | I am trying to export all my trades from various port sim methods for post processing in Excel. The exporting works fine as long as you don’t use the legacy excel format which still crashes my OT21. Anyway, my question is why are several but, not all, of the numeric fields exported as text? Both date fields and both trade price fields are formatted as text and populate with errors indicating the problem. The G/L field is formatted properly as a currency, so its clearly possible and not a crystal reports limitation. This makes it impossible to use those text (number) fields for further analysis without re-formatting them manually or, writing a macro to do it for me. Yes, I can fix them every time I export a report but, it is painful and time consuming. If I have missed something that allows exporting these fields with proper formatting let me know. If not, please put this feature request in the suggestion box. Thanks, Tim | |
