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
- 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
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.