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:

    MissingMethodException 

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

        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
                Try
                    Me.FpSpread_ImportList.SaveExcel(mSaveFileDialog.FileName, FarPoint.Excel.ExcelSaveFlags.SaveAsViewed)
                Catch ex As Exception
                    MsgBox(ex.Message)
                End Try
            End If
        End Sub

    Thanks a lot,

    Thomas

  • 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.

    Thanks

Need extra support?

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

Learn More

Forum Channels