I have two problem with excel exporter function. I have a grid with dynamic columns, and i added an unboud column at the end and set a formula to sum values of all columns. Below is the sample code i use for formula of an ubound column named "Total Amt". (Yes you are seeing question marks, thats how i have in the column name coming from a sql stored procedure.)
At InitializeLayout, i wrote:
AmountSpentFormula = "[Tea Tour?9299?9298] + [Meeting?9154?9290] + [Reception?7503?9285] + [BBQ?9179?9258] + [Tea Tour?9299?9304] + [Tea Tour?9226?9310] + [Tea Tour?9226?9311] + [Breakfast?9206?9312] + 0"
e.Layout.Bands[0].Columns["TotalAmt"].Formula = AmountSpentFormula;
When i see the result in the grid, all are fine, total amt is showing and calculating fine as expected.
But, when i export to excel using the following line, the app freezes.
ultraGridExcelExporter.Export(ultraGrid1, "c:\\temp\\griddata.xls");
Note: When i comment the formual line from IntiliazeLayout event, grid shows fine w/o the total sum and export to excel works fine.
Please Help.
Also on the side note
How can i export the excel file to an user accessible folder / location, right now i use "c:\temp\griddata.xls" but not everyone have access to it when i publish this windows app.
Hi,
What version of the grid are you using? Do you have the latest service release?
Bala said:How can i export the excel file to an user accessible folder / location, right now i use "c:\temp\griddata.xls" but not everyone have access to it when i publish this windows app.
I am not really sure what you are asking here. This seems like it would be better answered by Microsoft's documentation of you are having problems with folder security. Neither the grid nor the ExcelExporter have any control over that.
version 8.1
Do you have the latest service release? That's a pretty old version, so this must just be a bug that has long-since been fixed.
How to get the latest service release - Infragistics Community
yes, we have version 9.1
I am just worried that this is production application and i am just adding a small piece of functionality with my short timeframe.
But, i will consider upgrading when i get a break, not sure if it will be a smooth upgrade or if i will find some incompatability issues.
Should i just upgrade the latest version or keep old and new versions?
thanks.
Bala said:yes, we have version 9.1
Having v9.1 does not neccessarily mean you have the latest service release... or any service release. :)
Bala said: But, i will consider upgrading when i get a break, not sure if it will be a smooth upgrade or if i will find some incompatability issues. Should i just upgrade the latest version or keep old and new versions?
We try very hard to keep things backward compatible, but bug fixes do change things sometimes. The service release is free, though, and if you have a problem with it, you can roll it back.
If you want to create a small sample project which demonstrates the problem you are getting, post it her and I will run it with our latest internal build and see if I get the same problem.