To further illustrate Brian's points, try this: Right-click on the sheet tab "SPH"; from the context menu, choose "Rename Sheet..." In the dialog, type "Single Point Hats" or whatever other name suits you. Click "OK". Now check your data ranges again. You'll find that instead of "SPH" or "$SPH", it will read instead, "Single Point Hats" or "$Single Point Hats."
See? You named the sheet. Or, whoever you received the sheet from did it. And you can change it if the existing name is too cryptic to suit you. If you choose to change the data range, be sure to include the name of the sheet. Jim Plante On Nov 24, 2014, at 10:43 PM, Brian Barker <b.m.bar...@btinternet.com> wrote: > > > 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, Sheet1 etc. are indeed the default names. Someone thought > better. > >> I understand what you say about multiple sheet references. In this case >> there is only one sheet of Data and one sheet of Chart. > > Until you add another. Calc cannot know you won't. You cannot know you won't. > > Brian Barker > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
