public
Description: A spreadsheet program for my own amusement.
Homepage: http://accesscom.com/~darius
Clone URL: git://github.com/darius/vicissicalc.git
commit  a43754529660cb500d0684b18c7dcdbb320caed4
tree    22f7a6233e5a5fa056c43e19aad456f97b1c5725
parent  bb432990d8a407315c7b5dae6d9bbb248bc3d65e
vicissicalc / Todo.text
100644 74 lines (55 sloc) 2.297 kb
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
don't lose the user's work.
two ways that can happen:
 - they fail to write before quitting
   - so write a '.unsaved' file on exit
 - they write when they shouldn't
   - so keep at least one older version around
also, give more feedback -- messages -- on writing
 
arrow keys
 
when editing a cell: left and right arrow, C-a, C-e, clear
make = a keystroke command
 
grid bigger than the screen
 
aggregates over cell ranges
 
detect screen dimensions
 
let overwide cell display overflow into any empty cells adjacent to
the right
 
color-code formulas/values/labels/plaints
 
highlight and navigate dependents/dependencies of the current cell
 
make global settings from a spreadsheet: search for a setting-name and
pick the value out of the cell next to it
 
boring practicality:
  use decimal arithmetic
  numeric decimal formatting widths
 
table lookup (for tax tables)
conditional expressions
 
"Minimal-keystroke formula entry: type "1.1*" then move the cursor
then type "-1" to enter a formula. The goal here was to make it worth
using the first time you needed an answer (instead of a calculator and
paper) in a way that would let you benefit the next time by just
changing a few values and recalculating. If the input style did not
let you "teach" the computer by doing the calculation, people may not
have used it."
http://j2k.naver.com/j2k.php/heightK/www.bricklin.com/firstspreadsheetquestion.htm
 
----------------------------------------------------------
 
a pivoting spreadsheet
 
----------------------------------------------------------
 
callable spreadsheets as functions
 
----------------------------------------------------------
done:
 
indicate whether we're showing formulas or values
comments
save/restore
copy formulas
relative cell reference
bugfix: invalidate *everything* after assigning
complain() should advance the scanner to the end
handle overflow of input field without blowing up
proper error handling
use home() instead of clear_screen()
overflow marker when cell contents don't fit
show current cell's formula on its own line
make formulas start with = (instead of comments starting with #)
top-level plaint line
plaints from non-evaluation functions like file loading & bad keypress
show current cell's plaint, if any, in the plaint line
be able to abort edits with C-g