Hi,we use the ExcelExport to publish data from UltraWinGrids (includuing functions which were calculating by UltraCalcManager) to Excel.We usually use simple formulas like: ' if( [Value_1] = 0 , 0 , ([Value_2] / [Value_1])) '.
Depending on the application language the export of these funtions always occurs errors.If I use German as current application culture I get the error message 'A function in the formula has no closing parenthesis. Portion with error: IF((H9 = 0)' in the Excel cells.Changing the language to English as application culture the same formula produces no export error.
We use Infragistics3.Win.UltraWinGrid.ExcelExport.v11.2 with Service Release '11.2.20112.2028'
thanks
Hello Erik,
Thanks for attached sample. I saw the mentioned behavior and your approach with changing of CurrentCulture is the right way to solve your issue. At that moment our UltraCalcManager works when the current culture has a dot for a decimal separator. Please let me know if you have any questions.
Regards
Hello Georgi,
thanks for your answer.
Since we changed the Infragistics components in our application from 11.1 to the newer release 11.2 some of our use cases don’t work anymore.
We use UltraWinGrids to display data(tables) directly in the application.
In this environment calculations with the UltraCalcManager work fine with application culture German or English and with both of the mentioned infragistics releases. So the UltraCalcManager is not the problem.
In the next step we export these grids to Excel workbooks/worksheets. In the former Release 11.1 there was no problem exporting formulas with German application culture. We tested our application with different Infragistics releases/services releases (with no other changes in the code).
Service release version of
Infragistics3.Win.UltraWinGrid.ExcelExport |EN| DE
-----------------------------------------------------------------------------------------
11.1.20111.2030 | yes | yes
11.2.20112.1010 | no | no
11.2.20112.2004 | no | no
11.2.20112.2019 | no | no
11.2.20112.2028 | yes | no
Yes – formulas are exported to Excel correctly
No – error in formulars during/after export
How can we get these formulas into an excel sheet using a German application culture? Did you address this problem in the upcoming service release?