We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Horizontal scroll

Thread ID:

Created:

Updated:

Platform:

Replies:

123771 Apr 19,2016 11:16 PM Apr 22,2016 07:46 AM WPF 3
loading
Tags: GridControl
ray
Asked On April 19, 2016 11:16 PM

 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 [Syncfusion]
Replied On April 20, 2016 07:34 AM

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
Replied On April 20, 2016 11:51 PM

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 [Syncfusion]
Replied On April 22, 2016 07:46 AM

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  
 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;