📄 ch49_08.htm
字号:
<HTML><!--Distributed by F --><HEAD><TITLE>[Chapter 49] 49.8 It's Great to Have a Spreadsheet </TITLE><METANAME="DC.title"CONTENT="UNIX Power Tools"><METANAME="DC.creator"CONTENT="Jerry Peek, Tim O'Reilly & Mike Loukides"><METANAME="DC.publisher"CONTENT="O'Reilly & Associates, Inc."><METANAME="DC.date"CONTENT="1998-08-04T21:56:43Z"><METANAME="DC.type"CONTENT="Text.Monograph"><METANAME="DC.format"CONTENT="text/html"SCHEME="MIME"><METANAME="DC.source"CONTENT="1-56592-260-3"SCHEME="ISBN"><METANAME="DC.language"CONTENT="en-US"><METANAME="generator"CONTENT="Jade 1.1/O'Reilly DocBook 3.0 to HTML 4.0"><LINKREV="made"HREF="mailto:online-books@oreilly.com"TITLE="Online Books Comments"><LINKREL="up"HREF="ch49_01.htm"TITLE="49. Working with Numbers"><LINKREL="prev"HREF="ch49_07.htm"TITLE="49.7 Total a Column with addup "><LINKREL="next"HREF="ch49_09.htm"TITLE="49.9 Business Graphics with ipl "></HEAD><BODYBGCOLOR="#FFFFFF"TEXT="#000000"><DIVCLASS="htmlnav"><H1><IMGSRC="gifs/smbanner.gif"ALT="UNIX Power Tools"USEMAP="#srchmap"BORDER="0"></H1><MAPNAME="srchmap"><AREASHAPE="RECT"COORDS="0,0,466,58"HREF="index.htm"ALT="UNIX Power Tools"><AREASHAPE="RECT"COORDS="467,0,514,18"HREF="jobjects/fsearch.htm"ALT="Search this book"></MAP><TABLEWIDTH="515"BORDER="0"CELLSPACING="0"CELLPADDING="0"><TR><TDALIGN="LEFT"VALIGN="TOP"WIDTH="172"><ACLASS="SECT1"HREF="ch49_07.htm"TITLE="49.7 Total a Column with addup "><IMGSRC="gifs/txtpreva.gif"SRC="gifs/txtpreva.gif"ALT="Previous: 49.7 Total a Column with addup "BORDER="0"></A></TD><TDALIGN="CENTER"VALIGN="TOP"WIDTH="171"><B><FONTFACE="ARIEL,HELVETICA,HELV,SANSERIF"SIZE="-1">Chapter 49<BR>Working with Numbers</FONT></B></TD><TDALIGN="RIGHT"VALIGN="TOP"WIDTH="172"><ACLASS="SECT1"HREF="ch49_09.htm"TITLE="49.9 Business Graphics with ipl "><IMGSRC="gifs/txtnexta.gif"SRC="gifs/txtnexta.gif"ALT="Next: 49.9 Business Graphics with ipl "BORDER="0"></A></TD></TR></TABLE> <HRALIGN="LEFT"WIDTH="515"TITLE="footer"></DIV><DIVCLASS="SECT1"><H2CLASS="sect1"><ACLASS="title"NAME="UPT-ART-9100">49.8 It's Great to Have a Spreadsheet </A></H2><TABLECLASS="para.programreference"BORDER="1"><TR><THVALIGN="TOP"><ACLASS="programreference"HREF="examples/index.htm"TITLE="sc">sc</A><BR></TH><TDVALIGN="TOP"><ACLASS="indexterm"NAME="AUTOID-58785"></A><ACLASS="indexterm"NAME="AUTOID-58788"></A><ACLASS="indexterm"NAME="AUTOID-58790"></A><ACLASS="indexterm"NAME="AUTOID-58792"></A>Calculators are very good, but nothing beats a spreadsheet when youhave complicated calculations and want to explore, save, and printalternate computational scenarios. After years of waiting to seemainline spreadsheet programs ported to UNIX, I discovered<EMCLASS="emphasis">sc</EM>. </TD></TR></TABLE><PCLASS="para">Try it; you'll like it. Well, maybe not at first, but eventually.It's quite full featured, but has a slightly helter-skelter userinterface with only barebones documentation to help you figure it out.Fortunately, there are built-in quick reference screens available bytyping a question mark (<CODECLASS="literal">?</CODE>), so (especially if you already knowhow to use a spreadsheet), you can learn the basics pretty quickly.</P><PCLASS="para"><ACLASS="indexterm"NAME="AUTOID-58800"></A><ACLASS="indexterm"NAME="AUTOID-58803"></A><ACLASS="indexterm"NAME="AUTOID-58806"></A>A couple of pointers, though: pay attention to the prompts provided bysome of the commands. For example, if they show an argument inquotes, that probably means you'd better type the quotes. (But notbrackets - they indicate an optional argument.) Also, watch for theorder of arguments. (For example, the range copy command takes thedestination range first.)</P><PCLASS="para"><ACLASS="indexterm"NAME="AUTOID-58810"></A>One feature that may be helpful (or may make the interface even moreobscure) is that cursor movement and cell editing commands are basedon the <SPANCLASS="link"><EMCLASS="emphasis">vi</EM> (<ACLASS="linkend"HREF="ch30_02.htm"TITLE="What We Cover ">30.2</A>)</SPAN>command set.</P><PCLASS="para"><ACLASS="indexterm"NAME="AUTOID-58816"></A><ACLASS="indexterm"NAME="AUTOID-58818"></A>While you might wish for a point and click interface like Excel, oreven the keystroke-based menus that make <EMCLASS="emphasis">1-2-3</EM> so easy touse, <EMCLASS="emphasis">sc</EM> has a lot to offer.It lets you do just abouteverything pricier spreadsheets do, including hiding rows or columns,symbolic range or cell names, and a full range of numeric, string,financial and date/time functions.It even lets you encrypt yourspreadsheets for security.</P><PCLASS="para"><ACLASS="indexterm"NAME="AUTOID-58824"></A><ACLASS="indexterm"NAME="AUTOID-58827"></A>Some functions are implemented by<SPANCLASS="link">pipes (<ACLASS="linkend"HREF="ch01_04.htm"TITLE="Using Pipes to Create a New Tool ">1.4</A>)</SPAN>to UNIX commands.Forexample, there's no print command.Instead, you use one of the savecommands (P to save the file in sc format; W to save an image of thescreen), supplying a pipe to the printer as the "filename."Ofcourse, this means that if you know the format of the output stream(which is fairly simple), you can use any available UNIX utilities totransform the data.</P><PCLASS="para">You can't pipe data into <EMCLASS="emphasis">sc</EM>, but you can prepare datawith other programs, and then use the supplied <EMCLASS="emphasis">psc</EM> program toconvert it to <EMCLASS="emphasis">sc</EM> format.</P><DIVCLASS="sect1info"><PCLASS="SECT1INFO">- <SPANCLASS="authorinitials">TOR</SPAN></P></DIV></DIV><DIVCLASS="htmlnav"><P></P><HRALIGN="LEFT"WIDTH="515"TITLE="footer"><TABLEWIDTH="515"BORDER="0"CELLSPACING="0"CELLPADDING="0"><TR><TDALIGN="LEFT"VALIGN="TOP"WIDTH="172"><ACLASS="SECT1"HREF="ch49_07.htm"TITLE="49.7 Total a Column with addup "><IMGSRC="gifs/txtpreva.gif"SRC="gifs/txtpreva.gif"ALT="Previous: 49.7 Total a Column with addup "BORDER="0"></A></TD><TDALIGN="CENTER"VALIGN="TOP"WIDTH="171"><ACLASS="book"HREF="index.htm"TITLE="UNIX Power Tools"><IMGSRC="gifs/txthome.gif"SRC="gifs/txthome.gif"ALT="UNIX Power Tools"BORDER="0"></A></TD><TDALIGN="RIGHT"VALIGN="TOP"WIDTH="172"><ACLASS="SECT1"HREF="ch49_09.htm"TITLE="49.9 Business Graphics with ipl "><IMGSRC="gifs/txtnexta.gif"SRC="gifs/txtnexta.gif"ALT="Next: 49.9 Business Graphics with ipl "BORDER="0"></A></TD></TR><TR><TDALIGN="LEFT"VALIGN="TOP"WIDTH="172">49.7 Total a Column with addup </TD><TDALIGN="CENTER"VALIGN="TOP"WIDTH="171"><ACLASS="index"HREF="index/idx_0.htm"TITLE="Book Index"><IMGSRC="gifs/index.gif"SRC="gifs/index.gif"ALT="Book Index"BORDER="0"></A></TD><TDALIGN="RIGHT"VALIGN="TOP"WIDTH="172">49.9 Business Graphics with ipl </TD></TR></TABLE><HRALIGN="LEFT"WIDTH="515"TITLE="footer"><IMGSRC="gifs/smnavbar.gif"SRC="gifs/smnavbar.gif"USEMAP="#map"BORDER="0"ALT="The UNIX CD Bookshelf Navigation"><MAPNAME="map"><AREASHAPE="RECT"COORDS="0,0,73,21"HREF="../index.htm"ALT="The UNIX CD Bookshelf"><AREASHAPE="RECT"COORDS="74,0,163,21"HREF="index.htm"ALT="UNIX Power Tools"><AREASHAPE="RECT"COORDS="164,0,257,21"HREF="../unixnut/index.htm"ALT="UNIX in a Nutshell"><AREASHAPE="RECT"COORDS="258,0,321,21"HREF="../vi/index.htm"ALT="Learning the vi Editor"><AREASHAPE="RECT"COORDS="322,0,378,21"HREF="../sedawk/index.htm"ALT="sed & awk"><AREASHAPE="RECT"COORDS="379,0,438,21"HREF="../ksh/index.htm"ALT="Learning the Korn Shell"><AREASHAPE="RECT"COORDS="439,0,514,21"HREF="../lrnunix/index.htm"ALT="Learning the UNIX Operating System"></MAP></DIV></BODY></HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -