author | hayzel <hayzel> | 2004-01-07 08:08:29 (UTC) |
---|---|---|
committer | hayzel <hayzel> | 2004-01-07 08:08:29 (UTC) |
commit | 08bc72c34cae85e5cc6541c9daaeba121597c961 (patch) (side-by-side diff) | |
tree | df5b263a84099ffdf8e0b86fda9a9fe61b90d30e /noncore/apps/opie-sheet/excel16.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/excel16.xpm') (more/less context) (ignore whitespace changes)
-rw-r--r-- | noncore/apps/opie-sheet/excel16.xpm | 187 |
1 files changed, 187 insertions, 0 deletions
diff --git a/noncore/apps/opie-sheet/excel16.xpm b/noncore/apps/opie-sheet/excel16.xpm new file mode 100644 index 0000000..45dd96d --- a/dev/null +++ b/noncore/apps/opie-sheet/excel16.xpm @@ -0,0 +1,187 @@ +/* XPM */ +static const char *excel16_xpm[]={ +"16 16 168 2", +"aL c None", +"Qt c None", +"aK c #24440a", +"#y c #247d21", +"#B c #276d1e", +"aw c #284a0d", +"au c #2b4e10", +"#P c #2c6e1a", +"ag c #2d5114", +"ad c #2e541a", +"af c #304326", +"#2 c #317a1c", +"ae c #334f25", +"#5 c #335919", +"#F c #375d1f", +"#O c #3a872f", +"#t c #3d6324", +"ac c #3d7939", +"#Y c #3e7132", +"#p c #407f39", +"#Z c #42903e", +"#i c #436d28", +".9 c #446e2a", +"aJ c #466628", +"av c #476430", +"aI c #476829", +".W c #47732d", +"#K c #479643", +"#1 c #48872e", +"aH c #496b2d", +".6 c #4a8a49", +"aG c #4b6e31", +".z c #4b7832", +"#L c #4d9647", +"aF c #4e7336", +"aE c #52783b", +".m c #527a3e", +"#x c #529c4f", +"#N c #549c4b", +"aD c #567a3f", +"#V c #579342", +"#X c #588649", +"aC c #598041", +".T c #598955", +"#A c #59a354", +"#W c #5a8f48", +"aB c #5d8745", +"ax c #5d914d", +"#o c #5ea657", +"#C c #5f8755", +"aA c #5f8947", +".5 c #5f9f5a", +"#e c #60965b", +"#f c #609c5b", +"az c #618b4a", +".l c #629450", +"ay c #679350", +".k c #689854", +"#U c #69a15f", +"ah c #6c9c59", +"#d c #6cae66", +".R c #6da767", +".S c #6ea564", +"#n c #6eaf67", +".3 c #6fad69", +"#0 c #6fb067", +".j c #719f5f", +"ab c #729a6b", +"#6 c #72a161", +".2 c #74a270", +"#J c #75b56d", +".i c #76a366", +"#l c #77ae74", +"#M c #78b570", +"#I c #79b176", +".4 c #79b870", +"#S c #7ba66b", +".N c #7bb374", +".h c #7da970", +".1 c #7fbd76", +"#G c #81ab74", +"#c c #81bb78", +".M c #83bb7b", +"aa c #869782", +".g c #86b079", +"a# c #879783", +"a. c #889885", +"#u c #88b279", +"#9 c #899886", +".U c #89b188", +".L c #89c081", +".O c #8ab485", +".0 c #8ac381", +".f c #8eb580", +"#j c #8eb680", +".y c #91a483", +"#m c #91c28a", +"#. c #92b885", +"#8 c #93ae91", +".e c #93ba87", +"#3 c #93be91", +"at c #94a089", +"#4 c #96a18b", +"#z c #96c78d", +".# c #97bc8a", +"#D c #99b598", +"#Q c #9abb99", +"#R c #9ba890", +".d c #9bbf90", +"#E c #9ca991", +"#s c #9ca992", +"#b c #9dc895", +"#h c #9fac95", +".c c #9fc294", +"#a c #a0c99b", +".8 c #a2b198", +".V c #a3b199", +".b c #a4c699", +".K c #a5b29b", +".Z c #a6cf9f", +".Y c #a7cda1", +".a c #a9c99e", +".n c #acc4a3", +".x c #b2c3aa", +"ai c #b4c4ab", +".w c #b6c7ad", +"#7 c #b7c7ae", +".v c #b9cab1", +"#T c #bbcab3", +".u c #bbcbb3", +".Q c #bbd0ba", +"#H c #bccbb4", +".t c #beceb7", +".s c #c0d1ba", +"#k c #c1d1bb", +".r c #c2d1bc", +"## c #c2d2bc", +".X c #c4d5be", +".q c #c6d9c1", +".p c #c8d9c2", +".o c #c9dac3", +"#q c #cdddcd", +"as c #d3e3d3", +"ar c #d4e4d4", +"aq c #d7e6d7", +"ap c #d8e7d9", +"ao c #dae9db", +".7 c #dce8db", +"#r c #dce9dc", +"an c #ddebdd", +"#g c #dfecdf", +"am c #e1ede0", +"al c #e3ede3", +"#w c #e5efe5", +"ak c #e6efe6", +".J c #e7f0e7", +"aj c #e8f0e8", +".I c #eaf2ea", +".P c #ebf3eb", +".H c #ecf4ec", +".G c #f0f5f0", +".F c #f2f7f2", +"#v c #f3f7f3", +".E c #f4f8f4", +".D c #f7f9f6", +".C c #f9fbf8", +".B c #fafcfa", +".A c #fcfdfc", +"QtQtQtQtQtQtQtQtQtQtQtQtQtQtQtQt", +"Qt.#.a.b.c.d.e.f.g.h.i.j.k.l.mQt", +"Qt.a.n.o.p.q.r.s.t.u.v.w.x.y.zQt", +"Qt.b.o.A.B.C.D.E.F.G.H.I.J.K.zQt", +"Qt.c.p.L.M.N.O.P.Q.R.S.T.U.V.WQt", +"Qt.d.X.Y.Z.0.1.2.3.4.5.6.7.8.9Qt", +"Qt#.##.D#a#b#c#d#e#f.6.7#g#h#iQt", +"Qt#j#k.E.F#l#m#n#o#p#q#g#r#s#tQt", +"Qt#u.s#v#w#x#y#z#A#A#B#C#D#E#FQt", +"Qt#G#H.P#I#J#K#L#M#N#O#P#Q#R#FQt", +"Qt#S#T#U#V#W#X#Y#Z#0#1#2#3#4#5Qt", +"Qt#6#7#8#9a.a#aaabacadaeaf#4agQt", +"QtahaiajakalamanaoapaqarasatauQt", +"Qt.kavavavavavavavavavavavavawQt", +"QtaxayazaAaBaCaDaEaFaGaHaIaJaKQt", +"aLaLaLaLaLaLaLaLaLaLaLaLaLaLaLaL"}; |