Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions

  




 

 

10.3.2. Gnumeric

Gnumeric is a spreadsheet optimized for the GNOME desktop.
Start Gnumeric by clicking on Applications > Office > Gnumeric Spreadsheet in GNOME or the Kickoff Application Launcher > Applications > Office > Spreadsheet menu entry for Gnumeric in KDE.
Major functions of the top menu are:
File
lets you create New documents, Open , Save , Page Setup , Set , Clear and Show the Print Area . File also provides options to Print , Send To an email address, view and add to the program's Properties , set Preferences , access a Full History , and Close a file, or Quit the program.
Edit
allows you to Undo and Redo actions, Cut , Copy , and Paste and Fill , Clear , and Delete Rows , Columns , and Cells . Edit also provides options to Find , Replace or Goto a Cell , manage the Sheets , Select various ranges in the spreadsheet, and Recalculate .
View
allows you to create a New View of the workbook, to Freeze Panes , select a different Workbook , choose Toolbars , View Statusbar , Full Screen and Zoom in and out.
Insert
lets you insert Cells , Columns , Rows , Charts , Images , Functions , Names , Comments , Hyperlinks and Special fields such as Current Date , Current Time and Current date and time .
Format
lets you format the Cells , Rows , Columns , Sheets and Workbook can be formatted and Preferences changed. Use Autoformat to format a region of cells according to a pre-defined template.
Tools
provides Auto Correct , Auto Save , Goal Seek , Solver , View and Add Scenarios , Simulation , Statistical Analysis and manage Plug-ins .
Data
allows manipulation of the data such as Sort , Filter , Validate , Consolidate , create a Table , Group and Outline , convert Text to Columns and Get External Data .
Help > Contents
opens the Gnumeric help manual (as does the F1 key), Gnumeric on the Web , Live Assistance , and Report a Problem .
The row of icons under the top menu bar contains the most frequently used functions that are listed in the top menu.
The third menu panel allows you to configure the appearance of your data, such as font selection, alignment, font, bullets, indentations, bolding, and italics.
The fourth panel shows the address of the cell you are pointing to and the data window shows what the cell contains.
The panel at the bottom of the spreadsheet shows which spreadsheet is currently selected, how many worksheets are in the file, and a function's result in the cell to which you are of the cell you are pointing. You can add or change a worksheet by:
  • a right mouse click on one of the tabs, then choosing from the menu.
    clicking on Edit > Sheet in the top menu.
A tutorial on using Gnumeric is available from http://projects.gnome.org/gnumeric/doc/chapter-quick-start.shtml.

 
 
  Published under the terms of the Open Publication License Design by Interspire