[Libreoffice-bugs] [Bug 92197] Slow performance of Calc with filter set

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92197

Cor Nouws  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=99
   ||607

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92197] Slow performance of Calc with filter set

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92197

Cor Nouws  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |WORKSFORME

--- Comment #16 from Cor Nouws  ---
Thanks Robert and Miguel

Since as far as we can see the fix for bug 91307 is not yet pushed to 5.1 /
5.0, we can only resolve this as WorksForMe

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92197] Slow performance of Calc with filter set

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92197

--- Comment #15 from Robert Gonzalez MX  ---
Problem not present anymore with the test file and other files with +35,000
rows

Version: 5.1.1.0.0+
Build ID: fdf698bef5bf25c2a10e2b8ddb1955143cd3f227
CPU Threads: 8; OS Version: Windows 6.2; UI Render: default; 
TinderBox: Win-x86@62-merge-TDF, Branch:libreoffice-5-1, Time:
2016-02-04_13:51:00
Locale: es-MX (es_MX)

Version: 5.1.1.1 (RC1)
Build ID: c43cb650e9c145b181321ea547d38296db70f36e
CPU Threads: 8; OS Version: Windows 6.2; UI Render: default; 
Locale: es-MX (es_MX)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92197] Slow performance of Calc with filter set

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92197

--- Comment #14 from m.a.riosv  ---
@Cor, I have no problem with this one neither with #95414
Win10x64
Version: 5.0.5.2 (x64) Build ID: 55b006a02d247b5f7215fc6ea0fde844b30035b3
Version: 5.2.0.0.alpha0+
Build ID: 85fcf15ff41ceb95f46dee586ff7187551be4955
CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; 
TinderBox: Win-x86@39, Branch:master, Time: 2016-02-27_09:23:38

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92197] Slow performance of Calc with filter set

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92197

Cor Nouws  changed:

   What|Removed |Added

 CC||markus.mohrhard@googlemail.
   ||com

--- Comment #13 from Cor Nouws  ---
Can people involved here maybe please test a recent daily build
  http://dev-builds.libreoffice.org/daily/master/
because of the fix for bug 91307
  (to be backported to 5.0 and 5.1 hopefully)

Thanks!
Cor

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92197] Slow performance of Calc with filter set

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92197

Cor Nouws  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=91
   ||307

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92197] Slow performance of Calc with filter set

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92197

Cor Nouws  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=95
   ||414

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92197] Slow performance of Calc with filter set

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92197

--- Comment #12 from Cor Nouws  ---
@Miguel:

What do you think of
https://bugs.documentfoundation.org/show_bug.cgi?id=95414#c3
(from  Beluga )
> I had no problem with filling down J2:M2. Didn't have to reopen.
> 
> I did notice some lag with the autofilter steps after doing it a couple of
> times. I also confirm that after editing any value or string while having
> filtered, I have to scroll away and back to see the change.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92197] Slow performance of Calc with filter set

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92197

Cor Nouws  changed:

   What|Removed |Added

 CC||c...@nouenoff.nl
Summary|Slow Performance of Calc|Slow performance of Calc
   ||with filter set

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92197] Slow Performance of Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92197

--- Comment #11 from jean-mathieu.desche...@aviyatech.com ---
I saw very similar issue on my computer with LibreOffice 5.0.3 on Ubuntu 14.04

I am usually working with decently sized spreadsheets(~50 column, ~20k rows)
and and it is really hard to get anything done with this problem.

I can confirm that the removing the Spell Checker features made it run a lot
smoother.

Let me know if you want more information.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92197] Slow Performance of Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92197

Fabio  changed:

   What|Removed |Added

Version|5.0.0.0.beta3   |5.0.3.2 release
 OS|Windows (All)   |Linux (All)

--- Comment #10 from Fabio  ---
Hi, 

I`m trying to work with a database that has over than 4 milion cells (800K
lines and 5 coluns) but the performance of the software is bellow from the
competitor to the same database.

My PC`s configuration is?

