1. Home
  2. Forum
  3. WinForms
  4. Spreadsheet issues: Merge does not save / Resizing row heights causes error

Spreadsheet issues: Merge does not save / Resizing row heights causes error

Good day,
I would like to report a couple of issuesI have encountered with the spreadsheet control.
1) Merging cells (using the code sample from the online documentation) does merge the cell range but the merging does not save with the rest o the workbook when saved (through "SaveAs"). When the workbook is opened again any merged cells are no longer merged.
2) Sometimes when changing the row heights of various rows (in several different workbooks) the debugger will break with this exception: "rangeName - string cannot be empty"

If there are any fixes or work arounds for these issues please let me know.

Thanks!

5 Replies
TL Thirumurugan Loganathan Syncfusion Team February 20, 2018 06:09 PM UTC

Hi Travis, 
 
We have checked this issue in the latest syncfusion product release which working fine. So can you please share your syncfusion product version for validate and give you appropriate solution on the reported issue. 
 
Regards, 
Thirumurugan 


TC Travis Chambers February 20, 2018 07:35 PM UTC


I am using 15.4.0.17.

Thank you.

TL Thirumurugan Loganathan Syncfusion Team February 21, 2018 01:03 PM UTC

Hi Travis, 
 
Please find the below details for your queries, 
 
S.No 
Queries 
Comments 
 
1 
Cells are merged and saved using Save As method. But Merged Cells are no longer maintained when open it again in the spreadsheet control. 
 
We could not reproduce the reported issues. Please find the given video link for further reference. 
 
Video link:  
 
 
If the issue persists in your side, please modify the given same and revert us for validate and provide you the appropriate solution on the issue. 
 
Sample:  
 
  
2 
String cannot be empty exception occurred while changing the Row heights of different rows. 
 
 
Regards, 
Thirumurugan 


TC Travis Chambers February 22, 2018 06:18 PM UTC

Thank you very much! I got the merge issue ironed out as I had a small issue with my code. The row resizing issue I have discovered only happens if the current cell is in the row that is being resized and the row is empty. So, now that I know that I can simply make sure to select a row other than the one I am resizing to avoid the error. It is still a bit weird though.

If I may ask, and this is unrelated, but is there any way to use a formula in spreadsheet control that references another workbook? Xlsio seems to have that functionality but the documented code on that does not seem to work in the spreadsheet control. I am attempting to analyze data in the spreadsheet control when the data is stored in a separate xlsx file in an attempt to keep the spreadsheet control light weight and more stable. I have previously tried to use oledb to query the data, which works, but I then cannot use data list validation to create filters as the queries are not impacted by that.

Thanks.

TL Thirumurugan Loganathan Syncfusion Team February 26, 2018 02:16 AM UTC

Hi Travis, 
 
Please find the below details, 
 
S.No 
Query 
 
Comments 
1 
Cell values has disappeared when resize the current cell selected row. 
We could not reproduce the reported issue. Please find the below video link for your clarification. 
 
Video Link 
 
2 
Is there any way to use formula in spreadsheet that references another workbook? 
Since the data is stored in the separate excel file, spreadsheet does not have support to use formula from another workbook. 
 
 
Regards, 
Thirumurugan  


Loader.
Up arrow icon