Can you create a reference to a sheet on another Win form

Posted by: jarlath on 8 September 2017, 2:47 pm EST

  • Posted 8 September 2017, 2:47 pm EST

    <P>I have my main sheet on one windows form.   However, I want to use a formula to reference a cell in a sheet on a completely different form.  I searched through the forums and documentation, but could not find this.  Is it possible and if so, how?</P>
  • Replied 8 September 2017, 2:47 pm EST

    Not possible, a formula in a spread cell cannot reference a cell in another spread, best you can do is cross sheet references
  • Replied 8 September 2017, 2:47 pm EST

    <P>Thanks.  It is unfortunate though and Hope you consider that a future enhancement.  </P>
    <P>So, can I do this.  I will write back the amount from the source sheet to a database.   And, I will reference the database in the main sheet.   Can I create a hyperlink or something to at least bring up the source sheet from the main sheet.  This way it would at least appear they are linked.</P>
    <P>  </P>
    <P> </P>
  • Replied 8 September 2017, 2:47 pm EST

    <p>Hello,</p><p>If the other spread sheet is on a different Form you can access that Form in the same application and also get the values from the main Spread sheet.</p><p> <br>Private Sub FpSpread1_CellClick(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.CellClickEventArgs) Handles FpSpread1.CellClick
    <br>        If e.Column = 1 And e.Row = 1 Then
    <br>            FpSpread2.Visible = True ' if spread2 is on the same Form
    <br>            Form2.Show()             'if Spread2 is on another Form <br>        Form1.Fpspread1.Sheets(0).Cells(0,0).Vlaue= Form2.Fpspread2.Sheets(0).Cells(0,0).Value         <br>        Else
    <br>            FpSpread2.Visible = False
    <br>        End If
    <br> <br>    End Sub</p><p>Let me know if this is not what you are looking for. <br></p><p>Thanks,</p><p> </p>
Need extra support?

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

Learn More

Forum Channels