Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
2092
Incorrect Format String in Excel Export
posted

Hi,

I'm using your Excel Export framework to export data to Excel. I set a custom format string to a cell but it seems that the Excel Export library does something to the string when applying it to the Excel. This leads to a situation where the format string is not correct in Excel. I am using Finnish settings for separators.

The format string that I set in code is ### ### ### ### ### ##0,0000

When I look at the Excel formatting, I can see that the custom format string is ###\ ###\ ###\ ###\ ###\ ##0

So something is adding the backslashes to the format string. If I remove the backslashes in Excel, I get the correct formatting. 

I'm using Infragistics 14.1.20141.2138

Is there something I can do to prevent the backslashes being added?

Parents
  • 138253
    Verified Answer
    Offline posted

    Hello Antti,

    I have logged this with development under ID: 187263 and I have also created a support ticket on your behalf:CAS-149906-R3L3Z5 and have linked the development issue to it, so that you can get automatically updated, when a Service Release containing the fix is available for download. You can get the new version from our website’s “My IG”, “My Keys & Downloads” tags: https://www.infragistics.com/Membership/Default.aspx?panel=Downloads#Downloads

    You can also monitor the support ticket’s progress through the “My Support Activity” tag: https://www.infragistics.com/Membership/MySupport.aspx

Reply Children
No Data