how to assignment between two fpspreads

Posted by: meidaolia on 8 September 2017, 2:00 pm EST

  • Posted 8 September 2017, 2:00 pm 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.

  • Replied 8 September 2017, 2:00 pm 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,

  • Replied 8 September 2017, 2:00 pm 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