NeoCalc

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 02:50, 6 January 2008 (edit)
Sardisson (Talk | contribs)
m (Other Calc Tips - renamed page)
← Previous diff
Current revision (10:05, 5 September 2011) (edit) (undo)
( | contribs)
m (User Guides, etc.)
 
(25 intermediate revisions not shown.)
Line 16: Line 16:
* [[Reversing Rows and Columns in a Spreadsheet]] * [[Reversing Rows and Columns in a Spreadsheet]]
* [[Listing Unique Items in a Cell Range]] * [[Listing Unique Items in a Cell Range]]
 +* [[Automatic Coloring of Odd and Even Rows]]
 +* [[Dragging and Dropping a Cell Range]]
===Exporting and Importing with Calc=== ===Exporting and Importing with Calc===
* [[Exporting Calc charts or spreadsheets as images]] * [[Exporting Calc charts or spreadsheets as images]]
* [[Importing_HTML_Tables_into_a_Calc_Document|Importing HTML tables into a Calc document]] * [[Importing_HTML_Tables_into_a_Calc_Document|Importing HTML tables into a Calc document]]
-* [[Importing and Exporting Comma and Tab Delimited Files|Importing and Exporting Comma and Tab Delimited Files]]+** See the section titled [[Importing_HTML_Tables_into_a_Calc_Document#Opening auto-generated xls files in Calc|Opening auto-generated xls files in Calc]] if you are having trouble with an <code>xls</code> file opening in Writer instead of Calc.
 +* [[Importing and Exporting Comma and Tab Delimited Files|Importing and Exporting Comma and Tab Delimited Files and Fixed-Width ASCII Files]]
===Charts and Graphs in Calc=== ===Charts and Graphs in Calc===
Line 28: Line 31:
* [[Inserting a Chart from NeoOffice Calc]] (Using a Calc chart as an OLE) * [[Inserting a Chart from NeoOffice Calc]] (Using a Calc chart as an OLE)
* [[Exporting Calc charts or spreadsheets as images]] * [[Exporting Calc charts or spreadsheets as images]]
 +* [[Changing the Data Range of a Chart]]
===Database Functions in Calc=== ===Database Functions in Calc===
Line 33: Line 37:
* [[Using a Calc spreadsheet as a data source]] (NeoOffice 2.x) * [[Using a Calc spreadsheet as a data source]] (NeoOffice 2.x)
-===Other Calc Tips===+===Formulas and Functions===
-* [[Converting a Text String to a Number in Calc]]+Be sure to see the [[#External Calc Tips|External Tips]] section below for links to comprehensive lists of formulas and functions.
-* [[Inserting and Editing Notes in Calc|Inserting and Editing Notes in Calc]]+ 
* [[Parsing Names in NeoOffice Calc]] * [[Parsing Names in NeoOffice Calc]]
* [[Using the Solver Function|Using the Solver function]] * [[Using the Solver Function|Using the Solver function]]
* [[Text Functions in Calc]] * [[Text Functions in Calc]]
* [[SUMIF and SUMPRODUCT Functions in Calc]] * [[SUMIF and SUMPRODUCT Functions in Calc]]
 +
 +===Other Calc Tips===
 +* [[Converting a Text String to a Number in Calc]]
 +* [[Inserting and Editing Notes in Calc|Inserting and Editing Notes in Calc]]
* [[Protecting a Document, a Sheet or Cells in Calc]] * [[Protecting a Document, a Sheet or Cells in Calc]]
-* [[Changing the Data Range of a Chart]] 
* [[Number Formats in NeoOffice Calc]] * [[Number Formats in NeoOffice Calc]]
-* [http://documentation.openoffice.org/Samples_Templates/User/template_2_x/calc/index.html Templates for Calc]+* [[Printing Spreadsheets]]
- +* [[Creating Calc Templates]]
 +* [[Inserting a Fixed Timestamp in Calc]]
 +* [[Adding Controls in a Spreadsheet]]
<br> <br>
 +
 +==External Calc Tips==
 +''These articles are usually on specific features of Calc. Most if not all are written for OpenOffice.org. Remember that a right 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.''
 +
 +===Formulas and Functions===
 +
 +*[http://documentation.openoffice.org/manuals/oooauthors2/0314CG-DescriptionOfFunctions.pdf Description Of Functions] a PDF from the OOO Authors group.
 +
 +*[http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_listed_by_category Calc Functions Listed by Category] from the OpenOffice.org wiki.
 +
 +*[http://openoffice.blogs.com/openoffice/2008/04/using-names-to.html Using Names in Formulas] a blog post by Solvieg Haugland.
 +
 +*[http://www.linuxjournal.com/node/1005895 Basic arithmetic and statistic functions] article by Bruce Byfield.
 +
 +===Miscellaneous===
 +
 +*[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].
 +
 +*[http://openoffice.blogs.com/openoffice/2008/04/sorting-data-in.html Sorting Data in Calc] by Solvieg Haugland.
 +
 +*[http://www.linuxjournal.com/node/1000252 Pivot Tables by Another name] (OpenOffice's Data Pilot function) by Bruce Byfield
 +
 +*[http://www.linuxjournal.com/node/1000243 Options in OpenOffice Calc] by Bruce Byfield
 +*:"A summary of the configuration choices, tips, and tricks for OpenOffice.org's spreadsheet program."
 +
 +*[http://openoffice.blogs.com/openoffice/2008/02/different-page.html Pages Styles in NeoCalc] by Solveig Haugland
==Documentation, Tutorials, etc.== ==Documentation, Tutorials, etc.==
Line 53: Line 89:
===User Guides, etc.=== ===User Guides, etc.===
[http://sally.neooffice.org/neojava_userguide/userguide/NEO_2_chapter_4_v_0_9.odt Chapter 4] of the NeoOffice User Guide.<br> [http://sally.neooffice.org/neojava_userguide/userguide/NEO_2_chapter_4_v_0_9.odt Chapter 4] of the NeoOffice User Guide.<br>
-[http://oooauthors.org/en/authors/userguide2/published/cg_published 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.+[http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Chapters OpenOffice.org 3.2 Calc Guide]
<br/> <br/>
===Print And/Or E-Books Available for Purchase=== ===Print And/Or E-Books Available for Purchase===
-[http://www.packtpub.com/openoffice-ooobasic-calc-automation/book 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).+*[http://www.packtpub.com/openoffice-ooobasic-calc-automation/book 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===+===Tutorials===
-''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.''+*[http://tutorialsforopenoffice.org/category_index/spreadsheet.html Tutorials For OpenOffice Calc Tutorials]
 +A series of tutorials that can be read on-line or downloaded in OpenOffice.org (and thus NeoOffice) formats. The [http://tutorialsforopenoffice.org/tutorial/Spreadsheet_Basics.html Spreadsheet Basics] section is an excellent starting point for individuals who are new to spreadsheets.
-[http://www.linuxjournal.com/node/1000252 Pivot Tables by Another name] by Bruce Byfield +==Sources of Calc Templates==
-:OpenOffice's Data Pilot function.<br>+* [http://documentation.openoffice.org/Samples_Templates/User/template_2_x/calc/index.html from the OpenOffice.org website]
-[http://www.linuxjournal.com/node/1000243 Options in OpenOffice Calc] by Bruce Byfield+*[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.
-:"A summary of the configuration choices, tips, and tricks for OpenOffice.org's spreadsheet program."+
-[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].+
-{{botlangbarEN|[[Fr:NeoOffice Calc |Français]] [[It:NeoCalc|Italiano]]}}+{{botlangbarEN|[[Fr:NeoOffice Calc |Français]] [[It:NeoCalc|Italiano]] [[Nl:NeoCalc|Nederlands]]}}
[[Category:NeoOffice]] [[Category:NeoOffice]]

Current revision

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

Formulas and Functions

Be sure to see the External Tips section below for links to comprehensive lists of formulas and functions.

Other Calc Tips


External Calc Tips

These articles are usually on specific features of Calc. Most if not all are written for OpenOffice.org. Remember that a right 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.

Formulas and Functions

Miscellaneous

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.
  • Options in OpenOffice Calc by Bruce Byfield
    "A summary of the configuration choices, tips, and tricks for OpenOffice.org's spreadsheet program."

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.
OpenOffice.org 3.2 Calc Guide

Print And/Or E-Books Available for Purchase

Tutorials

A series of tutorials that can be read on-line or downloaded in OpenOffice.org (and thus NeoOffice) formats. The Spreadsheet Basics section is an excellent starting point for individuals who are new to spreadsheets.

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 Nederlands
Personal tools