v1.0.0

Commander Calc 1.0

A spreadsheet for the Commander X16. First release.

It runs on a stock 512 KB machine and loads from an SD card. Everything
happens on the X16 itself — including reading and writing .xlsx files.

What it does

• Formulas with 14 functions (SUM, AVERAGE, IF, ROUND, MOD, and so on)
• Absolute references ($A$1) and references across sheets (Q1!B5)
• 16 worksheets per workbook
• Block select with Ctrl+A, then copy, paste, clear or sort the block
• Insert and delete rows and columns, find and replace, one level of undo
• Sorting, with formula references fixed up afterwards
• Bar, line and pie charts, and you can save one as a .BMP
• Import and export .xlsx and .csv
• Its own .X16S format, which loads much faster than .xlsx
• Mouse support

You need

• A Commander X16, or x16emu
• ROM R48 or later
• An SD card formatted for CMDR-DOS

Installing

Copy the whole CMDRCALC folder onto the card. The program and all 17
OVL*.BIN files have to stay together in the same folder — it loads them
as it goes.

LOAD"CMDRCALC.PRG",8
RUN

In the emulator:

x16emu -rom rom.bin -fsroot . -prg CMDRCALC.PRG -run

Load it again each time you want to run it. Typing RUN a second time
drops you into the monitor. That is normal — the start-up code and the
program's variables share the same memory, so it only runs once per load.

In the download

The program, the example workbooks, and the reference manual as a PDF.

Open one of the examples to see it working. FUNCS.XLSX shows every
function next to what it should say, LOAN.X16S is an amortisation table
built on absolute references, and GRADES.X16S reads one sheet from
another.

Worth knowing

• Filenames are uppercase on the card.
• The file list holds 64 entries per folder.
• Sorting a block that is narrower than your data will ask first, because
  the columns beside it stay where they are.

Bug reports welcome.