On Fri, 2006-07-28 at 06:03 -0500, Mac McClain wrote: > Arnold -- the =old only appears to work in the same sheet. I need to access > the name from another sheet. > Singleton -- I am subscribed. Thanks for the pointer to the PDF but that > reference is how to define a name. I have the name defined. I need to access > the name from another sheet. If I use the absolute address (ex. D28) from > sheet2 (ex.$sheet1.D28) then I get the data from sheet1 over to sheet2. I > would like to be able to get that data by name. Can you help?
No. Not into Calc enough to be useful. Regardless of whether you get an
answer from those more expert or not, suggest that you enter an Request
for Enhancement (RFE) into Issue
Tracker as this is the best way to have requests such as this evaluated.
If you haven't already registered, do the following:
1. To file an issue you must register with OOo by clicking the
My Pages tab and selecting the Register link
http://www.openoffice.org/servlets/Join
2. Fill in your information
3. Reply to the confirmation email that will be sent to the address
you provided.
4. Once you have confirmed, go to www.openoffice.org again
5. And click on the "My Pages" tab from which you can file and find
issues.
Thanks for bringing this to our attention. It is important that you file
any examples with the issue to ensure your need is understood.
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: <[email protected]>
> Sent: Thursday, July 27, 2006 9:03 AM
> Subject: [users] RE [users] Calc Formula
>
>
> > Mac,
> >
> > Just type
> >
> > =old
> >
> > in the cell that you want to display the value. In my case (OO0 2.0.3 on
> > WinXP) it returned the value of the cell I called old.
> >
> > Arnold Huzen
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
--
PLEASE KEEP MESSAGES ON THE LIST.
OpenOffice.org Documentation Co-Lead
http://documentation.openoffice.org/
smime.p7s
Description: S/MIME cryptographic signature
