Bug Report B191256
Visible to All Users

Export to Csv String transformed to number

created 14 years ago

Hi,
I am using the < l.PrintingSystem.ExportToCsv("CustomCodes.csv"); > to create a csv file from a datagrid. However one of my data fields that is string type and contains data like 004.0, 078.0 etc is exported to csv in a numeric format. The 004.0 is transformed to 4 and 078.0 is transformed to 78. Is this a bug or I made some mistake?
Thanks

Show previous comments (5)
KV KV
Katrin Vlachantoni 14 years ago

    I have receive now your new email. Ok I wait…

    DevExpress Support Team 14 years ago

      Hi Katrin,
      Thanks for the update. We'll continue working on this problem. Once we have any results, we'll update the ticket's status accordingly.
      Thanks,
      Alex

      DevExpress Support Team 14 years ago

        Hi Katrin,
        Please accept my sincere apologies for the delay in responding.
        It appears that the cause of the problem is that MS Excel program has own algorithm to import CSV file. If you check the created csv file in the Notepad, all data displays perfectly. I am afraid that we cannot change the behavior of the MS Excel program at the level of our controls, sorry.
        Thanks,
        Elliot

        Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

        Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.