summaryrefslogtreecommitdiff
Unidiff
Diffstat (more/less context) (ignore whitespace changes)
-rw-r--r--noncore/apps/opie-sheet/ChangeLog2
1 files changed, 1 insertions, 1 deletions
diff --git a/noncore/apps/opie-sheet/ChangeLog b/noncore/apps/opie-sheet/ChangeLog
index 06b2878..56887c5 100644
--- a/noncore/apps/opie-sheet/ChangeLog
+++ b/noncore/apps/opie-sheet/ChangeLog
@@ -1,33 +1,33 @@
1January 7, 2004 1January 7, 2004
2 * Release by hayzel (koppermind@panafonet.gr) 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 ) 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. 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. 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!) 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. 7 -Maintained compatibility with the opie-fileformat.
8 -New icons. 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. 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. 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. 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. 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. 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 14
15 15
16 *known issues: 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. 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. 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. 19 -skew and kurt function give different results compared to kspread-oofice equivalents.
20 -unstable parser Excel Class 20 -unstable parser Excel Class
21 -string vars and string functions are not correctly handled by excel importer. 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. 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 23
24 *TODOs: 24 *TODOs:
25 -surelly a much full-stable excel importer. 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. 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. 27 -maybe some more functions.
28 -maybe some kind of charts drawing? 28 -maybe some kind of charts drawing?
29 -maybe kspread or ooffice files import/export. 29 -maybe kspread or ooffice files import/export.
30 30
31October 08, 2002 31October 08, 2002
32 32
33 * Release 1.0.2 (by thufir) 33 * Release 1.0.2 (by thufir)