Big Red X

[Travis Chambers]

Good day,

I have experienced multiple instances of the spreadsheet component becoming a big red x when simply deleting or changing simple text in a given cell. Charts will remain, but the rest of the spreadsheet will disappear and be taken over with the red x. I have seen this in multiple worksheets and there is no obvious reason for this.

For example, most recently I have had a cell with "2082" as its contents (note: there are no actual quotes in the cell). If I delete this data I get the red X.

Are there any known causes of this big red x, perhaps non-compatible data types or formatting? Is there a way to avoid this red x. Ideally, having an actual exception thrown so that a cause can be found would be best.

Any guidance is appreciated.

Thanks!

[Travis Chambers]

After further evaluation, I have discovered that the red x (and subsequent exception) is thrown on "spreadsheet1.ActiveGrid.InvalidateCells()" if trying to make changes fro a button click. The first line of the stack trace says "mscorlib.dll!System.Math.Sign(double value) + 0x76 bytes. The exception error reads: "Function does not accept floating point Not-a-Number values."

I have never seen that error before. The cells affected in the spreadsheet I am currently using are three simple cells (one on top of the other) that receive numbers from a datatable and then a forth cell with a simple formula: =SUM(C26:C28). The numbers are not doubles, so that error makes me think there may be some formatting issue.

The error occurs if I try to delete any of those cells (including the formula cell) or try to change them by clicking the cell, typing, and pressing Enter. However, I can change the values by clicking in the formula bar and pressing enter without the error.

Any thoughts on this?

Thanks!

[Thirumurugan Loganathan]

Hi Travis, 

 

We have checked the issue “Spreadsheet control not loaded and exception occurred while editing the cell values”. But we were not able to reproduce the issue. Can you please share us issue replicable sample and video reference for further validation on the issue, Which will be helpful to us for provide you better solution. 

 

Regards, 

Thirumurugan