1. Home
  2. Forum
  3. ASP.NET Core - EJ 2
  4. On .NET 5 or 6 XlsIO can't open file or set Formula when Regional format is Thai (Thailand)

On .NET 5 or 6 XlsIO can't open file or set Formula when Regional format is Thai (Thailand)

Hi,

On .NET 5 or 6 XlsIO can't open excel file or set Formula when my windows set Regional format to Thai (Thailand).

It will throw System.ArgumentException: 'Item has already been added. Key in dictionary: ' ' Key being added: '&''

Note: .NET Core 3 is not error.





26 Replies 1 reply marked as answer
RS Ramya Sivakumar Syncfusion Team April 13, 2022 05:24 AM UTC

Hi Krailit,


Greetings from Syncfusion.


We can reproduce the reported Argument Exception issue at our end and validate it currently. We will share the validation details in 2 business days, on April 19, 2022.


Regards,

Ramya.



KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team April 19, 2022 02:09 PM UTC

Hi Krailit,


We appreciate your patience.


We have confirmed the issue as Argument Exception is thrown while opening Excel document containing formulas in Thai culture and logged a defect report. We will include the fix for this issue in our weekly NuGet release scheduled for April 26th,2022. We will let you know once the package is available to download from NuGet.org.


You can track the status of defect report through following feedback link.

Track Status: https://www.syncfusion.com/feedback/34273/argument-exception-is-thrown-while-opening-excel-document-containing-formulas-in


Regards,

Keerthi.


KR Krailit replied to Konduru Keerthi Konduru Ravichandra Raju April 20, 2022 02:49 AM UTC

Thank you for support.

I can't access Track Status link.


RS Ramya Sivakumar Syncfusion Team April 21, 2022 07:46 AM UTC

Hi Krailit,


We deeply regret the inconvenience caused.


We have now resolved the issue and request you to try again and let us know if you can now track the feedback.


Regards,

Ramya.



KR Krailit replied to Ramya Sivakumar April 21, 2022 08:02 AM UTC

Hi  Ramya,


Thank you, I can now track the feedback.


Regards,

Krailit.


RS Ramya Sivakumar Syncfusion Team April 22, 2022 04:38 AM UTC

Hi Krailit,


Thanks for the update.


Regards,

Ramya






RS Ramya Sivakumar Syncfusion Team April 26, 2022 02:07 PM UTC

Hi Krailit,


We appreciate your patience.


We have included the fix to resolve the issue Argument Exception is thrown while opening Excel document containing formulas in Thai culture in our weekly NuGet release version 20.1.0.51. Kindly upgrade your Syncfusion packages to this new 20.1.0.51 version and let us know if the issue is resolved.


Regards,

Ramya


KR Krailit replied to Ramya Sivakumar April 27, 2022 03:11 AM UTC

Hi, Ramya


Thanks the issue is resolved.


But I found new issue. I can't set number format with comma (,)  separator when region format is Thai.




Regards,

Krailit


RS Ramya Sivakumar Syncfusion Team April 27, 2022 09:29 AM UTC

Hi Krailit,


We are glad that the provided fix resolved your issue.


We can reproduce the reported Format Exception issue at our end and validate it currently. We will share the validation details on April 29, 2022.


Regards,

Ramya.


RS Ramya Sivakumar Syncfusion Team April 29, 2022 02:23 PM UTC

Hi Krailit,


We appreciate your patience.


We have confirmed the issue as an Exception is thrown while using number format in Thai culture and logged a defect report. We will include the fix for this issue in our upcoming weekly NuGet release scheduled for May 17, 2022.


You can track the status of the defect report through the following feedback link.


Track Status: https://www.syncfusion.com/feedback/34583/exception-is-thrown-while-using-number-format-in-thai-culture


Disclaimer: Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works reprioritization.


Regards,

Ramya.


KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team May 17, 2022 02:38 PM UTC

Hi Krailit,


We appreciate your patience.


We have fixed the issue Exception is thrown while using number format in Thai culture and generated custom NuGet in the version 20.1.0.55. This custom NuGet can be downloaded from the below link.


Custom NuGet: https://www.syncfusion.com/downloads/support/directtrac/general/ze/syncfusion.xlsio.net.core.20.1.0.55-846072283.zip


Kindly try this new package and let us know if this helps.


Regards,

Keerthi.


KR Krailit replied to Konduru Keerthi Konduru Ravichandra Raju May 18, 2022 02:20 AM UTC

Hi Keerthi,


The issue  Exception is thrown while using number format in Thai culture is not fixed. I test on version 20.1.0.55 and 20.1.0.56.






Regards,

Krailit.


