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
1235
CellFormat.FormatString localization
posted

Hello,

we always set the cell FormatString for numbers in international localization "#,##0.00" even if the local/excel localization is different (german in this case). (https://msdn.microsoft.com/en-us/library/bb157877.aspx : the Excel Object Model Always Expects Locale ID 1033)

In Infragistics v10.3 this works fine, with v14.1 its not. it looks like it expects a localized FormatString.

Greetings
KiTs

Parents
No Data
Reply
  • 21795
    Offline posted

    Thank you for posting in our forum.

    Yes you are correct. In Infragistics 14.1 you need to specify localized format string to UltraExcelExporter. In 14.1 the format string is exactly taken over to Excel. Please find attached a small sample solution showing how to set the Excel format string during export.

    Please let me know if this is what you are looking for or if I am missing something.

    Sincerely,

    Milko

    Developer Support Engineer

    Infragistics, Inc.

    www.infragistics.com/support

    CAS-150263-J2S6T8.zip
Children