Brian:
Thanks again. The name SPH must be assigned by OO Calc
because it's nothing I named. Also "SPH." preceeds each Data Range
from Column A, which contains the x-axis data, and columns C, D,
and E which contain the data charted. The prolific use of $ is
unnecessary and confusing in this case.
I will try again now knowing what this hieroglyphic means.
Fred
On 11/24/14 2:56 PM, Brian Barker wrote:
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
