-rw-r--r-- | noncore/apps/opie-sheet/ChangeLog | 5 |
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 @@ | |||
1 | January 8, 2004 | 1 | January 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 | |||
6 | January 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 | ||
5 | January 7, 2004 | 10 | January 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 | ||
35 | October 08, 2002 | 40 | October 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 | ||
40 | October 06, 2002 | 45 | October 06, 2002 |
41 | 46 | ||
42 | - Fixed data edit box clear problem. (by thufir) | 47 | - Fixed data edit box clear problem. (by thufir) |
43 | 48 | ||
44 | October 05, 2002 | 49 | October 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 | ||
48 | August 31, 2002 | 53 | August 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 | ||
52 | August 01, 2002 | 57 | August 01, 2002 |
53 | 58 | ||
54 | - Fixed gcc3 compile problems. (by harlekin) | 59 | - Fixed gcc3 compile problems. (by harlekin) |
55 | 60 | ||
56 | July 06, 2002 | 61 | July 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 | ||
60 | July 04, 2002 | 65 | July 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 | ||
66 | April 14, 2002 | 71 | April 14, 2002 |
67 | 72 | ||
68 | * Release 1.0.0 (by thufir) | 73 | * Release 1.0.0 (by thufir) |