🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.mac
Article #628

Re: USERS OF MS EXCEL -> Wingz

#628
From: Kevin O'Gorman
Date: Sun, 25 Jun 1989 16:04
45 lines
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!kevin
References: <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