Article View: comp.sys.mac
Article #628Re: USERS OF MS EXCEL -> Wingz
From: Kevin O'Gorman
Date: Sun, 25 Jun 1989 16:04
Date: Sun, 25 Jun 1989 16:04
45 lines
2960 bytes
2960 bytes
In article <796@kosman.UUCP> I write:
For one thing, I use a number of spreadsheets
in different folders, with a couple of master sheets that are linked to
the scattered detail sheets. As near as I can tell, you can't link
spreadsheets at all in Wingz.
In article <1604@infmx.UUCP> cortesi@infmx.UUCP (David Cortesi) writes:
It may not be exactly what you want, but any expression may refer to
the value of a cell in any other open spreadsheet, so that "Sales:C20"
is that cell in the sheet named Sales. The catch is that the other sheets
have to be open at the same time; Wingz won't go get them.
But if a group was always used together you could start work by dragging
a Finder rectangle around them and double-clicking...
Not a solution: remember my sheets are in different folders, and you can't
do that trick across folders. Besides, there's quite a few of them
scattered about, and the whole reason this looks like a useful thing to do is
that I don't have to think about where the other sheets are or what they
are unless I'm working with their data. Also, where is this documented?
I can't find linking in the index, and I'm not sure what else to look for.
In article <796@kosman.UUCP> I write:
The other thing is that some of my spreadsheets are HUGE. Of course,
Wingz can handle the size, but when I'm in the midst of the sheet, I
can't see the row and column heads. In Excel, I handle this by splitting
the window. I can't see a way to do that in Wingz.
In article <1604@infmx.UUCP> cortesi@infmx.UUCP (David Cortesi) writes:
Again it's not exactly the same thing, but you can open multiple windows
onto any sheet and drag and resize them, so you could open a window
showing just column heads and then overlap it with a window in which
you scroll to the detail rows. (And other windows on other sections
of your HUGE sheet, in sizes & shapes as you want...)
Oh. I didn't try that. It still sounds like an awkward solution, though,
because the headings won't scroll as I navigate in the "entry" window.
Plus, I would need two windows of headings so that I could navigate
independently along both margins. The size of the toolbox means this would
cost a lot of real estate, but I do have a 19" monitor, so it sort of fits.
Overall, it's a possible kludge.
Without a solution to the first problem, though, I'm afraid Wingz goes on
the shelf for now.
Technical Details
Message-ID:
<798@kosman.UUCP>Path:
arc1-ca.pugleaf.net!utzoo!attcan!uunet!lll-winken!ames!apple!usc!csun!srhqla!kosman!kevinReferences:
<10@<Jun> <8400119@m.cs.uiuc.edu> <24871@shemp.CS.UCLA.EDU> <796@kosman.UUCP> <1604@infmx.UUCP>Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!utzoo!attcan!uunet!lll-winken!ames!apple!usc!csun!srhqla!kosman!kevin From: kevin@kosman.UUCP (Kevin O'Gorman) Newsgroups: comp.sys.mac Subject: Re: USERS OF MS EXCEL -> Wingz Message-ID: <798@kosman.UUCP> Date: 25 Jun 89 16:04:35 GMT References: <10@<Jun> <8400119@m.cs.uiuc.edu> <24871@shemp.CS.UCLA.EDU> <796@kosman.UUCP> <1604@infmx.UUCP> Reply-To: kevin@kosman.UUCP (Root) Organization: K.O.'s Manor - Vital Computer Systems, Oxnard, CA 93035 Lines: 45