Memory: 7.7GiB
Processor: Intel® Core™ i7-3632QM CPU @ 2.20GHz × 8 
Graphycs: Intel® Ivybridge Mobile
Type of SO: 64-bit
Disk: 976,1 GB

Is there some configuration that I could change to get a better performance ?

Thanks for help.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92197] Slow Performance of Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92197

--- Comment #9 from m.a.riosv miguelange...@libreoffice.org ---
There is a portable version to test.

https://www.libreoffice.org/download/portable-versions/

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92197] Slow Performance of Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92197

m.a.riosv miguelange...@libreoffice.org changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 Ever confirmed|0   |1

--- Comment #4 from m.a.riosv miguelange...@libreoffice.org ---
I can't reproduce your delays with:
Win7x64Ultimate
Version: 5.1.0.0.alpha1+ Build ID: d56b125f6c6c18ac40712cefc3cec06530750e15
TinderBox: Win-x86@39, Branch:master, Time: 2015-06-13_07:08:43

Maybe the first thing to try is resetting the user profile.
https://wiki.documentfoundation.org/UserProfile

Also e.g. VLOOKUP()s can be replaced with TEXT() function to get the month
name.
K2: =TEXT(A2;)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92197] Slow Performance of Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92197

Robert Gonzalez MX riggra...@gmail.com changed:

   What|Removed |Added

 CC||riggra...@gmail.com

--- Comment #2 from Robert Gonzalez MX riggra...@gmail.com ---
Created attachment 116680
  -- https://bugs.documentfoundation.org/attachment.cgi?id=116680action=edit
Test file for slow performance

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92197] Slow Performance of Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92197

Robert Gonzalez MX riggra...@gmail.com changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

--- Comment #3 from Robert Gonzalez MX riggra...@gmail.com ---
I am attaching a test file.

it has a parameters sheet and a movements sheet

the movements sheet has 3600 rows and in some columns it has valdity
referencing the parameters sheet.

it has also a VLOOKUP function to obtain some data from the parameters sheet
based on the date.

I changed the language from spanish to english and what i noticed is that the
spell checking delays up to 9 seconds to display the red waving underlines.

In some cases when moving around on the cells, in the input bar doesn't display
the contents, formula or text.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92197] Slow Performance of Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92197

--- Comment #8 from Robert Gonzalez MX riggra...@gmail.com ---
Created attachment 116693
  -- https://bugs.documentfoundation.org/attachment.cgi?id=116693action=edit
screenshoot of Option View Graphic Output

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92197] Slow Performance of Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92197

--- Comment #7 from Robert Gonzalez MX riggra...@gmail.com ---
I have compared the options graphics output en LO 4.4.3.2 and LO 5.0.0.0 beta3,
and are identical, but en LO 4.4 it performs as expected. see attachment.

Then changed the options graphics output one by one, but still, hangs changing
from one sheet to another, for about 5-7 seconds.

What I do to reproduce is change from one sheet to another, using the ctrl-page
up and ctrl-page down, repeatedly. With version 4.4.3.2 it performs fast and
normal. With version 5, it hangs.

So I try turning off the automatic spell checking, and the problem was gone.

Then, turn it on again, and the problem went back.

Maybe it has something to do with the spell checking.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92197] Slow Performance of Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92197

Robert Gonzalez MX riggra...@gmail.com changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92197] Slow Performance of Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92197

--- Comment #5 from Robert Gonzalez MX riggra...@gmail.com ---
Ok.
I have reseted the user profile in my laptop with Windows 8, but still teh same
performance.

By the way, the same behavior is present in a desktop pc with windows XP SP3.

So i think that is not probable that the same problem is present in two
different, but I leave it for if there is anyone else with this.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 92197] Slow Performance of Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92197

--- Comment #6 from m.a.riosv miguelange...@libreoffice.org ---
Please test if the changing the options:
Menu/Tools/LibreOffice/View - Graphics output
change something.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs