| Summary: | Calc loads sheet very long, cannot use filters. | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | migilenik |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | minor | CC: | ilmari.lauhakangas, jmadero.dev |
| Priority: | low | ||
| Version: | 5.1.2.2 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Linux (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Catalog in Excel sheet | ||
It works fine here. It is maybe a bit slower to open and manipulate in 5.1 than in 5.2. (8-15 seconds to open) 64-bit, KDE Plasma 5 Build ID: 5.1.2.2 Arch Linux build-1 CPU Threads: 8; OS Version: Linux 4.5; UI Render: default; Locale: fi-FI (fi_FI.UTF-8) Arch Linux 64-bit, KDE Plasma 5 Version: 5.2.0.0.alpha1+ Build ID: 540fee2dc7553152914f7f1d8a41921e765087ef CPU Threads: 8; OS Version: Linux 4.5; UI Render: default; Locale: fi-FI (fi_FI.UTF-8) Built on April 30th 2016 (In reply to migilenik from comment #0) > Created attachment 124636 [details] > Catalog in Excel sheet > > It takes almost minute (or even more, depends on machine) to open sheet, and > even if it opens, we cant use any of created filters (menu does open, but we > cant check any of predefined options). This is two different issues. Let's just focus on the slow load - the other issue should be a separate bug. > > It does open in Gnumeric immediately, but predefined filters are missing. Well - that's not a fair comparison then because the filters might be what's causing it to run slower. Saying some other software opens it "immediately" but it opens it incorrectly (without the filters) shouldn't be a comparison to LibreOffice's performance that is trying to open it correctly with the filters. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ My results: Bodhi Linux Version: 5.1.1.3 Build ID: 89f508ef3ecebd2cfb8e1def0f0ba9a803b88a6d CPU Threads: 2; OS Version: Linux 3.16; UI Render: default; Locale: en-US (en_US.UTF-8) Opens in about 1 minute 9 seconds Version: 5.2.0.0.alpha0+ Build ID: ef34535ceb60d7d63b8d8671e4c6e9e43ffbd17d CPU Threads: 2; OS Version: Linux 3.16; UI Render: default; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-03-27_09:53:05 Locale: en-US (en_US.UTF-8) Identical timing. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Marking as NEW but see my notes below: 1) Given that you're using this in a professional setting I'd suggest reaching out to a certified developer to get paid support (the other option is wait until a volunteer finds this to be an interesting issue). https://www.libreoffice.org/get-help/professional-support/ Things you can do: 2) Do a calgrind/valgrind to see what's going on: https://wiki.documentfoundation.org/Development/How_to_debug#Valgrinding_.28memcheck.29_LibreOffice_itself You can jump into IRC to ask developer how exactly to get a log 3) Testing older versions to see if this is a regression would be useful: http://downloadarchive.documentfoundation.org/libreoffice/old/ Setting to: New Minor - will not prevent high quality work, just slows it down a bit; Low - default for minor bugs seems appropriate here. Tested on LO 5.2 alpha 1 under WinXP inside virtual machine and it works great. (In reply to migilenik from comment #4) > Tested on LO 5.2 alpha 1 under WinXP inside virtual machine and it works > great. What about on Linux https://wiki.documentfoundation.org/Installing_in_parallel/Linux http://dev-builds.libreoffice.org/daily/master/Linux-rpm_deb-x86@71-TDF/current/ (In reply to Buovjaga from comment #5) > (In reply to migilenik from comment #4) > > Tested on LO 5.2 alpha 1 under WinXP inside virtual machine and it works > > great. > > What about on Linux > https://wiki.documentfoundation.org/Installing_in_parallel/Linux > http://dev-builds.libreoffice.org/daily/master/Linux-rpm_deb-x86@71-TDF/ > current/ Tested on Debian 8.4 amd64 using LibreOfficeDev Version: 5.2.0.0.alpha1+ Build ID: 389d8db4d90d427f886d06c3f7304ad973f0d39c. Flawless! Fantastic. I'll set to WFM, if you don't mind :) |
Created attachment 124636 [details] Catalog in Excel sheet Hi, in our company we have problems with loading some catalogs (Excel sheets) in LibreOffice Calc 5.1.2-3~bpo8+1 from Debian Jessie backports repository. It takes almost minute (or even more, depends on machine) to open sheet, and even if it opens, we cant use any of created filters (menu does open, but we cant check any of predefined options). It does open in Gnumeric immediately, but predefined filters are missing.