open xml file still slow

Posted by: edinsf on 8 September 2017, 2:09 pm EST

  • Posted 8 September 2017, 2:09 pm EST

    Hi Farpoint - Back in the Com days, we saved our spreadsheet files as .ss? files. It appears that in .net, xml is the format of choice. We use a model file to populate the Spread control. When I open it from the Designer, it takes 5 seconds. From it takes 35 seconds. I looked around and implemented what I could find in the way of suggestions (see sample code below), but it doesn't make much difference. How can I bring my code up to the speed of the designer open? Thanks!

    Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click


    FpSpread1.ActiveSheet.AutoCalculation = False

    FpSpread1.ActiveSheet.AllowNoteEdit = False

    FpSpread1.ActiveSheet.AutoUpdateNotes = False

    FpSpread1.AllowCellOverflow = False



    End Sub

  • Replied 8 September 2017, 2:09 pm EST


    You are already using the methods and properties to enhance the performance.It some times depends on the file format , Is it possible for you to share that XML file?

    You should also be able to open and save Spread files e.g.

     FpSpread1.Save("D:\Spreadfile.ss7", True)     ' to save a file as Spread File

     FpSpread1.Open("D:\Spreadfile.ss7")            ' to open a Spread File



  • Replied 8 September 2017, 2:09 pm EST

    Hi - I'm happy to share the file; however, if ss7 is an acceptable format for the .net product, I'd prefer to go that route. We don't have a good reason for using an XML format. I guess I was a little confused as to whether ss7 was OK for .net. Thanks for your help.

    Hi Again - I guess I spoke too soon - the ss7 format is just as slow. There must be something about our template file that's slowing the process, although as I mentioned, it opens very quickly in the designer.  Let us work with it here for a bit (maybe we can re-create the template file) and if I still need help, I'll attach a copy of the template file. Thanks


  • Replied 8 September 2017, 2:09 pm EST


    You can use the OpenSpreadFile method of Spread(.net) to open an existing file from the COM version of FarPoint Spread, such as FarPoint Spread 7.0. 



Need extra support?

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

Learn More

Forum Channels