Path: 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@ <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 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.