Features

Core capabilities

• Functions
  • 100% of the worksheet functions in MS Excel (tm)
  • 214 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