At 13:25 24/11/2014 -0800, Fred Conly wrote:
Tell me, what does $SPH or SSPH, it's hard to distinguish which, that appears before a Data Range and what does it do?
The "SPH" will be the sheet name and qualifies the call range to indicate which sheet in the spreadsheet is being referred to. The $ sign will have its usual function of freezing the reference against automatic changes when copied or filled.
Brian Barker
--------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
