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. 

    thanks.

  • Posted 8 September 2017, 5:00 am EST

    Hello,

    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.

     

    Thanks,

  • Posted 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: 

                 this.fpSpread1.Reset();

                 this.fpSpread1.Sheets.RemoveAt(0);

                 this.fpSpread1.Sheets.AddRange(aForm2.aView);

    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