author | hayzel <hayzel> | 2004-01-07 08:08:29 (UTC) |
---|---|---|
committer | hayzel <hayzel> | 2004-01-07 08:08:29 (UTC) |
commit | 08bc72c34cae85e5cc6541c9daaeba121597c961 (patch) (unidiff) | |
tree | df5b263a84099ffdf8e0b86fda9a9fe61b90d30e /noncore/apps/opie-sheet/func-comma.xpm | |
parent | 656e80e7b35c4aefd49ffe7756d895f4e7370de1 (diff) | |
download | opie-08bc72c34cae85e5cc6541c9daaeba121597c961.zip opie-08bc72c34cae85e5cc6541c9daaeba121597c961.tar.gz opie-08bc72c34cae85e5cc6541c9daaeba121597c961.tar.bz2 |
January 7, 2004
* Release by hayzel (koppermind@panafonet.gr)
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 )
-Fixed a bug with non closed parenthesis editing&recalculation infinite loop.
-Added support for functions that can parse parameters not ONLY as numbers but also as strings.
-Added many functions that cover many computational topics rendering opie-sheet a computational tool-spreadsheet at last. (total 90 functions!)
-Maintained compatibility with the opie-fileformat.
-New icons.
-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.
-Added new class "Expression" a general Parser for spreadsheet-expression. Imported from an old C# project of mine.
-Now can also parse <>=!%&^|"" in expressions.
-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.
-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.
*known issues:
-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.
-randbetween return only integer part random... if both limit numbers are integers.
-skew and kurt function give different results compared to kspread-oofice equivalents.
-unstable parser Excel Class
-string vars and string functions are not correctly handled by excel importer.
-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.
*TODOs:
-surelly a much full-stable excel importer.
-Cell Manipulation of many Data is really slow.... must change the QList data type. To a structure more efficient.
-maybe some more functions.
-maybe some kind of charts drawing?
-maybe kspread or ooffice files import/export.
Diffstat (limited to 'noncore/apps/opie-sheet/func-comma.xpm') (more/less context) (ignore whitespace changes)
-rw-r--r-- | noncore/apps/opie-sheet/func-comma.xpm | 43 |
1 files changed, 23 insertions, 20 deletions
diff --git a/noncore/apps/opie-sheet/func-comma.xpm b/noncore/apps/opie-sheet/func-comma.xpm index 3b2bbf9..2e680d2 100644 --- a/noncore/apps/opie-sheet/func-comma.xpm +++ b/noncore/apps/opie-sheet/func-comma.xpm | |||
@@ -1,21 +1,24 @@ | |||
1 | /* XPM */ | 1 | /* XPM */ |
2 | static const char * func_comma_xpm[] = { | 2 | static const char *func_comma_xpm[]={ |
3 | "16 16 2 1", | 3 | "16 16 5 1", |
4 | " c None", | 4 | ". c None", |
5 | ".c #000000", | 5 | "# c #000000", |
6 | " ", | 6 | "a c #0000ff", |
7 | " ", | 7 | "b c #0058c0", |
8 | " ", | 8 | "c c #0080ff", |
9 | " ... ", | 9 | "................", |
10 | " ..... ", | 10 | "................", |
11 | " ...... ", | 11 | "................", |
12 | " ...... ", | 12 | "......###.......", |
13 | " ..... ", | 13 | ".....#aaa#......", |
14 | " .. ", | 14 | ".....#bcca#.....", |
15 | " . ", | 15 | ".....#bbaa#.....", |
16 | " .. ", | 16 | "......##ba#.....", |
17 | " .. ", | 17 | "........#b#.....", |
18 | " . ", | 18 | "........#b#.....", |
19 | " ", | 19 | ".......#b#......", |
20 | " ", | 20 | "......#b#.......", |
21 | " "}; | 21 | "......##........", |
22 | "................", | ||
23 | "................", | ||
24 | "................"}; | ||