NeoCalc

From NeoWiki

Revision as of 22:20, 29 July 2007 (edit) Lorinda (Talk | contribs) ← Previous diff		Revision as of 20:05, 30 July 2007 (edit) (undo) Jgd (Talk | contribs) (botlangbar -> Fr) Next diff →
Line 44:		Line 44:
	<br/>		<br/>
		+	{{botlangbarEN|[[Fr:NeoOffice Calc |Français]]}}
	[[Category:NeoOffice]]		[[Category:NeoOffice]]

---

Revision as of 20:05, 30 July 2007

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.

Contents 1 Tips and Hints in the Wiki 1.1 Working with Cells, Rows, and Columns 1.2 Exporting and Importing with Calc 1.3 Charts and Graphs in Calc 1.4 Database Functions in Calc 1.5 Other Calc Tips 2 Documentation, Tutorials, etc. 2.1 User Guides, etc.

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

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

Database Functions in Calc

• Database Functions in Calc
• Using a Calc spreadsheet as a data source (NeoOffice 2.x)

Other Calc Tips

• Converting a Text String to a Number in Calc
• Inserting and Editing Notes in Calc
• Using the Solver function
• Templates for Calc

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.