summaryrefslogtreecommitdiff
Unidiff
Diffstat (more/less context) (ignore whitespace changes)
-rw-r--r--noncore/apps/opie-sheet/ChangeLog5
1 files changed, 5 insertions, 0 deletions
diff --git a/noncore/apps/opie-sheet/ChangeLog b/noncore/apps/opie-sheet/ChangeLog
index e8a31ee..0370156 100644
--- a/noncore/apps/opie-sheet/ChangeLog
+++ b/noncore/apps/opie-sheet/ChangeLog
@@ -1,68 +1,73 @@
1January 8, 2004 1January 8, 2004
2 - converted icons from xpm to png and moved them to $OPIEDIR/pics/opie-sheet
3 - modified mainwindow.cpp to load pixmaps with Resource::loadPixmap(resourcename) in contrast to the old QPixmap(nameofthe_xpm_included_in_the_opie-sheet_dir)
4 - changed pics/opie-sheet/sheetqt.png entry in control file to pics/opie-sheet/*.png
5
6January 8, 2004
2 - fixed issue : "-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." 7 - fixed issue : "-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."
3 now the text is handled correctly. 8 now the text is handled correctly.
4 9
5January 7, 2004 10January 7, 2004
6 * Release by hayzel (koppermind@panafonet.gr) 11 * Release by hayzel (koppermind@panafonet.gr)
7 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 ) 12 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 )
8 -Fixed a bug with non closed parenthesis editing&recalculation infinite loop. 13 -Fixed a bug with non closed parenthesis editing&recalculation infinite loop.
9 -Added support for functions that can parse parameters not ONLY as numbers but also as strings. 14 -Added support for functions that can parse parameters not ONLY as numbers but also as strings.
10 -Added many functions that cover many computational topics rendering opie-sheet a computational tool-spreadsheet at last. (total 90 functions!) 15 -Added many functions that cover many computational topics rendering opie-sheet a computational tool-spreadsheet at last. (total 90 functions!)
11 -Maintained compatibility with the opie-fileformat. 16 -Maintained compatibility with the opie-fileformat.
12 -New icons. 17 -New icons.
13 -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. 18 -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.
14 -Added new class "Expression" a general Parser for spreadsheet-expression. Imported from an old C# project of mine. 19 -Added new class "Expression" a general Parser for spreadsheet-expression. Imported from an old C# project of mine.
15 -Now can also parse <>=!%&^|"" in expressions. 20 -Now can also parse <>=!%&^|"" in expressions.
16 -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. 21 -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.
17 -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. 22 -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.
18 23
19 24
20 *known issues: 25 *known issues:
21 -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. 26 -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.
22 -randbetween return only integer part random... if both limit numbers are integers. 27 -randbetween return only integer part random... if both limit numbers are integers.
23 -skew and kurt function give different results compared to kspread-oofice equivalents. 28 -skew and kurt function give different results compared to kspread-oofice equivalents.
24 -unstable parser Excel Class 29 -unstable parser Excel Class
25 -string vars and string functions are not correctly handled by excel importer. 30 -string vars and string functions are not correctly handled by excel importer.
26 -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. 31 -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.
27 32
28 *TODOs: 33 *TODOs:
29 -surelly a much full-stable excel importer. 34 -surelly a much full-stable excel importer.
30 -Cell Manipulation of many Data is really slow.... must change the QList data type. To a structure more efficient. 35 -Cell Manipulation of many Data is really slow.... must change the QList data type. To a structure more efficient.
31 -maybe some more functions. 36 -maybe some more functions.
32 -maybe some kind of charts drawing? 37 -maybe some kind of charts drawing?
33 -maybe kspread or ooffice files import/export. 38 -maybe kspread or ooffice files import/export.
34 39
35October 08, 2002 40October 08, 2002
36 41
37 * Release 1.0.2 (by thufir) 42 * Release 1.0.2 (by thufir)
38 - Fixed bug #250 (exhibiting re-calculation error in multi-level calculation). (by thufir) 43 - Fixed bug #250 (exhibiting re-calculation error in multi-level calculation). (by thufir)
39 44
40October 06, 2002 45October 06, 2002
41 46
42 - Fixed data edit box clear problem. (by thufir) 47 - Fixed data edit box clear problem. (by thufir)
43 48
44October 05, 2002 49October 05, 2002
45 50
46 - Fixed bug #252 (starting up in 'mouse button' mode). (by thufir) 51 - Fixed bug #252 (starting up in 'mouse button' mode). (by thufir)
47 52
48August 31, 2002 53August 31, 2002
49 54
50 - Fixed and updated opie-sheet.pro file. (by cniehaus) 55 - Fixed and updated opie-sheet.pro file. (by cniehaus)
51 56
52August 01, 2002 57August 01, 2002
53 58
54 - Fixed gcc3 compile problems. (by harlekin) 59 - Fixed gcc3 compile problems. (by harlekin)
55 60
56July 06, 2002 61July 06, 2002
57 62
58 - Fixed DocLnk management to save documents correctly. (by leseb) 63 - Fixed DocLnk management to save documents correctly. (by leseb)
59 64
60July 04, 2002 65July 04, 2002
61 66
62 * Release 1.0.1 (by thufir) 67 * Release 1.0.1 (by thufir)
63 - Sheet/Qt is now a part of Opie, so its name is changed to Opie Sheet. (by thufir) 68 - Sheet/Qt is now a part of Opie, so its name is changed to Opie Sheet. (by thufir)
64 - Fixed sorting bug. (by thufir) 69 - Fixed sorting bug. (by thufir)
65 70
66April 14, 2002 71April 14, 2002
67 72
68 * Release 1.0.0 (by thufir) 73 * Release 1.0.0 (by thufir)