Re: Scott Klement's HSSF POI and referring to a cell in different sheet

[Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>]

Sounds like you already know how to do it...   what more can we help you 
with?


On 4/18/2013 1:29 PM, Reggie Acosta - El Monte wrote:
> On v5r4, it's my third time using Scott's HSSFR4 POI36 and I'm stumped. This time the workbook has a second sheet, Summary, and I want to refer to cells in the first sheet, SAB7132. I know in Excel to use formula, ='SAB7132'!D17, for example, in sheet Summary to refer to cell D17 in sheet SAB7132. I know how to use ss_formula() and refer to another cell within the same sheet but I can't figure out how to this other thing.
>
> Thanks,
> Reggie Acosta
> www.brownjordan.com<http://www.brownjordan.com>
>
>
> --
> P Please consider the environment before printing this e-mail.
> CONFIDENTIALITY NOTE: The information contained in this transmission is privileged and confidential information intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this transmission in error, do not read it. Please immediately reply to the sender that you have received this communication in error and then delete it. Thank you.