Mike,
Finally we moved to IG 2011 v.2 last week. After the upgradation we found some problems in the excel export.
I have the grid with multi band (2 bands). I set the headerplacement position of the grid as "default". I gave provision to enable summary, filter and as well as groups. While exporting it to excel i faced following issues :
1) If i set summary to column and on export, header is coming before the summary rows (Refer : Pic 5 in attachment)
2) If i enable and applied filter, only the filtered rows are showing in the grid. But on export many rows header are showing (ex. assume that if i have 5 rows and while applying filter, the grid is showing only one row. On export, the excel having 5 header rows and 1 data row)( refer PIC 04 in attachment)
3) If i changed the Headerplacement of the 1st band as "Fixedontop" and 2nd band as "default", on export it is showing headers of 2 bands on the top (Refer : PIC 07 in the attachment)
I herewith attached a sample project for your reference:
Steps to reproduce the issues:
Problem 1:
Step 1: Run the project
Step 2 : Click "Apply summary" on the top
Step 3: Select some value in Summary dialog (Ex : select Sum, Average)
Step 4: Click "Excel export"
Step 5 : Check the summary rows having headers
Problem 2 :
Step 1: Click "Apply Filter" after executing the sample project
Step 2: Give the filter as "2" in the column "Text column1". It will show only 1 row.
Step 3: Now click "Excel export"
Step 4: Check the excel showing 5 header rows
Problem 3:
Step 1 : Open the project and go to "Form1_Load"
Step 2 : Uncomment the below mentioned line at the end of event
"grdReport.DisplayLayout.Bands(0).Override.HeaderPlacement = HeaderPlacement.FixedOnTop"
Step 3 : Run the project
Step 4 : Click "Excel export"
Step 5: Check we are getting header of 2 band on the top.
Is there any properties to override this problems.
Guide us to solve the issue.
Mike / Chris,
Thanks for your support.
Hi Suresh,
I have generated case CAS-78805-S3HL0Y to further investigate these issues and to prepare them for review by my developers. I will be providing you with further information regarding the issue including updates on progress through this case.
If you have any questions, at all in the meantime, please let me know.
Sincerely,
Chris K
Developer Support Engineer
Infragistics, Inc.
www.infragistics.com/support
All of these issues appear to be bugs. I forwarded this thread over to Infragistics Developer Support. I'm surprised you haven't heard from them, yet.
I will ping them again to see what's going on. But basically, they need to create a case for you and write these issues up for developer review so we can check them out.
Any one guide me for the above mentioned post?