| Readme: | Short: Sigma Demo - a spreadsheet for MorphOS
Author: Yannick Buchy
Type: biz/spread
Version: 1.3
Architecture: ppc-morphos
Requires: MorphOS 3.20+
============================================================================
SIGMA - Spreadsheet
Version 1.3
============================================================================
INTRODUCTION
------------
Sigma is a spreadsheet for MorphOS built with MUI (Magic User Interface) and
TTEngine for TrueType font rendering. It offers live formulas, rich cell
formatting and native OpenDocument (.ods) import/export, with full UTF-8
Unicode support throughout.
TECHNOLOGIES
------------
Provided by MorphOS:
- TTEngine (TrueType font rendering)
- xadmaster.library (ZIP container reading, for ODS import)
Implemented by Sigma:
- A formula engine (cell references, ranges, the usual functions)
- A sparse cell model (millions of logical cells, RAM tracks only used ones)
- OpenDocument Spreadsheet (.ods) reader/writer
- CSV (RFC-4180) import/export
INSTALLATION
------------
Simply copy the Sigma drawer to your preferred location.
Fonts are scanned automatically; no configuration required.
REGISTRATION & UPGRADES
-----------------------
Sigma 1.0 Demo
The demo version lets you try every feature. Saving your work (ODS or CSV)
requires the registered version; opening, editing and importing are free.
The title bar shows "Sigma Demo" until the program is registered.
Registered version:
Sigma (version 1.0 and future updates): 29.90 euros
Sigma + Stylos + IPP-Print + IPP-Scan (full bundle): 69.90 euros
All future Sigma features are included free of charge, among them:
- XLSX (Excel) import and export
- Direct printing
- Frozen panes and multiple sheets
Stylos is a WYSIWYG word processor for MorphOS; IPP-Print/IPP-Scan add
driverless printing and scanning. Each has its own registration.
PayPal: papiosaur2@hotmail.fr (send as a friend to avoid fees)
Contact: yannick.buchy@gmail.com to receive your registered version.
If you have any questions, don't hesitate to ask.
BUG HUNTERS WANTED
------------------
Help improve Sigma! Send a clear bug report with steps to reproduce to
yannick.buchy@gmail.com (the .ods/.csv file and a snapshot are welcome).
Each confirmed bug earns you a 5 euros discount on your license.
Find 6 confirmed bugs and you get Sigma for free, including all updates.
FEATURES
--------
Spreadsheet
- Grid up to 16384 rows x 256 columns (sparse: memory tracks only used cells)
- Keyboard navigation, scrolling, zoom 50%-300%
- Adjustable visible extent (Col/Lig fields)
- Column width / row height (W/H fields, keyboard + wheel) in millimetres or
inches (selectable in Preferences), with true 1:1 physical sizing from the
screen DPI
Formulas
- = + - * / and parentheses, A1 cell references, A1:B2 ranges
- Relative and absolute references ($A$1, $A1, A$1)
- Numbers AND text: string literals "...", text concatenation with &, and
formulas can return text (e.g. =IF(A1>0,"OK","NO"))
- Math/stat: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, PRODUCT, MEDIAN, STDEV,
VAR, ABS, INT, TRUNC, SIGN, ROUND, ROUNDUP, ROUNDDOWN, CEILING, FLOOR, MOD,
POWER, SQRT
- Logic: IF, IFERROR, AND, OR, NOT, TRUE, FALSE; comparisons (< > = <= >= <>)
- Conditional: SUMIF, COUNTIF, AVERAGEIF
- Lookup: VLOOKUP, HLOOKUP, INDEX, MATCH
- Text: LEN, LEFT, RIGHT, MID, UPPER, LOWER, TRIM, CONCATENATE, SUBSTITUTE,
REPT, FIND, SEARCH, EXACT, VALUE, TEXT
- Dates: DATE, TODAY, NOW, YEAR, MONTH, DAY, WEEKDAY (Excel-compatible serials)
- Info: ISBLANK, ISNUMBER, ISTEXT, ISERROR, N
- Case-insensitive; errors: #CYCLE #REF! #DIV/0! #N/A #ERR
- Function names can be typed in French (SOMME, MOYENNE, SI, RECHERCHEV,
SOMME.SI, GAUCHE...); files always store the English names for interop
- Point mode: while typing a formula, click or drag cells to insert their
reference; drag a range handle to resize an existing reference
Editing
- Inline editing with a blinking caret, in-cell text selection
- Cell and text clipboard (Ctrl+C / Ctrl+X / Ctrl+V); copy/paste keeps the
cell formatting (colours, borders, font, alignment, number format), and
pasting a formula shifts its relative references ($-anchored parts stay fixed)
- Fill handle: drag the bottom-right grip to copy a cell (value + format,
formula references shifted) across a range
- Sort a selected range (ascending / descending) by its first column
- Undo / redo (Ctrl+Z / Ctrl+Y)
- Insert / delete rows and columns (references auto-adjust)
- Find / Replace
- Recent files menu
Formatting
- Bold, italic, underline (+ double), strikethrough (+ double), super/subscript
- Text and cell background colours (palette + colour picker)
- Per-cell font and size
- Horizontal and vertical alignment
- Cell borders: All / Outer / Inner / None presets plus individual
top / bottom / left / right sides, with selectable line width
(0.5/1/1.5/2 pt) and a format painter
- Seven number formats: 0.00, integer, thousands, percent, currency (EUR),
scientific, date (DD/MM/YYYY)
- Unicode symbol band for inserting special characters
File formats
- OpenDocument Spreadsheet (.ods) import and export: data, live formulas,
fonts, colours, alignment, borders, number formats, column widths and row
heights - a faithful round-trip, and interoperable with LibreOffice/Excel
- CSV (RFC-4180, UTF-8) import and export; the import auto-detects the field
separator (comma, semicolon or tab) so European Excel/Calc files load too
- PDF export (Project -> Export PDF): the used range is paginated onto A4
with cell backgrounds, borders, fonts (bold/italic), colours and alignment
- Drag & drop a file icon onto the window to open it
Interface
- Localized (English by default, French catalog included)
- Preferences (Display): detected monitor and resolution, screen diagonal ->
computed DPI, cell background theme, header colour, cursor width and colour,
measurement unit (mm / inch) for the W/H fields;
- Title bar shows the file name and an asterisk when there are unsaved changes
FILE FORMATS
------------
.ods OpenDocument Spreadsheet - the recommended format, keeps everything
.csv Comma-Separated Values - data only (no formulas, no formatting)
Formulas are stored in OpenDocument (OpenFormula) form on export and converted
back on import, so they stay live and editable in other office suites.
KEYBOARD SHORTCUTS
------------------
Cmd + N New
Cmd + O Open
Cmd + S Save
Cmd + P Export PDF
Cmd + Z Undo
Cmd + Y Redo
Cmd + X Cut
Cmd + C Copy
Cmd + V Paste
Cmd + ? About
Cmd + Q Quit
Arrow keys Move the active cell
Shift + Arrows Extend the selection
Enter / type Edit the cell ; Enter validates and moves down
F2 Edit the active cell
Mouse wheel Scroll ; Ctrl + wheel zooms
MENUS
-----
Project New, Open, Recent files, Save, Save as, Export PDF, Print, About, Quit
Edit Undo, Redo, Cut, Copy, Paste, Clear
Table Insert/Delete rows, Insert/Delete columns
Settings Preferences, MUI
HISTORY
-------
1.3 - Printing (Project -> Print, toolbar): driverless IPP network printing
via Ghostscript, with printer discovery, page range, N-up, sides,
quality, scale-to-fit and a live preview.
- New Settings menu (Preferences + MUI); a real Save (Amiga+S) beside
Save as; Project/Settings menus regrouped like Stylos.
- PDF export options: page orientation (portrait/landscape), adjustable
margins, export DPI, and "open in the PDF viewer after export".
- Colour pickers (any RGB) for the cell background, headers and cursor.
- Autosave to a configurable file, with a restore prompt on the next
start after a crash.
- Undo/redo/paste toolbar buttons are greyed until they can be used.
- Preferences: wheel-adjustable screen size, computed-DPI source shown
(screen/entry), measurement unit + margins on the document page.
1.2 - Much larger formula engine: text and text functions, dates, lookups
(VLOOKUP/INDEX/MATCH), conditional sums (SUMIF/COUNTIF), more stats;
new date number format.
- PDF export (Project -> Export PDF): A4 with embedded fonts, so the
euro sign and accents always render.
- Copy/paste and the copy/apply-style tool keep full cell formatting
(colours, borders + width, font, alignment, number format).
- Individual top/bottom/left/right border buttons (+ All/Outer/Inner/None).
- Column width / row height in millimetres or inches.
- Preferences gained a Documents page (default font/size/zoom, create
icons, autosave to a recovery file); settings live in PROGDIR:Settings/
and the requesters reopen at the last-used directory.
- Pasting/inserting beyond the visible area grows it; the last row and
column scroll fully into view.
- Save confirms overwrite and warns of unsaved changes on quit.
- CSV import auto-detects the field separator (comma/semicolon/tab).
1.1 - The toolbar reflects the active cell, with exclusive (radio) alignment
buttons and stateful border buttons + a line-width selector.
- Relative/absolute references ($A$1): pasting or filling shifts the
relative parts and keeps the $-anchored ones fixed.
- Fill handle (copy value + format down/across) and range sort.
- Undo/redo now covers column-width and row-height changes.
- Formula names can be typed in French; files store the English names.
- New functions: MEDIAN, IFERROR, ROUNDUP/ROUNDDOWN, CEILING, FLOOR.
- ODS fixes: column widths honoured by LibreOffice/Excel; top-aligned
cells export correctly.
1.0 First public release.
Grid, formulas (with point mode), CSV and ODS import/export, full cell
formatting, number formats, find/replace, undo/redo, preferences with
EDID-based DPI, recent files, localization.
COPYRIGHT
---------
Sigma is Copyright (c) Yannick Buchy. All rights reserved.
DISCLAIMER
----------
Sigma is provided "as is", without warranty of any kind, express or implied.
You use it at your own risk: the author cannot be held responsible for any
data loss or damage resulting from its use. Always keep backups of important
files.
CONTACT
-------
Author: Yannick Buchy
THANKS
------
- MorphOS Team for MorphOS
|
Ambient (150)
Sigma_1.3.lha