1. performance in comparision to openoffice_3.1_m38 / 2. problem of "VLOOKUP" function / 3. export problem to the native *.gnumeric file format

[Nihil Baxter <pausenclown_metulski yahoo de>]

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