AspNet Core, xlsx export error

[alex]

Hi,

empty asp net core project

when trying to export a empty file (code from examples) and always get the error:

"Index and count must refer to a location within the string (Parameter 'count')" (see on screenshot)

 

(the export logic is bound to the "Privacy" route in the "Home" controller)

windows 7, visual studio 2022, telerik asp net core 2021.3.1109

project attachet

 

[Tanya]

Hi Alex,

Looking at the stack trace, it seems like the error is related to something specific in the current culture applied to the OS. I have tested the sample project but it is properly working on my end. Can you please share the culture used on the machine you are testing the application on?

[alex]

ru-RU (russia)

[alex]

added more info 

[alex]

anybody help? why code not working on simple tasks

[Tanya]

Hi Alex,

I have applied the settings and verified they are the same as the ones I can see on the images. However, the logic is still working as expected on my end and I can export the file without any issues. Can you please check the .NET version you have installed? It can be easily seen by checking the value of the System.Environment.Version property.

[alex]

System.Environment.Version  5.0.13

 

 

 

[Tanya]

Hi Alex,

I have just prepared a sample using the setup and code you shared in this thread - can you please download it and test it on your machine? Are you still getting an error? Can you also try to run it on a different machine to check the behavior there?

[alex]

hi

download it, run, same error

 

[alex]

on another computer with windows 10 this project working fine

windows 7 is not supported?

[alex]

ok whatever, i used ClosedXML for my tasks, thx 

[Tanya]

Hi Alex,

I am sorry to hear that you had to fall back to using a different library. I have just managed to reproduce the error you see and it turned out to be specific for the combination of OS version, target platform, and the current culture. Here is the public report I have opened for this error: SpreadProcessing: IndexOutOfRangeException thrown when exporting file in Russian culture under Windows 7 and target platform is .NET Standard version. We are already working on fixing that issue. Please, make sure you are following the linked item so you can receive notifications about status changes on it.

I have updated your Telerik points in appreciation for this report.

Hope this is helpful.

[alex]

thx for your work, I hope no one else gets stuck on this error