1. Home
  2. Forum
  3. WinForms
  4. Odd behavior activating cells in spreadheet

Odd behavior activating cells in spreadheet

I encountered a problem in my spreadsheet control (v 18.1460.0.42). The problem occurs if using it this way:

(1) Initialize values in a row by adding strings into the cells. ( grid.SetCellValue(...  )
(2) If a cell happens to have a long string value that flows outside of the cell display width, the string will overlay the next adjacent cell.
(3) Attempt to activate the covered cell 'behind' the overlaying text and type into the cell area where  you think it would be expected. (Double click or click and start to type.)
(4) The system will crash.

To avoid this:
(1) (as above)
(2) If a cell happens to have a long string that flows outside the right cell boundary, it will overlay the adjacent cell. Expand the column width manually by dragging.
(3) You can now type into the now-exposed cell input area without an error.

My workaround:
When I load in row contents, or when the user updates the cell content, I autoFit the cells for the entire row. I also block the cell width adjustment property so the user can't change the cell widths. This fix is not generally ideal, but turned out to be perfect for my particular implementation in the project.

Notes: If I load in a spreadsheet from disk, wide cells don't have this problem.


8 Replies 1 reply marked as answer
BT Balamurugan Thirumalaikumar Syncfusion Team August 24, 2020 05:40 PM UTC

Hi sabari, 

Thank you for contacting syncfusion support, 

We could understand and Reproduced the reported issue in our end,Forwarded the query to development team,Update you the proper details on 25th Aug 2020,Thank you for your patience. 

Please get back any assistance 

Thanks & Regards, 
Balamurugan Thirumalaikumar  


AR Arulpriya Ramalingam Syncfusion Team August 26, 2020 02:16 AM UTC

Hi Robert, 
 
Thank you for your patience, 
 
We have checked your scenario as per replication procedure suggested using setcellvalue() method, but in our end it works fine. So, please refer to the following sample and video and let us know that if we missed something to reproduce the issue. So that, we can provide the solution at the earliest. 
 
 
 
Regards, 
Arulpriya 


RD Robert Dickow August 30, 2020 05:00 PM UTC

Thank you for looking into this. I have attached a simple VS 2017 project that demonstrates the problem. It the window it will display the steps to reproduce the thrown exception and how to avoid it by expanding the column width manually.



Attachment: MySample_VS2017Project_a86e196a.zip

AR Arulpriya Ramalingam Syncfusion Team August 31, 2020 06:15 PM UTC

Hi Robert, 
 
Sorry for the inconvenience, 
 
We could reproduce the issue that the argument out of  the range exception is thrown when the cell is activated. So, we have forwarded the query to our development team for further validation. We will update the information on 1st September 2020. We appreciate your patience until then. 
 
Regards, 
Arulpriya 


BT Balamurugan Thirumalaikumar Syncfusion Team September 2, 2020 01:42 AM UTC

Hi Robert, 

Thanks for your patience 

We have validated the scenario and the reported issue occurred due to the DefaultRowCount for the spreadsheet is updated with minimum values. So, we have forwarded the issue to our development team for further validation and we need some more time to analyse completely. We will update you with proper details on 03rd September 2020 and appreciate your patience till then. 

Thanks & Regards, 
Balamurugan Thirumalaikumar

BT Balamurugan Thirumalaikumar Syncfusion Team September 3, 2020 01:50 PM UTC

Hi Robert, 
  
We confirmed that reported scenario is a defect from our end. We have logged a bug report for this issue “ArgumentOutofRange exception occurs when click on floating adjacent cells” Here we have provided private feedback link, we request you to log in to view the link further      
   
  
The fix will be available in our upcoming 2020 Volume 3 Sp-1 release which is scheduled to be rolled out at the mid of October. Would waiting for the official release is OK for you? Otherwise, we can provide a patch in the reported version 18.1.0.42 on September 10  2020. If you have any more specification replication procedure or a scenario to be tested you can add it as a comment in the portal also if the version is not correct, please specify the version in which you need the patch.    
  
Balamurugan Thirumalaikumar  


Marked as answer
RD Robert Dickow September 3, 2020 04:38 PM UTC

I am happy to wait until the October SP update. I did a work-around for the issue. You guys sure do GREAT tech support ! Thanks.

BT Balamurugan Thirumalaikumar Syncfusion Team September 4, 2020 03:42 PM UTC

Hi Robert



Thank your for your update,



As we updated earlier, we will let you know, once the upcoming release is rolled out.


Regards
Balamurugan.Thirumalaikumar 
  


Loader.
Up arrow icon