Classifieds Business Directory Jobs Real Estate Autos Legal Notices Forums Subscribe Archives
Today is February 21, 2017
home news sports feature opinion happenings society obits techtips

Front Page » December 13, 2005 » Tech Tips » 2.0 Calc
Published 4,088 days ago 2.0 Calc

Print PageEmail PageShareGet Reprints

Sun Advocate/Progress Webmaster

Spreadsheets are very common in the computing world, especially among the business community. Spreadsheets have many uses, from calculating basic amortization schedules and analyzing budgets to general statistics. As a spreadsheet application, Calc will do all these things, and more.

Like its commercial alternatives, Calc can generate colorful charts & graphs to reflect different kinds of quantitative information, which are great for visual comparison. It also has strong mathematical, statistical and logistical analysis capabilities. Calc has a strong Microsoft Excel influence. Visually, the program shares the same look and feel as Excel. Many of Calc's tools are positioned in similar places, and many of the keyboard hot-keys are the same. Navigation among rows, columns and cells highly similar as well. Calc shares strong consistency with other applications, particularly with toolbar content and icon placement.

Calc's built-in functions use the same names and syntax as those in Microsoft Excel, for best compatibility. For example, both Calc's and Excel's functions begin with an equal sign (=). Both programs name their standard deviation function stdev. Both program's fv (future value) functions take the same set of parameters (which happen to follow in the same order).

As a result, compatibility between Calc and Microsoft Excel is outstanding, and makes Calc a viable alternative because it means Calc users can stay interoperable with the majority of the computing world.

The biggest lack of compatibility with Excel is in macros. This is because Calc does not use Visual Basic to power its macros, as Excel does. Instead, it uses its own macro scripting language, Basic. Although Calc can interpret some Excel macros, complex macros may not function properly, or function at all.

Like any modern spreadsheet application, multiple sheets can be created, renamed or reordered via the tabs at the bottom of the program.

Some have criticized Calc because it does not use Visual Basic, and quick label it an inadequacy. On the contrary! By using an open language that isn't specific to Windows, Calc macros can be played or executed on virtually any platform (Linux, Windows, OS-X, etc.).

Like its other siblings, Calc uses the OASIS OpenDocument file format by default. Unlike the Excel format, OpenDocument is not specific to any one piece of software, or controlled by any single vendor - it is a truly open standard. However, the program can be configured so new documents will be automatically saved as "Microsoft Excel 97/2000/XP" files - useful for those that frequently share files with Microsoft Office users. This setting can be found by selecting "Options" from the "Tools" menu at the top. Once the options box appears, expand the "Load/Save" section and select "General." Under "Document type," select "Spreadsheet" from the first drop-down box, and select "Microsoft Excel 97/2000/XP" from the next drop-down box.

Another great thing about Calc is its database connectivity, supporting both ODBC (Open Database Connectivity) and JDBC (Java Database Connectivity) standards. This gives Calc the ability to analyze sources of information stored outside the actual spreadsheet - in a database server, for example.

Various charts (pie, scatter plot, bar graghs, etc) can be inserted into the spreadsheet for visual representation.

Like Writer, Calc also has an "Export to PDF" feature. Once the PDF has been created, it can be opened in any PDF-compatible reader, like Adobe's free Acrobat Reader.

Calc also makes use of styles, like Writer, which can be applied, edited or managed via the Stylist (F11 key).

For many, Calc provides everything they will ever need in a spreadsheet. It can be downloaded, free of charge, from

Have comments or suggestions for a weekly Tech Tips article? Send an email to

Note: The Sun Advocate and Emery County Progress do not necessarily endorse the opinions of the author.

Print PageEmail PageShareGet Reprints

Top of Page

Tech Tips  
December 13, 2005
Recent Tech Tips
Quick Links
Subscribe via RSS
Related Articles  
Related Stories

Best viewed with Firefox
Get Firefox

© Emery County Progress, 2000-2008. All rights reserved. All material found on this website, unless otherwise specified, is copyright and may not be reproduced without the explicit written permission from the publisher of the Emery County Progress.
Legal Notices & Terms of Use    Privacy Policy    Advertising Info    FAQ    Contact Us
  RSS Feeds    News on Your Site    Staff Information    Submitting Content    About Us