Referencing a cell from previous worksheet in same spreadsheet file...

[Clay McCall <mc...@gmail.com>]

I am trying to carry over a =sum() value from a cell in one spreadsheet to another cell in another sheet in the same spreadsheet file.  The instructions in the help section “Referencing a Cell in the Same Document” says that the formula is =sheet2.A1,  I have discovered that if you rename the sheets then this does not work.  Why can I not reference a sheet by another name?

Thanks for any assist,

R/
Clay McCall

Re: Referencing a cell from previous worksheet in same spreadsheet file...

["Girvin R. Herr" <gh...@sbcglobal.net>]

Clay,

I use renamed sheets and it works for me, but be absolutely sure there 
is no space to the left of the "=" in the expression.  I spent a lot of 
time troubleshooting this before I realized I had a space before the =.  
The symptom is that the cell displays the expression (text), not the 
data from the referenced cell.  Also, I am not sure it is required, but 
I make sure the referencing cell has the correct type for the referenced 
data: number, currency, text, etc.

HTH
Girvin Herr



On 06/03/2016 07:07 AM, Clay McCall wrote:
> I am trying to carry over a =sum() value from a cell in one spreadsheet to another cell in another sheet in the same spreadsheet file.  The instructions in the help section \u201cReferencing a Cell in the Same Document\u201d says that the formula is =sheet2.A1,  I have discovered that if you rename the sheets then this does not work.  Why can I not reference a sheet by another name?
>
> Thanks for any assist,
>
> R/
> Clay McCall


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org

Re: Referencing a cell from previous worksheet in same spreadsheet file...

[Jim McLaughlin <jj...@gmail.com>]

That will not work, but only for 1 value in the origin cell on sheet 1.

If the origin cell on sheet 1 undergoes a  value change, that  change will
not carry over to the target cell on sheet 2.

So if sheet 1's origin cell is dynamic, and its value is changed, by, say,
adding another number in to the origin cell [remember, the OP was using the
formula =SUM(:) in the origin cell on sheet 1] one needs o utilize the LINK
function in the "Paste Special"pop up / drop down screen.



On Fri, Jun 3, 2016 at 9:13 AM, Steve Ahlers <sa...@yahoo.com.invalid>
wrote:

>
> Even easier, type "=" in the formula bar for destination cell, then
> navigate to the original cell, click on it and hit "Enter" ( or "Return")
>
> Steve
> Sent from my iPad
>
> On Jun 3, 2016, at 7:21 AM, Jim McLaughlin <jj...@gmail.com>
> wrote:
>
> > try this:
> >
> > highlight cell to be copied> click edit >click copy;>navigate  to sheet
> > where cell is to be pasted> navigate to cell on second sheet where
> original
> > cell is to be pasted >highlight destination location > edit > click
> "paste
> > special"  > on grey pop up screen click "link"
> >
> > On Fri, Jun 3, 2016 at 7:07 AM, Clay McCall <mc...@gmail.com>
> wrote:
> >
> >> I am trying to carry over a =sum() value from a cell in one spreadsheet
> to
> >> another cell in another sheet in the same spreadsheet file.  The
> >> instructions in the help section “Referencing a Cell in the Same
> Document”
> >> says that the formula is =sheet2.A1,  I have discovered that if you
> rename
> >> the sheets then this does not work.  Why can I not reference a sheet by
> >> another name?
> >>
> >> Thanks for any assist,
> >>
> >> R/
> >> Clay McCall
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>

Re: Referencing a cell from previous worksheet in same spreadsheet file...

[Steve Ahlers <sa...@yahoo.com.INVALID>]

Even easier, type "=" in the formula bar for destination cell, then navigate to the original cell, click on it and hit "Enter" ( or "Return")

Steve
Sent from my iPad

On Jun 3, 2016, at 7:21 AM, Jim McLaughlin <jj...@gmail.com> wrote:

> try this:
> 
> highlight cell to be copied> click edit >click copy;>navigate  to sheet
> where cell is to be pasted> navigate to cell on second sheet where original
> cell is to be pasted >highlight destination location > edit > click "paste
> special"  > on grey pop up screen click "link"
> 
> On Fri, Jun 3, 2016 at 7:07 AM, Clay McCall <mc...@gmail.com> wrote:
> 
>> I am trying to carry over a =sum() value from a cell in one spreadsheet to
>> another cell in another sheet in the same spreadsheet file.  The
>> instructions in the help section “Referencing a Cell in the Same Document”
>> says that the formula is =sheet2.A1,  I have discovered that if you rename
>> the sheets then this does not work.  Why can I not reference a sheet by
>> another name?
>> 
>> Thanks for any assist,
>> 
>> R/
>> Clay McCall

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org

Re: Referencing a cell from previous worksheet in same spreadsheet file...

[Jim McLaughlin <jj...@gmail.com>]

try this:

highlight cell to be copied> click edit >click copy;>navigate  to sheet
where cell is to be pasted> navigate to cell on second sheet where original
cell is to be pasted >highlight destination location > edit > click "paste
special"  > on grey pop up screen click "link"

On Fri, Jun 3, 2016 at 7:07 AM, Clay McCall <mc...@gmail.com> wrote:

> I am trying to carry over a =sum() value from a cell in one spreadsheet to
> another cell in another sheet in the same spreadsheet file.  The
> instructions in the help section “Referencing a Cell in the Same Document”
> says that the formula is =sheet2.A1,  I have discovered that if you rename
> the sheets then this does not work.  Why can I not reference a sheet by
> another name?
>
> Thanks for any assist,
>
> R/
> Clay McCall