|
|
NeoCalc
From NeoWiki
(Difference between revisions)
| Revision as of 19:53, 23 April 2008 (edit) Lorinda (Talk | contribs) (→External Calc Tips - add a Solveig blog post on sorting) ← Previous diff |
Revision as of 19:58, 23 April 2008 (edit) (undo) Lorinda (Talk | contribs) (Consolidate two separate external tips sections) Next diff → |
||
| Line 54: | Line 54: | ||
| ==External 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 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://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/using-names-to.html Using Names in Formulas] a blog post by Solvieg Haugland. | *[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. | *[http://www.linuxjournal.com/node/1005895 Basic arithmetic and statistic functions] article by Bruce Byfield. | ||
| *[http://openoffice.blogs.com/openoffice/2008/04/sorting-data-in.html Sorting Data in Calc] by Solvieg Haugland. | *[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://www.linuxjournal.com/node/1005895 Basic arithmetic and statistic functions] by Bruce Byfield<br> | ||
| ==Documentation, Tutorials, etc.== | ==Documentation, Tutorials, etc.== | ||
| Line 72: | Line 84: | ||
| [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=== | ||
| - | ''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://www.linuxjournal.com/node/1000252 Pivot Tables by Another name] by Bruce Byfield | ||
| - | :OpenOffice's Data Pilot function.<br> | ||
| - | [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://www.linuxjournal.com/node/1005895 Basic arithmetic and statistic functions] by Bruce Byfield<br> | ||
| - | [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]. | ||
| ==Sources of Calc Templates== | ==Sources of Calc Templates== | ||
Revision as of 19:58, 23 April 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
- Inserting a line break in a cell
- Selecting and filling a range of cells
- Performing Addition with Time-Formatted Cells in Calc
- Adding multiple rows or columns to a spreadsheet
- Merging Columns in NeoOffice Calc
- Reversing Rows and Columns in a Spreadsheet
- 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 Calc charts or spreadsheets as images
- Importing HTML tables into a Calc document
- Importing and Exporting Comma and Tab Delimited Files
Charts and Graphs in Calc
- Computing and graphing a regression line
- Creating a Gantt Chart
- Plotting Curves in Calc
- Inserting a Chart from NeoOffice Calc (Using a Calc chart as an OLE)
- Exporting Calc charts or spreadsheets as images
Database Functions in Calc
- Database Functions in Calc
- Using a Calc spreadsheet as a data source (NeoOffice 2.x)
Formulas and Functions
- Parsing Names in NeoOffice Calc
- Using the Solver function
- Text 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
- Protecting a Document, a Sheet or Cells in Calc
- Changing the Data Range of a Chart
- Number Formats in NeoOffice Calc
- Printing Spreadsheets
- Creating Calc Templates
- Inserting a Fixed Timestamp in Calc
- Adding Controls in a Spreadsheet
External Calc Tips
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.
- 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.
- Using Names in Formulas a blog post by Solvieg Haugland.
- Basic arithmetic and statistic functions article by Bruce Byfield.
- Sorting Data in Calc by Solvieg Haugland.
- Pivot Tables by Another name (OpenOffice's Data Pilot function) by Bruce Byfield
- 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
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).
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.
