MissingMethodException When Using SaveExcel

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

  • Posted 8 September 2017, 1:49 pm EST

    <p>FarSpoint Spread v4.0.2001.2005, VS 2008, VB.net <br></p><p>Hi everyone! <br></p><p>When I call the SaveExcel method  of my sheet, it causes a MissingMethodException:</p><p><img src="http://www.thomasmartens.de/images/MissingMethodException.png" title="MissingMethodException" alt="MissingMethodException" width="1626" height="171"> </p><p>Any idea, why this exception comes up? I'm using the following code:</p><p><font face="courier new,courier">    Private Sub ButtonItem_ExcelExport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonItem_ExcelExport.Click<br>        Dim mSaveFileDialog As New SaveFileDialog<br>        mSaveFileDialog.Filter = "Microsoft Excel 97-2003-Datei (*.xls)|*.xls"<br>        If mSaveFileDialog.ShowDialog = Windows.Forms.DialogResult.OK Then<br>            Me.FpSpread_ImportList.ActiveSheet.Protect = False<br>            Me.FpSpread_ImportList.ActiveSheet.HorizontalGridLine = New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None)<br>            Me.FpSpread_ImportList.ActiveSheet.VerticalGridLine = New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None)<br>            Me.FpSpread_ImportList.ActiveSheet.PrintInfo.ShowGrid = False<br>            Me.FpSpread_ImportList.ActiveSheet.PrintInfo.ShowColor = True<br>            Try<br>                Me.FpSpread_ImportList.SaveExcel(mSaveFileDialog.FileName, FarPoint.Excel.ExcelSaveFlags.SaveAsViewed)<br>            Catch ex As Exception<br>                MsgBox(ex.Message)<br>            End Try<br>        End If<br>    End Sub</font> </p><p>Thanks a lot,</p><p>Thomas <br></p>
  • Replied 8 September 2017, 1:49 pm EST

    <p>Hello Thomas,</p><p>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.</p><p>Thanks</p>
Need extra support?

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

Learn More

Forum Channels