how to assignment between two fpspreads

Posted by: meidaolia on 8 September 2017, 5:00 am EST

  • Posted 8 September 2017, 5:00 am EST

    here is a question, form1 has a fpspread1, form2 has a fpspread2, I edit fpspread2 when form2 actived. when I closed form2 and chose OK, I want to fpspread2's value assigned to fpspread1, how  to come true this?

    a new member for Fpspread. 


  • Replied 8 September 2017, 5:00 am EST


    You may save fpSpread2 to buffer and then you can load data from buffer to fpSpread1 in form1 during Form2_Unload event.Below is the code for Form2_unload that does the same,

    Private Sub Form_Unload(Cancel As Integer)
        Dim handle As Variant
        handle = fpSpread2.SaveToBuffer
        Form1.fpSpread1.LoadFromBuffer handle
    End Sub

    I hope it will help you.



  • Replied 8 September 2017, 5:00 am EST

    Thank you for reply immediately.

    I do like this and come ture the requirement:

         In form2 , I declare a variable : public FarPoint.Win.Spread.SheetView[] aView;

         And when form2 closed :aView = new FarPoint.Win.Spread.SheetView[] { this.fpSpread1_Sheet1 };

        In form1: 


    thank you again.

    Best Regards for you!

Need extra support?

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

Learn More

Forum Channels