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

Apps/Gnumeric/Features (last edited 2013-12-21 20:44:15 by MortenWelinder)