Horizontal scroll

[ray]

 I load large data to cellgrid ,the second row merge two columns like Image1.png  in attach file.When I darg the   horizontalscrollbar ,the column merge not work like image2. if i click the scroll buttton ,it works fine.
Attachment: Pictures_8fb511d2.7z

[Kanimozhi Bharathi]

Hi Ray,

We have checked your issue by creating the merge cells at run time, but we were unable to reproduce the issue with our sample. Please find the sample link below,

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/WpfApplication1-402364699

UG: http://help.syncfusion.com/wpf/grid/events#querycoveredrange

If the issue still persists, please modify the sample to reproduce the issue and update with the replication procedure to analyze the issue and provide a solution.

Regards
Kanimozhi B

[ray]

Thanks a lot. now i get a new problem . when i export the grid with 100 row and 8000column, my app just crashed...Some time throw a outofmemory exception

[Kanimozhi Bharathi]

Hi Ray,  

   

We were able to reproduce the “Out of Memory Exception” issue while exporting with 8000 columns. This exception occurs because new Excel style will be created for each and every cell while exporting. Hence you can overcome this issue by setting the property ExportStyle of  ExcelExportingOptions as false. Please find the code example for your reference.  

   

Note: While using this option, cell styles are not exported. It will export the cell content only.  

 

   

var options = new ExcelExportingOptions();  

options.ExportStyle = false;  

ExcelEngine excelEngine = new ExcelEngine();  

IApplication application = excelEngine.Excel;  

IWorkbook workbook = excelEngine.Excel.Workbooks.Add();  

workbook.Version = ExcelVersion.Excel2013;  

IWorksheet workSheet = workbook.Worksheets[0];  

gridControl.Model.ExportToExcel(workSheet, options);  

workbook.SaveAs("Sample.xlsx");  

System.Diagnostics.Process.Start(@"Sample.xlsx");  

   

Regards  

Kanimozhi B