sheets/doc/NOTES.misc

0001 Please everyone working on Calligra Sheets:
0002
0003 Get yourself a copy of Excel 97 or 2000 and create
0004 a really big sheet, and I mean really big and insert Graphs and
0005 lots of dependencies and regressions etc. use external add-ins if you have any
0006 and real time links. Make links between sheets and then see how
0007 well Excel behaves.
0008
0009 1. UNDERSTAND that putting a spread->recalc() or spread->recalc(true) in
0010 your code is an abosolute NO-NO! Complex spreadsheets with possible
0011 heavy mathematical calculations via dll/so add-ins as well as real
0012 time feeds will not be managable if you do not painstakingly check
0013 whether spread->getAutoCalc() is true.
0014
0015
0016 2. Learn to understand that without the
0017 following short cut actions you are lost ( try to scroll
0018 down a list of 10,000 obersvations ...not using CTRL Down
0019 for example)
0020
0021 CTRL Up/Down/Left/Right
0022 CTRL Shift Up/Down/Left/Right
0023 CTRL Home/End
0024 CTRL Shift Home/End
0025 Shift F9 versus F9
0026
0027 Let's try to get them working well in Calligra Sheets as well. I tried my
0028 hand at it but wasn't able to get them to be efficient.
0029
0030 3. Familiarize yourself with the concept of array formulas and why they
0031 are necessary (area protection, partial argument evaluation) Who would
0032 be willing to implement them? This will be an absolute must if we
0033 want to make progress on the mathematical/financial/statistical
0034 function side of things. I would be willing to implement a miriad
0035 of these functions but I believe doing that without having array
0036 formulae first will be a big mistake.
0037
0038 (In case you wonder why I feel so strongly about these things:
0039 I am a professional user of Excel. I eat, sleap and work with Excel
0040 on my trading desk on Wall-Street.)
0041
0042
0043 Bernd <wuebben@kde.org>