sc_mjlo@ux63.bath.ac.uk (Miles Osborne) (03/01/88)
I have a couple of queries concerning the spreadsheet calculator program. i) Defining variables - I have realised that these can be defined by directly editing the spreadsheet file- but can they be set whilst in the spreadsheet program and saved afterwards all I seem to be able to do is set them but they won't save when I quit out of the program and I can't seem to change them once they have been set. Also again concerning defining variables when I placed them in the spreadsheet file there did seem to be a limit of about 8 definitions am I correct in that, and if I am is there anyway of getting round that limit. ii) Macros - Can anyone give me a better idea than the man page does on what these should look like and how they can be used. iii) Is there anyway other than the goto command of going down say 20 lines or across 20 lines etc. Well thats just about it I look forward to any comments on the above. -- Miles Osborne | tel : Bath 826982 SWURCC,Bath University, | UUCP:..!uunet!mcvax!ukc!bath63!sc_mjlo Claverton Down,Bath, Avon | England BA2 7AY |
jea@ur-cvsvax.UUCP (Joanne Albano) (03/05/88)
Obviously someone has gotten sc ( from the fish disk #53 , I presume) to work properly. I have tried two copies of this distributed program and found that it doesnt not write the data. Could someone email me a working copy, binary or source. thanks much, joanne =================================================================== Joanne Albano, Center for Visual Science (716) 275-6848 Room 256 Meliora Hall, Univ. of Rochester, Rochester NY 14627 UUCP: ur-cvsvax!jea@rochester.EDU ARPANET: UR-CVSVAX!JEA@ROCHESTER.ARPA -- =================================================================== Joanne Albano, Center for Visual Science (716) 275-6848 Room 256 Meliora Hall, Univ. of Rochester, Rochester NY 14627 UUCP: ur-cvsvax!jea@rochester.EDU ARPANET: UR-CVSVAX!JEA@ROCHESTER.ARPA
rgb@nscpdc.NSC.COM (Robert Bond) (03/08/88)
From article <2227@bath63.ux63.bath.ac.uk>, by sc_mjlo@ux63.bath.ac.uk (Miles Osborne): > I have a couple of queries concerning the spreadsheet calculator program. > > i) Defining variables - I have realised that these can be defined by directly > editing the spreadsheet file- but can they be set whilst in the spreadsheet --- other stuff deleted --- To define a variable called dogfood, which defines a range of a0 through d10, try entering exactly these key strokes: /ddogfood"<space>a0:d10<rtn> where <space> means type a space character and <rtn> means type the return key. You will notice that the leading quotation mark is supplied by the prompt. To see your variable definitions, type /s you will be dumped into less so you can page through them. You need to do a P (put) command to save the variable names. You should not edit the spreadsheet files just to play with variables. To fill the range dogfood with data, type /fdogfood 1 1<rtn> > ii) Macros - Can anyone give me a better idea than the man page does on what > these should look like and how they can be used. > As the README says, the support is primitive. They are just files you M (merge) into the spreadsheet, but I have provided hooks so you can set up a path to the to-be-merged files. The format of the files is the same as the spreadsheet save file format. An obvious enhancement is a mechanism to save keystrokes. A better macro file format would be good too. We used them here to write out summary reports from a spreadsheet and clean up the current working area, ready for next month's data. Here is one of the files: goto A200 erase fcst copy fcst fcst01 write "EXPFCST.P01" expfcst copy recf01 fcstd01 value recf01 goto expfcst As you can see, the macro lives in the context of an application. "recf01", "fcstd01", "fcst01", and "expfcst" are all ranges. "EXPFCST.P01" is a file. You can get an idea of the format of the files by looking at the commands the parser accepts. See gram.y. The reason I did not document this more is I DO NOT want lots of people using it. It is too primitive - I don't want to spend all of my time answering questions about it. I believe the real die-hards will figure it out, and would have done so with the M (merge) command anyway. I expect this paragraph will sink me all by itself. > iii) Is there anyway other than the goto command of going down say 20 lines > or across 20 lines etc. Lots of ways - If you are trying to go down 20, type 20j or 20^n Most of the time what you really want is to get the the first or the end of a range so ^en or w is what you want to do. I would normally have expected a letter like this to come to me directly, rather than posting it to the net. I DO welcome mail about sc and WILL answer it. Even if it is about macros. :-) Good Luck, Bob -- Robert Bond ihnp4!nsc!nscpdc!rgb National Semiconductor tektronix!nscpdc!rgb
rgb@nscpdc.NSC.COM (Robert Bond) (03/08/88)
From article <720@ur-cvsvax.UUCP>, by jea@ur-cvsvax.UUCP (Joanne Albano): > > Obviously someone has gotten sc ( from the fish disk #53 , I presume) > to work properly. I have tried two copies of this distributed > program and found that it doesnt not write the data. Could someone > email me a working copy, binary or source. The version of SC this is talking about was posted to comp.sources.unix last month. See your normal sources archives for info on how to get it. It is 5.1, with a patch posted to comp.sources.buts to bring it up to 5.2. I don't have an AMIGA, and have not tested or used the Fish version of the standard distribution. Bob Bond -- Robert Bond ihnp4!nsc!nscpdc!rgb National Semiconductor tektronix!nscpdc!rgb