Problem description: Steps to reproduce: 1.Create a spreadsheet (sheet 1) w/ 60k rows,20 coloumns Fill up with data 2.create a new spreasheet ( sheet 2 )w/ 15k rows, 20 coloumns ( first coloumn filled up w/ data ) populate the cells of coloumn 2 to 20 via vlookup function, looking for data in the sheet 1 Current behavior: - takes up long time ( 30 min - couple of hours ), - takes up to 4 Gb Ram - uses only 1 core of 8 within the CPU Expected behavior: max 3 min processing time , more cores in parallel ( as MS Excell does! ) Platform (if different from the browser): Browser: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:15.0) Gecko/20100101 Firefox/15.0
Confirmed in: Ubuntu 12.04 LibreOffice 3.5.4.2 Build ID: 350m1(Build:2) It is a feature that greatly limits the possible migration of Excel to Calc.
Kohei or Markus - thoughts on this one? I believe there are already bugs out there that say things like "support more than one core" -> is this really actionable? IMO we should close as it's a big request that isn't specific to vlookup (vlookup might just be a symptom of not supporting more than one core)
Closing this, I have talked to our two spreadsheet experts and what I put in comment is indeed true. This is not actionable and the grand scheme of "use all cores" is incredibly difficult - maybe long term planning but the particular bug won't be useful in implementing it. Thanks for the report.