Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1995
Excel export problems in IG 2011 v.2
posted

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.

Grid and excel.zip