Spreadsheet - No text in cell until text focus.

Text/Value is set programmatically on spreadsheet load, but text does not show in cell until double-click on the cell. Formula bar shows text value when cell is selected.  


On a side note: Right clicking a cell, and selecting "Define Name..." throws an error: System.NullReferenceException: 'Object reference not set to an instance of an object.'

Video and project in .7z


Attachment: exampl_ee5e11a.7z


2 Replies

DM Dhanasekar Mohanraj Syncfusion Team June 22, 2022 02:05 PM UTC

Hi James,

Please find the response for the reported issue below,

Reported issue

Response


Text/Value is set programmatically on spreadsheet load, but text does not show in cell until double-click on the cell. Formula bar shows text value when cell is selected. 

 

Currently, we are able to reproduce the reported issue. We will validate and update you further details on June 24, 2022.

We appreciate your patience until then.

 

 

On a side note: Right clicking a cell, and selecting "Define Name..." throws an error: System.NullReferenceException: 'Object reference not set to an instance of an object.'

 

 

Based on provided information we have checked the reported issue in our end. But we are unable to reproduce the reported issue its works as expected. Here we have attached the tested sample and video demo. Please have a look on this. If you still facing the same issue, Modify the attached sample based on your scenario. It will be more helpful for us to check the possibilities to resolve the reported problem. 

 

Regards,
Dhanasekar M.


Attachment: Sample__Video_Demo_a67f069d.zip


DM Dhanasekar Mohanraj Syncfusion Team June 24, 2022 02:29 PM UTC

Hi James,

We have analyzed the reported issue in our end. If you need to view the loaded text it should be updated as DisplayText. For that you need to set the text shown like below,

C#:

spreadSheet.Loaded += SpreadSheet_Loaded;

private void SpreadSheet_Loaded(object sender, RoutedEventArgs e)

{

    spreadSheet.ActiveGrid.SetCellValue(spreadSheet.ActiveSheet.Range[3,3],"Active");

}


We have modified the sample based on your scenario. Please have a look on this and revert us if you need further assistance for this.

Regards,
Dhanasekar M.


Attachment: SpreadheetDemo_6f1c8fe.zip

Loader.
Up arrow icon