1
Please everyone working on KSpread:
3
Get yourself a copy of Excel 97 or 2000 and create
4
a really big sheet, and I mean really big and insert Graphs and
5
lots of dependencies and regressions etc. use external add-ins if you have any
6
and real time links. Make links between sheets and then see how
9
1. UNDERSTAND that putting a spread->recalc() or spread->recalc(true) in
10
your code is an abosolute NO-NO! Complex spreadsheets with possible
11
heavy mathematical calculations via dll/so add-ins as well as real
12
time feeds will not be managable if you do not painstakingly check
13
wether spread->getAutoCalc() is true.
16
2. Learn to understand that without the
17
following short cut actions you are lost ( try to scroll
18
down a list of 10,000 obersvations ...not using CTRL Down
21
CTRL Up/Down/Left/Right
22
CTRL Shift Up/Down/Left/Right
27
Let's try to get them working well in Kspread as well. I tried my
28
hand at it but wasn't able to get them to be efficient.
30
3. Familiarize yourself with the concept of array formulas and why they
31
are necessary (area protection, partial argument evaluation) Who would
32
be willing to implement them? This will be an absolute must if we
33
want to make progress on the mathematical/financial/statistical
34
function side of things. I would be willing to implement a miriad
35
of these functions but I believe doing that without having array
36
formulae first will be a big mistake.
38
(In case you wonder why I feel so strongly about these things:
39
I am a professional user of Excel. I eat, sleap and work with Excel
40
on my trading desk on Wall-Street.)
43
Bernd <wuebben@kde.org>