| Summary: | : Working slow on large spreadsheets w/ Vlookup inserted ( file size = 13+Mb ) | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Gyorgy Zold <gyorgy.zold> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED INVALID | ||
| Severity: | major | CC: | azlinux, jmadero.dev, kohei, markus.mohrhard |
| Priority: | high | ||
| Version: | 3.6.0.4 release | ||
| Hardware: | Other | ||
| OS: | All | ||
| See Also: | https://bugs.freedesktop.org/show_bug.cgi?id=65765 | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
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. |
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