Hi Oliver, On Monday, 2007-02-19 08:40:21 +0100, Oliver Brinzing wrote:
> if have a performance problem with a spreadsheet document. > The document has about 100 sheets and about 50.000 SVerweis() formulas as > > =WENN(ODER(ISTLEER(E6);E6="");"";SVERWEIS(E6;Code.$B$4:$F$3492;2;0)) > =WENN(ODER(ISTLEER(E7);E7="");"";SVERWEIS(E7;Code.$B$4:$F$3492;2;0)) > ... > > If one enters a value in a cell of the code range, it takes about a minute on > a 3 GHZ XP machine with 1 GB RAM to recalc ... > If all or most SVERWEIS/VLOOKUP formulas reference the range Code.$B$4:$F$3492 then this may be due to a broadcaster performance problem that comes into play when too many formulas listen on identical portions of ranges. You may try to rearrange things such that those many identical references aren't needed. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
