Ask Your Question

What Hardware and OS to Meet LO Calc Performance Tests?

asked 2016-09-11 03:31:46 +0100

ert gravatar image

updated 2016-09-11 03:34:07 +0100

I'm planning to buy a used or new laptop. I'd like it to work with large blocks of cells without slow performance, crashes, hangups, or other problems. Two concrete examples of what I'd like to do are below.

With cells a1 to all4000 filled with numbers (max 4 characters), enter " =IF(AND(COUNTBLANK(A1:B1)=0,B1>100),A1," ") " into cell a4001, and then use the autofill handle to fill cells a4001to all8000 with the formula. Once I select down to all8000 and release the mouse button I'd like LO Calc to complete the calculation in less than 40 seconds.

I'd also like to be able to copy, delete, and paste blocks of 200k cells (4 charaters per cell max), with each operation taking no more than 1 second.

Ideally, I'd like to run Ubuntu or Linux Mint as the OS.

My budget is $500 max, but ideally as far below that as possible while still meeting performance tests.

Can you recommend a hardware/OS/LO combination? In particular, would a latitude e6420 work? Specs

Thanks for reading and any help you can provide.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-09-11 12:49:06 +0100

m.a.riosv gravatar image

Your first copy take 1 second on an I3 with 4GB Win10 LibreOffice 5.2, and the same with copy/delete/past.

But calculations depends on the whole sheets and their formulas and relations, so without a sample spreadsheet for test, no one can give you an accurate answer.

edit flag offensive delete link more


Thank you. Tried to upvote you, but I don't have enough points.

Let's say that a1 to all4000 are autofilled, starting with "1" in cell a1. Nothing else on the sheet except the formula described in the OP, a4001 to all8000

ert gravatar imageert ( 2016-09-11 23:14:40 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-09-11 03:31:46 +0100

Seen: 43 times

Last updated: Sep 11 '16