Hello friends of gnumeric,
1. PERORMANCE ISSUE
I found gnumeric when I looked for a faster alternative to openoffice. But my
openoffice seems to be faster than gnumeric-1.9.3 compiled on sabayon 4.0 64bit
kernel 2.6.27.
For performance comparison I took one of my large spreadsheats ( *.sxc 1,7MB /
saved as *.xls 22,9MB) saved it in the *.sxc file format (because the odf 1.2
version of *.ods is not yet fully supported by gnumeric)
The following comparison cannot be generalized but it might correspond to your
experiences.
notebook celeron M550 @2000MHz, 2,5GB
CHANGING INPUT VALUE FOR CALCULATION:
GNUMERIC
85seconds, memory consumption 386MB
OPENOFFICE
9seconds, memory consumption 1006MB
RECALCULATION F9:
GNUMERIC
21seconds
OPENOFFICE
9seconds
This shows that the time for recalculation (F9) and the time for changing a
input value is the same for openoffice (in this case). Gnumeric needs 21s for
Recalculation but 85seconds for changing the input value.
What does Gnumeric do after the first 21seconds? CPU-usage is always 100%
2. PROBLEM OF "VLOOKUP" FUNCTION
Almost everything was calculated correctly but there was a mysteric phenomenon
concerning the vlookup function.
It was not possible to define a higher value for the matrix legth then 2076. If
I would increase the Value >=2077 the result would be always "0"
=vlookup(max(Q14:Q2076);Q14:R2076;2;1)
3. EXPORT PROBLEM TO NATIVE *.GNUMERIC FILE FORMAT
The import filter seems to work quiet good for *.sxc files.
The following function works correctly after loading the *.sxc file with
GNUMERIC.
=if(or(K$10=0;K$13=0);J16;if(or(and(J15<>0;J15<>" ");L15=1;L15=0);if(I16>$G16;"
";if(and((($G16/(indirect("g"&row(J16)-(row(J16)-max(K$14:K16)))))-1)*100>K$10;sum(L15:indirect("L"&(row(J15)-(row(J15)-max(K$14:K15)))))>(K$13-2));$G16;if((($G16/(indirect("g"&(row(J16)-(row(J16)-max(K$14:K16))))))-1)*100>K$10;1;0)));"
"))
After saving the file in the "MS Excel (tm) 97/2000/XP u. 5.0/95" file format
the function has got a lot of additional brackets but is still working
correctly!
=if(or(K$10=0;K$13=0);J17;if(or(and(J16<>0;J16<>" ");L16=1;L16=0);if(I17>$G17;"
";if(and((((((((((((((((($G17/((((((((indirect("g"&row(J17)-((((((((row(J17)-max(K$14:K17))))))))))))))))))))))))))-1))))))))*100>K$10;sum(L16:indirect("L"&((((((((row(J16)-((((((((row(J16)-max(K$14:K16)))))))))))))))))))>((((((((K$13-2)))))))));$G17;if((((((((((((((((($G17/((((((((indirect("g"&((((((((row(J17)-((((((((row(J17)-max(K$14:K17))))))))))))))))))))))))))))))))))-1))))))))*100>K$10;1;0)));"
"))
After saving the file in the *.GNUMERIC file format the function looks like the
original function of the *.sxc file but shows the error "#BEZUG!"
=if(or(K$10=0;K$13=0);J16;if(or(and(J15<>0;J15<>" ");L15=1;L15=0);if(I16>$G16;"
";if(and((($G16/(indirect("g"&row(J16)-(row(J16)-max(K$14:K16)))))-1)*100>K$10;sum(L15:indirect("L"&(row(J15)-(row(J15)-max(K$14:K15)))))>(K$13-2));$G16;if((($G16/(indirect("g"&(row(J16)-(row(J16)-max(K$14:K16))))))-1)*100>K$10;1;0)));"
"))
NICE GREETINGS
_______________________________________________
gnumeric-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnumeric-list
