NeoCalc

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 04:04, 11 January 2008 (edit)
Lorinda (Talk | contribs)
(Tips on Other Websites and Blogs - add link on arithmetic functions)
← Previous diff
Revision as of 12:42, 21 January 2008 (edit) (undo)
Lorinda (Talk | contribs)
(create Template section; move one link; add OATBRAN link)
Next diff →
Line 44: Line 44:
* [[Number Formats in NeoOffice Calc]] * [[Number Formats in NeoOffice Calc]]
* [[Printing Spreadsheets]] * [[Printing Spreadsheets]]
-* [http://documentation.openoffice.org/Samples_Templates/User/template_2_x/calc/index.html Templates for Calc] 
<br> <br>
Line 70: Line 69:
[http://www.richhillsoftware.com/oootips1.html OpenOfficeTips.com] [http://www.richhillsoftware.com/oootips1.html OpenOfficeTips.com]
:OpenOffice.org tips (mostly for Calc) by David Chapman. The link is to the index on his old site. His new site is [http://www.openofficetips.com/ openofficetips.com]. :OpenOffice.org tips (mostly for Calc) by David Chapman. The link is to the index on his old site. His new site is [http://www.openofficetips.com/ openofficetips.com].
 +
 +==Sources of Calc Templates==
 +* [http://documentation.openoffice.org/Samples_Templates/User/template_2_x/calc/index.html from the OpenOffice.org website]
 +*[http://www.coventry.ac.uk/ec/~nhunt/oatbran/ OATBRAN] Online Analysis Tools By Rodney And Neville. xls files designed to replicate the Data Analysis Toolpack without macros. The formulas work in NeoOffice, but the charts are empty.
{{botlangbarEN|[[Fr:NeoOffice Calc |Français]] [[It:NeoCalc|Italiano]]}} {{botlangbarEN|[[Fr:NeoOffice Calc |Français]] [[It:NeoCalc|Italiano]]}}
[[Category:NeoOffice]] [[Category:NeoOffice]]

Revision as of 12:42, 21 January 2008

NeoCalc is the spreadsheet component of NeoOffice. Calc documents can contain multiple sheets of data. A vast array of mathmatical, financial, statisticual and logical functions can be combined for simple to complex calculations. Calc provides basis "flat" database capabilities, "what if" calculations, and updatable charts based on a range of data.

The wiki includes a NeoOffice Feature Comparison with Microsoft Word and OpenOffice.org and a list of supported file formats for Calc and the other components of NeoOffice.


Contents

Tips and Hints in the Wiki

Note that additional tips can be found on the New Articles Needed page, which contains links to stub pages and/or threads in trinity that need to be developed into full blown articles.

Working with Cells, Rows, and Columns

Exporting and Importing with Calc

Charts and Graphs in Calc

Database Functions in Calc

Other Calc Tips


Documentation, Tutorials, etc.

More resources that cover all the components of NeoOffice, include Calc, can be found on the Documentation and Related Resources page.

User Guides, etc.

Chapter 4 of the NeoOffice User Guide.
OOoAuthors Calc Guide links to download the various chapters. Not all chapters are finished, so it is not yet possible to download the entire guide in one document.

Print And/Or E-Books Available for Purchase

Learn OpenOffice.org Spreadsheet Macro Programming: OOoBasic and Calc automation by Dr. Mark Alexander Bain. Look for a the link to download a sample chapter (On working with Databases).

Tips on Other Websites and Blogs

These articles are usually on specific features of Calc. Most if not all are written for OpenOffice.org. Remember that aright click is the same as a control-click, and use the Command key on your Mac when instructions for OpenOffice.org call for the control key.

Pivot Tables by Another name by Bruce Byfield

OpenOffice's Data Pilot function.

Options in OpenOffice Calc by Bruce Byfield

"A summary of the configuration choices, tips, and tricks for OpenOffice.org's spreadsheet program."

Basic arithmetic and statistic functions by Bruce Byfield
OpenOfficeTips.com

OpenOffice.org tips (mostly for Calc) by David Chapman. The link is to the index on his old site. His new site is openofficetips.com.

Sources of Calc Templates

  • from the OpenOffice.org website
  • OATBRAN Online Analysis Tools By Rodney And Neville. xls files designed to replicate the Data Analysis Toolpack without macros. The formulas work in NeoOffice, but the charts are empty.


This article in other languages: Français Italiano
Personal tools