Gnumeric

The Gnumeric spreadsheet is part of the GNOME desktop environment: a project to create a free, user friendly desktop environment.

Gnumeric has the ability to import and export data in several file formats, including CSV, Microsoft Excel, HTML, LaTeX, Lotus 1-2-3, OpenDocument and Quattro Pro; its native format is the Gnumeric file format, an XML file compressed with gzip. It includes all of the spreadsheet functions of the Microsoft Excel and many functions unique to Gnumeric. Pivot tables are not yet supported but are planned for future versions.

Gnumeric 1.8.2

Price Free to download Size 13MB License General Public License Developer The GNOME Project Website www.gnome.org System Requirements glib >=2.6.4 gtk+ >=2.10.0 pango >=1.8.1 libgnomeprint >=2.8.2 libgsf >=1.14.2 GOffice >=0.4.0 (Full list at above website).   Support Sites: Gnumeric Footnotes, troubleshooters.com, Interview with Jody Goldberg (project leader), Mailing List Selected Reviews: open-mag.com, Newsforge

Features include:

• Core capabilities
• Functions
• 100% of the worksheet functions in MS Excel (tm)
• 154 functions not found in MS Excel (tm)
• Basic support for financial derivatives (Black Scholes)
• Basic support for telecommunication engineering
• Analytics
• Advanced Statistical analysis
• Extensive Random Number generation
• Linear and Non-linear solvers
• Computation
• Inter sheet dependencies
• 3D dependencies
• Implicit intersection
• Implicit iteration
• Dynamic dependencies
• User defined names (for ranges and functions)
• Arrays values and formulas
• Misc
• Summary information
• Cell contents
• Toolbar for common operations
• Zoom
• Multiple Views
• AutoFilter
• Goal Seek to determine break-even points
• Tabulation tools (mail merge for spreadsheets)
• Monte Carlo simulation tools
• Hyper Links
• Validation
• Protection
• Sheet objects
• Lines, Arrows, ellipses, squares
• Buttons, Scrollbars, Checkboxes
• Images, Charts
• Printing
• Cell contents
• Style information
• Per sheet printer setups
• Print preview
• Print options
• Page orientation
• 6 margins + paper size
• Headers + footers
• Grid lines, comments, headings
• Print order
• Formats
• All builtin Excel-like formats: number, currency, accounting, date, time, percentage, fraction, scientific, text, special
• Compatible format description language
• Styles
• Borders - outer and inner, colors, diagonals, 13 line types
• Colors - foreground, background, 18 pattern types
• Fonts - font name, size, style (bold/italic), color
• Horizontal alignments - general, left, right, center, fill, justify, center across selection
• Vertical alignments - top, center, bottom, justify
• Cell Merging, spanning, and wrapping
• Charting
• Pie plots
• Ring plots
• Bar/Col plots
• Autofill
• Autofill for various sequences is supported
• Automatic guessing of input
• Gnumeric will try to parse user entered input as a number with a format applied (so you can enter dates directly, and they will be stored as a number + a format to render it).
• International
• Gnumeric has been localized to various languages, and we welcome new contributions. It handles numeric formats properly for various countries and languages.
• Import filters
• XML (gnumeric format)
• MS Excel (tm) 2,3,4,5,95,97,2k,XP
• Applix (4, 5)
• HTML (various)
• CSV (comma separated values)
• Lotus 1-2-3 .wk1 format
• GNU oleo (rudimentary)
• Quattro Pro
• OpenOffice (sxc, not the older binary format)
• Export filters
• XML (gnumeric format)
• MS Excel (tm) 5,95,97,2k,XP (including dual stream)
• HTML (3.2, 4, xhtml)
• LaTeX, Troff
• PDF, EPS, DVI
• CSV
• Batch Processing
• Translation from one file format to another

Last Updated Friday, April 25 2008 @ 07:34 PM EDT