Culture issue

[Eleonora]

Hi all I have a problem during the import of an existing excel file with formula inside

(e.c.  IF(H1<>"";IF(J1="";"";INDEX(INDIRECT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE("Var_"&C1&"_"&G1&"_"&H1;" ";"hex20");"-";"hex2d");"(";"hex28");")";"hex29");"/";"hex2f");"+";"hex2b");"&";"hex26");".";"hex2e")&"_Daily");MATCH(J1;INDIRECT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE("Var_"&C1&"_"&G1&"_"&H1;" ";"hex20");"-";"hex2d");"(";"hex28");")";"hex29");"/";"hex2f");"+";"hex2b");"&";"hex26");".";"hex2e")&"_Levels");0)));""

or

==EOMONTH(startdate;-1)

These formula are used in different cells in different sheets and when I try to bind the generated json to a spreadsheet component I received this error: 

• e {message: 'Expected op «,» but found sym «Var_» (input: _matr…"hex2b");"&";"hex26");".";"hex2e")&"_Service")"))', pos: 139}
1. message: "Expected op «,» but found sym «Var_» (input: _matrix(\"INDIRECT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(\"Var_\"&C1;\" \";\"hex20\");\"-\";\"hex2d\");\"(\";\"hex28\");\")\";\"hex29\");\"/\";\"hex2f\");\"+\";\"hex2b\");\"&\";\"hex26\");\".\";\"hex2e\")&\"_Service\")\"))"
2. pos: 139
3. [[Prototype]]: H

 

As posted in some forum  It seems due  to the culture used during excel generation (I tried different approach: attached a different culture to the current thread server side, force kendo core library to use a specific culture client side, force spreadsheet to use a specific culture server side).

How can I resolved this issue?

I did not found any working solution on line.

Thank you in advanced

Eleonora

[Dimitar]

Hi Eleonora, 

Can you specify the exact product that you are using? I am asking since the SpreadStreamProcessing library is used for different purposes. 

Regards,

Dimitar

[Eleonora]

https://www.telerik.com/document-processing-libraries framework aspnet core mvc 

 

telerik.documents.core.trial\2022.3.906\

telerik.ui.for.aspnet.core.trial\2022.3.913\

purpose: import an existing xlsm or xlsx file at the moment server side and bind it to a spreadsheet (telerik.web.spreadsheet.trial\2022.3.913\)

I referred to the trial version to build a poc for the customer to understand if this library is conformed to the required.

These trial version work as expected or lacks of some parts?

[Eleonora]

There are other libraries that we can use client side (js) for the same purpose?

[Eleonora]

No cause I have to import a complex xlsm with macro and complex formula inside, but if you have other suggestions also client side (js) I try to move to analyze this solution

[Alexander]

Hi Eleonora,

Thank you for the additional clarifications.

I'm not entirely about the currently utilized scenario on your end. Thus, could you please consider sharing additional information regarding the currently implemented scenario on your end?

Generally, we have a dedicated online demo that showcases exporting and importing files in the Spreadsheet component on the server using Telerik.Web.Spreadsheet NuGet package:

• https://demos.telerik.com/aspnet-core/spreadsheet/server-side-import-export

Could you please confirm whether you have a similar scenario to this? Nevertheless, If you need to persist formulas you can consider storing the data as JSON. You can then use the fromJSON method to load the state of the Spreadsheet. You can read more on this approach here:

• https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/import-and-export-data/json?_gl=1*1ngee5w*_ga*NDE1NTQxMTAwLjE2MzgzNzM5NzU.*_ga_9JSNBCSF54*MTY2NzIxMDExNy4xLjEuMTY2NzIxMDY0MS4wLjAuMA..#using-the-serialization-api

Or, preferably try isolating the reported behavior within a minimal sample and send it back for further evaluation. This will help me get a better overall understanding of the currently integrated result on your end and based on the obtained information, provide further guidance.

That being said in regards to the trial packages most of the specifics have been discussed within the following thread in more depth that you might find helpful:

• https://www.telerik.com/forums/what-happens-after-30-days-trial-