RS Ramya Sivakumar Syncfusion Team May 18, 2022 09:52 AM UTC

Hi Krailit,


We are unable to move the fix in this Weekly NuGet due to complexity. We will include this fix in our weekly NuGet release scheduled for May 24, 2022, without fail, and let you know once the package is available to download from nuget.org.


As for now kindly download the Custom NuGet from the previous update and use it to resolve the issue.


Regards,

Ramya.


KR Krailit replied to Ramya Sivakumar May 19, 2022 02:17 AM UTC

Hi Ramya,


I download the Custom NuGet and use it offline installation. But the issue is not fixed I got the error FormatException.


Regards,

Krailit.


RS Ramya Sivakumar Syncfusion Team May 19, 2022 09:56 AM UTC

Hi Krailit,


We suspect the older version of NuGet is referred from the NuGet cache. So kindly remove the 20.1.0.55 version package from the syncfusion.xlsio.net.core folder. And then download and use the Custom NuGet. 


Kindly use the following steps to remove the older package and install the Custom NuGet.


  • Press Win+R on your machine.
  • Type .nuget and click enter.
  • Open the packages and search for syncfusion.xlsio.net.core
  • Open that folder and search for the 20.1.0.55 version.
  • Delete the 20.1.0.55 version folder.
  • Now go back to the application and install the custom NuGet again.
  • Rebuild the solution and execute.


If you are still facing any issues kindly let us know your availability and time zone to schedule a web meeting. Based on your confirmation, we will send you the meeting invite.


Regards,

Ramya.


KR Krailit replied to Ramya Sivakumar May 19, 2022 10:31 AM UTC

Hi Ramya,


Thank for support. The issue is resolved after delete NuGet cache.


Regards,

Krailit.


RS Ramya Sivakumar Syncfusion Team May 20, 2022 04:56 AM UTC

Hi Krailit,


We are glad that the provided suggestion helped you. Kindly let us know if you need any further assistance.


Regards,

Ramya


RS Ramya Sivakumar Syncfusion Team May 24, 2022 10:46 AM UTC

Hi Krailit,


We appreciate your patience.


We have included the fix to resolve the issue Exception is thrown while using number format in Thai culture in our weekly NuGet release version 20.1.0.57. Kindly upgrade your Syncfusion packages to this new 20.1.0.57 version and let us know if the issue is resolved.


Regards,

Ramya


KR Krailit replied to Ramya Sivakumar May 24, 2022 01:21 PM UTC

Hi Ramya,


Thanks the issue is resolved.


Regards,

Krailit


RS Ramya Sivakumar Syncfusion Team May 25, 2022 08:58 AM UTC

Hi Krailit,


We are glad that the provided suggestion helped you. Kindly let us know if you need any further assistance.


Regards,

Ramya


KR Krailit September 8, 2022 02:27 AM UTC

Hi Support,


The issue is not resolved after version 20.1.0.61.


Regards,

Krailit


KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team September 9, 2022 01:10 PM UTC

Hi Krailit,


We are checking your query and will get back to you with details in 1 business day, on September 12th,2022.


We appreciate your patience.


Regards,

Keerthi.


RS Ramya Sivakumar Syncfusion Team September 12, 2022 01:20 PM UTC

Hi Krailit,


We deeply regret the inconvenience caused.


We have fixed the issue Argument Exception is thrown while opening Excel document containing formulas in Thai culture and generated custom NuGet in version 20.2.0.48. This custom NuGet can be downloaded from the below link.


Custom NuGet:

https://www.syncfusion.com/downloads/support/directtrac/general/ze/syncfusion.xlsio.net.core.20.2.0.482110998906.zip


Kindly try this new package and let us know if this helps.


We will include the fix for this issue in our upcoming weekly NuGet release scheduled for September 20, 2022.


Regards,

Ramya


KR Krailit replied to Ramya Sivakumar September 13, 2022 02:21 AM UTC

Hi Ramya,


Thanks the issue is resolved.


Regards,

Krailit


RS Ramya Sivakumar Syncfusion Team September 13, 2022 10:25 AM UTC

Hi Krailit,


You're welcome. We are glad that the issue is resolved.


Regards,

Ramya



RS Ramya Sivakumar Syncfusion Team September 21, 2022 11:01 AM UTC

Hi Krailit,


We have included the fix to resolve the issue Argument Exception is thrown while opening Excel document containing formulas in Thai culture in our weekly NuGet release version 20.2.0.50. Kindly upgrade your Syncfusion packages to this new 20.2.0.50 version and let us know if the issue is resolved.


Regards,

Ramya


Marked as answer
Loader.
Up arrow icon