MissingMethodException When Using SaveExcel

Posted by: sirtommy on 8 September 2017, 1:49 pm EST

  • Posted 8 September 2017, 1:49 pm EST

    FarSpoint Spread v4.0.2001.2005, VS 2008, VB.net

    Hi everyone!

    When I call the SaveExcel method  of my sheet, it causes a MissingMethodException:

    <img src="http://www.thomasmartens.de/images/MissingMethodException.png" title="MissingMethodException" alt="MissingMethodException" width="1626" height="171"> 

    Any idea, why this exception comes up? I'm using the following code:

    <font face="courier new,courier">    Private Sub ButtonItem_ExcelExport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonItem_ExcelExport.Click
            Dim mSaveFileDialog As New SaveFileDialog
            mSaveFileDialog.Filter = "Microsoft Excel 97-2003-Datei (*.xls)|*.xls"
            If mSaveFileDialog.ShowDialog = Windows.Forms.DialogResult.OK Then
                Me.FpSpread_ImportList.ActiveSheet.Protect = False
                Me.FpSpread_ImportList.ActiveSheet.HorizontalGridLine = New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None)
                Me.FpSpread_ImportList.ActiveSheet.VerticalGridLine = New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None)
                Me.FpSpread_ImportList.ActiveSheet.PrintInfo.ShowGrid = False
                Me.FpSpread_ImportList.ActiveSheet.PrintInfo.ShowColor = True
                    Me.FpSpread_ImportList.SaveExcel(mSaveFileDialog.FileName, FarPoint.Excel.ExcelSaveFlags.SaveAsViewed)
                Catch ex As Exception
                End Try
            End If
        End Sub</font>

    Thanks a lot,


  • Replied 8 September 2017, 1:49 pm EST

    Hello Thomas,

    I have tested the reported issue with the latest available build (4.0.2009.2005) of Spread control, in seems to work as expected in this build. The exception is thrown when there is an attempt to dynamically access a method that does not exist.So you may try upgradinig to the above mentiend build of the control and let us know your obseravtions with the same.


Need extra support?

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

Learn More

Forum Channels