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?
I already create a case for you with reference number CAS-83136-BFP9ZT. I`ll provide you additional information through the case. If you have any further questions, do not hesitate to write us.
Georgi
Hello Anca,
The issue is fixed in March 2012. Could you please try to donwload the latest available service release - 20111.11.1.2238. This release will upgrade your version free assemblies. Let me know if you have any questions.
we're experiencing the same problem with the UltraWebGrid, version free dlls 11.1. Can you tell me if this a known bug and if it was fixed, in which version.
Thank you,
Anca