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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Horizontal scroll

Thread ID:

Created:

Updated:

Platform:

Replies:

123771 Apr 20,2016 03:16 AM UTC Apr 22,2016 11:46 AM UTC WPF 3
loading
Tags: GridControl
ray
Asked On April 20, 2016 03:16 AM UTC

 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 11:34 AM UTC

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 21, 2016 03:51 AM UTC

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 11:46 AM UTC

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.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon 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.Close Icon

;