Spread32
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