Thoughtful, detailed coverage of the Mac, iPhone, and iPad, plus the best-selling Take Control ebooks.

 

 

Pick an apple! 
 
Shorten URLs in TextExpander

If your Twitter client doesn't automatically shorten URLs for you, you can use TextExpander to shrink those long links to tweetable lengths. First, add the Internet Productivity group by choosing File > Add Predefined Group > Internet Productivity Snippets. Then, to shorten a URL using a service like TinyURL, copy the destination URL to the clipboard, and type the abbreviation /tinyurl to insert the shortened URL at the insertion point.

Visit Smile

 
 

Spreadsheet and Charting

Send Article to a Friend

In many ways, the spreadsheet document type/tool is the best part of the ClarisWorks package.

The spreadsheet is a fully functional - and fairly friendly - number crunching and presentation tool. It's at about the Excel 2.0-2.1 level without any of Microsoft's funky interface weirdness. Although the macro feature does not allow true scripting, the recordable macros combined with the 101 built-in functions will more than suffice for most office work and student work in the social sciences or in introductory natural science classes. It's not quite as powerful as the shareware BiPlane spreadsheet, but its linking features and smooth interface make it a better bet.

ClarisWorks smoothly integrates spreadsheet frames throughout the whole application. Frames can be linked to one another like text frames, and ClarisWorks automatically links them to any included charts. Creating a chart is simply a matter of selecting the data and choosing from one of seven chart types (pie, bar/histogram, stacked bar/histogram, line with multiple graphs, scatter, x-y scatter, and x-y line). All charts can be done in color and several in 3D. The charting dialog is simple and easy to use - almost too simple for those accustomed to describing graphing options by name. Limited legend and axis options can be accessed for each graph from a single dialog box. ClarisWorks displays all chart types graphically rather than via menus. Changing linked spreadsheet data quickly updates dependent charts, and charts automatically turn into graphics objects, ready for annotation. The charting features resemble those of CricketGraph without the lousy Cricket interface.

 

READERS LIKE YOU! Support TidBITS by becoming a member today!
Check out the perks at <http://tidbits.com/member_benefits.html>
Special thanks to Whitney McBee, Allen Clark, David Bogart, and Daniel
Fitzgerald for their generous support!