author | hayzel <hayzel> | 2004-01-07 08:14:01 (UTC) |
---|---|---|
committer | hayzel <hayzel> | 2004-01-07 08:14:01 (UTC) |
commit | 7fdc50c5ff3fe42aba6d940165e99ed7150df4f1 (patch) (unidiff) | |
tree | 83a2327b0dc099db1894e687d011b3297fe33e6a | |
parent | 08bc72c34cae85e5cc6541c9daaeba121597c961 (diff) | |
download | opie-7fdc50c5ff3fe42aba6d940165e99ed7150df4f1.zip opie-7fdc50c5ff3fe42aba6d940165e99ed7150df4f1.tar.gz opie-7fdc50c5ff3fe42aba6d940165e99ed7150df4f1.tar.bz2 |
*** empty log message ***
-rw-r--r-- | noncore/apps/opie-sheet/ChangeLog | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/noncore/apps/opie-sheet/ChangeLog b/noncore/apps/opie-sheet/ChangeLog index 90060e2..06b2878 100644 --- a/noncore/apps/opie-sheet/ChangeLog +++ b/noncore/apps/opie-sheet/ChangeLog | |||
@@ -1,6 +1,36 @@ | |||
1 | January 7, 2004 | ||
2 | * Release by hayzel (koppermind@panafonet.gr) | ||
3 | This version has many valuable changes, though It may have some annoying bugs. Please if you are interested in opie-sheet try it hard, so I can fix some of them. Also If you want some other functions that must be here and are missing feel free to ask them. (no financial functions please. :) I really hate them ) | ||
4 | -Fixed a bug with non closed parenthesis editing&recalculation infinite loop. | ||
5 | -Added support for functions that can parse parameters not ONLY as numbers but also as strings. | ||
6 | -Added many functions that cover many computational topics rendering opie-sheet a computational tool-spreadsheet at last. (total 90 functions!) | ||
7 | -Maintained compatibility with the opie-fileformat. | ||
8 | -New icons. | ||
9 | -Found that the DataParser was not a real RPN compiler of the expressions. In fact it was returning faulty results in calculations, in both binary or unary operations. A1-A2-A3 was parsed as A1-(A2-A3). A1 was parsed as A1. | ||
10 | -Added new class "Expression" a general Parser for spreadsheet-expression. Imported from an old C# project of mine. | ||
11 | -Now can also parse <>=!%&^|"" in expressions. | ||
12 | -Added experimental Excel File format import!. The opie-sheet can import any excel file in BIFF7/BIFF8 format. These formats are used in Excel XP,2000,95. The Excel Importer class is in a good coding level.. BUT it is not complete. Only strings,numbers,formulas are imported. Not formatting rules. Not all the functions are converted in the functions of opie-sheet. Infact FEW functions are converted. | ||
13 | -Fixed a bug with Sheet Recalculation. Added ReCalc() function. Opie-sheet was calculating wrong the values of expression in opening/importing. if a value needed was not loaded yet in the time of calculation. Solved with ReCalc() each time the active sheet is changing. | ||
14 | |||
15 | |||
16 | *known issues: | ||
17 | -if someone enters directly text as parameter to a string function the text renders as uppercase due to the calculation engine that uppercases all the parsing sentence. | ||
18 | -randbetween return only integer part random... if both limit numbers are integers. | ||
19 | -skew and kurt function give different results compared to kspread-oofice equivalents. | ||
20 | -unstable parser Excel Class | ||
21 | -string vars and string functions are not correctly handled by excel importer. | ||
22 | -unicode strings are converted FINE in QString unicode format, but cannot be rendered fine if a suitable unicode font is not setuped as the default string. So the string is junked in the opie-sheet and may crash the parser. | ||
23 | |||
24 | *TODOs: | ||
25 | -surelly a much full-stable excel importer. | ||
26 | -Cell Manipulation of many Data is really slow.... must change the QList data type. To a structure more efficient. | ||
27 | -maybe some more functions. | ||
28 | -maybe some kind of charts drawing? | ||
29 | -maybe kspread or ooffice files import/export. | ||
30 | |||
1 | October 08, 2002 | 31 | October 08, 2002 |
2 | 32 | ||
3 | * Release 1.0.2 (by thufir) | 33 | * Release 1.0.2 (by thufir) |
4 | - Fixed bug #250 (exhibiting re-calculation error in multi-level calculation). (by thufir) | 34 | - Fixed bug #250 (exhibiting re-calculation error in multi-level calculation). (by thufir) |
5 | 35 | ||
6 | October 06, 2002 | 36 | October 06, 2002 |