Spread32

From TotalcmdWiki
Jump to navigation Jump to search

Spread32 is tiny (1mb) spreadsheet with a lot of capabilities and higly compatible with MS excel.

Features:

  • 256 columns x 65536 rows x 32768 sheets
  • unlimited open files
  • supported operations: + - * / ^ % &
  • 327 worksheet functions (see below)
  • 177 macro functions for custom functions and commands
  • array formulas
  • undo, cut, copy, paste (all/formulas/values/formats/comments), fill (down/right/up/left/series), clear all/formats/contents/comments)
  • insert/delete cells, rows and columns
  • hide/unhide rows and columns
  • hide/show row and column headings
  • find/replace text
  • goto specified cell
  • sort selected cells, rows, columns or whole sheet with multiple keys
  • freeze panes
  • sheet/column/row/cell formatting
    • column width
    • row height
    • number formats (general/fixed/currency/accounting/date/time/percent/fraction/scientific/text/custom)
    • alignment (horizontal: general/left/center/right/fill/center across selection, vertical: top/center/bottom)
    • font (bold, italic, underline, name, size, color)
    • borders (top, left, bottom, right, style, color)
    • zoom
    • background (pattern, color)
    • protection (locked, hidden)
    • conditional formatting
  • charts (column, bar, line, pie, scatter, area, doughnut, radar)
  • named ranges
  • autofilter
  • advanced filter
  • controls (label/group box/command button/check box/option button/list box/combobox/scrollbar/spinner)
  • drawing objects (line/rectangle/oval/text box)
  • data form
  • data validation
  • cell comments
  • merged cells
  • read/write Excel 95/97-2003 files
  • read/write Pocket Excel 2.0 files
  • read/write CSV files
  • read/write tab-delimited text files
  • goal seek
  • 3d references
  • references to external files
  • hyperlinks
  • autoshapes
  • full screen mode