> Paul wrote: > >> OpenOffice Calc has major difficulties handling this test: > >> > >> 50x50 matrix of random numbers (range 0 to 10) > >> Invert Matrix > >> Invert again > >> Plot differences between original matrix and final matrix. > >> > >> Excel does it in about a second; several minutes for OpenOffice Calc. > >> Also likely to cause lock-up. > >> Note that Excel won't handle much larger matrix. > >> > >> -Dr Bob > >> > >> > > > > I've tried your spreadsheet on my machine and both the updating of the > > matrices and the re-draw of the resulting graph is not as snappy as it > is in > > Excel, but it still took only ~2 seconds. > > > > This one may depend on spec's of the machine being used. Was it faster > in > > previous releases on the same machine? > > > > /paul > > > Only took a couple of seconds for me as well, and my computer is more > than a year old and was not a top of the line computer when I built it > either. I do, however, have 4GB of RAM. > > I've done some more playing around with this as it seems there is a speed difference (on my machine anyway) depending on whether you open the .xls within calc and then do the F9 updates of both the matrices and graph, or whether you simply copy the contents of the spreadsheet into calc, then create the graph within calc.
Opening the .xls and doing the updates does seem noticeably slower. Maybe due to conversion of formats required etc... /paul -- Processing Key for cracking HD DVD's: 09 F9 11 02 9D 74 E3 5B D8 41 56 C5 63 56 88 C0 ----- Try Torpark; a small portable, open-source, built on Firefox browser that enables anonymous browsing. Requires no installation : http://www.torrify.com/
