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. Image for the cookie policy date
close icon

Horizontal scroll

 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

3 Replies

KB Kanimozhi Bharathi Syncfusion Team 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


RA ray 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


KB Kanimozhi Bharathi Syncfusion Team 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  
 


Loader.
Live Chat Icon For mobile
Up arrow icon