I get a external exception error msg

Posted by: mastershion-fp on 8 September 2017, 1:58 pm EST

  • Posted 8 September 2017, 1:58 pm EST

    I don't know why, but when I do a double click a cell, I get a msg error: "External exception cann't controlled, error operation asked from clipboard", nothing more and only occur when I set a celltype to a column



     Dim CurrCell As New FarPoint.Win.Spread.CellType.CurrencyCellType
            With CurrCell
                .DecimalPlaces = 0
                .MinimumValue = 1
                .MaximumValue = 3200
                .ShowCurrencySymbol = False
            End With
            With fpgrid
                .ActiveSheet.RowCount = 2

                .ActiveSheet.ColumnCount = 11

                .ActiveSheet.AlternatingRows(0).BackColor = Color.WhiteSmoke
                .ActiveSheet.Columns(2).CellType = CurrCell
            End With

     I really don't understand why, I hope you can help me, I'm using VS2008 and my current Spread version is 4.0.3508.2008.

  • Replied 8 September 2017, 1:58 pm EST


    With Spread version  4.0.3508.2008 using your code I am not getting any error message on double clicking a cell.This error message is related to clipboard , you may try clearing the clip board before you double click in a cell using <FONT size=2>Clipboard.Clear().




  • Replied 8 September 2017, 1:58 pm EST

    Yeah you have right, I know why now, when I clear the clipboard and I do another double click the cell it was trying to display the built-in calculator.


    Thanks for all again.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels