At 18:40 24/11/2014 -0800, Fred Conly wrote:
Why anyone would use the designation SPH to refer to Sheet n is
incomprehensible; ...
No doubt it stands for something to do with the spreadsheet's
purpose. Ask the author. Oh, look: that's you.
... why not, for example, SHn?
As I mentioned, Sh
Brian:
Thanks again.
Why anyone would use the designation SPH to refer to
Sheet n is incomprehensible; why not, for example, SHn?
I understand what you say about multiple sheet references.
In this case there is only one sheet of Data and one sheet of
Chart.
Fred
On 11/24/14 5:13 P
At 16:07 24/11/2014 -0800, FC wrote:
The name SPH must be assigned by OO Calc because it's nothing I named.
Hardly likely: it's the name you (or someone) gave to the sheet -
shown on the tab at its bottom left. The default names are Sheet1,
Sheet2, and so on.
Also "SPH." precedes each Data
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
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
Brian:
Thanks for trying to help. Tell me, what does
$SPH or SSPH, it's hard to distinguish which, that
appears before a Data Range and what does it do?
Fred
On 11/24/14 4:33 AM, Brian Barker wrote:
At 20:19 23/11/2014 -0800, Fred Conly wrote:
I used your second suggestion [adjusting th
At 20:19 23/11/2014 -0800, Fred Conly wrote:
I used your second suggestion [adjusting the data ranges to include
column headers] and I could produce labels for two of the three
columns. Strangely, I could not produce the third and I can't figure out why.
Do you mean that you couldn't adjust on
