hi, libreoffice calc's performance is sluggish when processing large data (row > 30000, file size > 10 MB). it always crash when filtering (takes very long time then system is not responding). thanks.
Could you attach a test document for us to play with? Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the document.
Created attachment 116569 [details] example here is an example, when I tried to filter and copy the result to other worksheet, operation keeps running & then system is not responding
(In reply to bayu swandana from comment #2) > Created attachment 116569 [details] > example > > here is an example, when I tried to filter and copy the result to other > worksheet, operation keeps running & then system is not responding How did you filter?
sorry my late answer, I didn't check my e-mail routinely. I filtered by : Data > Filter > Standard Filter > insert filter criteria > expand option > tick copy result to > choose other sheet > click OK
(In reply to bayu swandana from comment #4) > sorry my late answer, I didn't check my e-mail routinely. > > I filtered by : > > Data > Filter > Standard Filter > insert filter criteria > expand option > > tick copy result to > choose other sheet > click OK I need more detailed steps as I've never done this. Do I need to create a data range before I can choose the target for copy result? If yes, can you copy here the range definition? Do I need to create a filter condition?
no, when i chose data > filter > standard filter, libreoffice automatically select data range if we want to copy the filter result to other sheet, we don't need to define the range, we only need to define the "upper left" corner cell of the new location e.g. if we want to copy filter result from sheet 1 to sheet 2, we only need to input $Sheet2.$A$1 in "copy result to" field
Thank you. $Sheet3.$A$1 to be exact :) I get instant results without any crash. In this kind of strange case it is recommended to try this trick: https://wiki.documentfoundation.org/User_Profile#Resolving_corruption_in_the_user_profile You could also try installing the latest 4.4.4 to replace your 4.4.1 version. Win 7 Pro 64-bit, Version: 4.4.4.3 Build ID: 2c39ebcf046445232b798108aa8a7e7d89552ea8 Locale: fi_FI Version: 5.1.0.0.alpha1+ (x64) Build ID: 8b788891796ff0571f779cdbe8ce809c35c42754 TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2015-07-02_23:09:27 Locale: fi-FI (fi_FI)
I am deeply sorry, I haven't checked this issue for almost a month. That was great if you got instant result. Does it mean the problem is in my PC? Because I have updated to v4.4.4.3, but still experience this issue. Please check attachment capture1 & capture2 Thank you
Created attachment 117528 [details] filter criteria
Created attachment 117529 [details] not responding
You could try the user profile renaming trick. If you haven't done any customization to your toolbar & keyboard shortcuts, you don't have to do any further work after that.
No feedback since several months. Let's put this one to INSUFFICIENTDATA. bayu swandana: don't hesitate to reopen this tracker if you still reproduce this with a brand new profile (see https://bugs.documentfoundation.org/show_bug.cgi?id=91926#c7)