[Libreoffice-bugs] [Bug 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

 Status|RESOLVED|VERIFIED

--- Comment #19 from Xisco Faulí  ---
it takes 17 seconds in

Version: 7.1.0.0.alpha0+
Build ID: e0f058bcd5e185b89e4b7c680a7901bc7eb2a790
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

while in

Version: 6.4.0.0.alpha1+
Build ID: 9bc848cf0d301aa57eabcffa101a1cf87bad6470
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

it takes 78 seconds. Nice improvement.

@Noel, thanks for fixing this issue!!

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

--- Comment #18 from Commit Notification 
 ---
Noel Grandin committed a patch related to this issue.
It has been pushed to "libreoffice-7-0":

https://git.libreoffice.org/core/commit/a5010d00be3a2dc1c89935d473b20fcbc127da86

tdf#88109 improve autofill perf (2)

It will be available in 7.0.0.1.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

Commit Notification  changed:

   What|Removed |Added

 Whiteboard|target:7.0.0 target:7.1.0   |target:7.0.0 target:7.1.0
   ||target:7.0.0.1

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

Noel Grandin  changed:

   What|Removed |Added

 Resolution|--- |FIXED
 Status|NEW |RESOLVED

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

--- Comment #17 from Commit Notification 
 ---
Noel Grandin committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/9073a47b99e22585c6d1603dd747cb14f081fca1

tdf#88109 improve autofill perf (2)

It will be available in 7.1.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

Commit Notification  changed:

   What|Removed |Added

 Whiteboard|target:7.0.0|target:7.0.0 target:7.1.0

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

--- Comment #16 from Noel Grandin  ---
My apologies, I marked this resolved before I pushed the patch.

It should be much better now, although I think I can still speed it up a little
more.

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

--- Comment #15 from Commit Notification 
 ---
Noel Grandin committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/68547fa26897a8076eeda13cdcf20fb6078af6a4

tdf#88109 speed up calc autofill

It will be available in 7.0.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

Commit Notification  changed:

   What|Removed |Added

 Whiteboard||target:7.0.0

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

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

--- Comment #14 from Xisco Faulí  ---
Just for the record, the import time changed from

real0m10,414s
user0m8,418s
sys 0m0,680s

to

real0m31,807s
user0m27,930s
sys 0m2,827s

after
https://cgit.freedesktop.org/libreoffice/core/commit/?id=1e55a47e89a9d9d6cf9cb3993484022aaf2c097b
which is already reported in bug 124098

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

--- Comment #13 from Xisco Faulí  ---
For me it takes 26 seconds in

Version: 6.5.0.0.alpha0+
Build ID: bf540873f5e258452fed5006f65a403c95e7872a
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

Roman Kuznetsov <79045_79...@mail.ru> changed:

   What|Removed |Added

 CC||noelgran...@gmail.com

--- Comment #12 from Roman Kuznetsov <79045_79...@mail.ru> ---
Noel, please can you look at it?

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

--- Comment #11 from Julien Nabet  ---
Created attachment 156856
  --> https://bugs.documentfoundation.org/attachment.cgi?id=156856=edit
perf flamegraph

Here's a Flamegraph retrieved on pc Debian x86-64 with master sources updated
today

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

--- Comment #10 from Julien Nabet  ---
> ...
> Julien, can you make the perfgraph here?

No pb, I'll do it after my daytime job.

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

Roman Kuznetsov <79045_79...@mail.ru> changed:

   What|Removed |Added

 CC||79045_79...@mail.ru,
   ||serval2...@yahoo.fr

--- Comment #9 from Roman Kuznetsov <79045_79...@mail.ru> ---
(In reply to Aron Budea from comment #8)
> Takes ~10 s for me now.
> For comparison, in 5.4.0.3 it took ~20 s.
> 
> Version: 6.3.0.0.alpha0+ (x64)
> Build ID: eef8c4952da288629f9aad23f75d6f894eba83b4
> CPU threads: 16; OS: Windows 6.1; UI render: default; VCL: win; 
> Locale: hu-HU (hu_HU); UI-Language: en-US
> Calc: CL

it took 34 sec for me in

Version: 6.5.0.0.alpha0+ (x64)
Build ID: 2d736e1a0a2bbd41fe7793d52bbcc7bfc89c7da3
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: default; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

Julien, can you make the perfgraph here?

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

Aron Budea  changed:

   What|Removed |Added

 CC||ba...@caesar.elte.hu

--- Comment #8 from Aron Budea  ---
Takes ~10 s for me now.
For comparison, in 5.4.0.3 it took ~20 s.

Version: 6.3.0.0.alpha0+ (x64)
Build ID: eef8c4952da288629f9aad23f75d6f894eba83b4
CPU threads: 16; OS: Windows 6.1; UI render: default; VCL: win; 
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: CL

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

--- Comment #7 from QA Administrators  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

--- Comment #6 from Xavier Van Wijmeersch  ---
with

Version: 6.0.0.0.alpha1+
Build ID: 91987a559bf1fde4a8d1eadc81e5711a7670fe69
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time:
2017-10-26_23:50:05
Locale: nl-BE (en_US.UTF-8); Calc: group

it takes 52 seconds

Version: 5.4.4.0.0+
Build ID: f95ec59f035ef1f6e9bd2a24e9d69e35edd6e089
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

it takes 66 seconds

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

Aron Budea  changed:

   What|Removed |Added

 Blocks||113499


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=113499
[Bug 113499] [META] AutoFill bugs and enhancements
-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

Version|4.5.0.0.alpha0+ Master  |Inherited From OOo

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

--- Comment #5 from Xisco Faulí  ---
In

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4

it takes 8 minutes 30 seconds. There has been some improvements at least...

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

 CC||xiscofa...@libreoffice.org

--- Comment #4 from Xisco Faulí  ---
it takes 1 minute and 55 seconds in

Version: 5.5.0.0.alpha0+
Build ID: 6ab249ea6aecef5d3f35d624622a368061cad9c3
CPU Threads: 4; OS Version: Linux 4.8; UI Render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

--- Comment #3 from QA Administrators  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of
LibreOffice 
(5.1.6 or 5.2.3  https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of
LibreOffice and 
your operating system, and any changes you see in the bug behavior

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave 
a short comment that includes your version of LibreOffice and Operating System

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword


Feel free to come ask questions or to say hello in our QA chat:
http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug-20170103

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

Robinson Tryon (qubit)  changed:

   What|Removed |Added

   Keywords||perf
 Whiteboard|perf|

--- Comment #2 from Robinson Tryon (qubit)  ---
Migrating Whiteboard tags to Keywords: (perf)

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

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

m.a.riosv mari...@miguelangel.mobi changed:

   What|Removed |Added

 Attachment #111848|text/plain  |application/vnd.oasis.opend
  mime type||ocument.spreadsheet

-- 
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 88109] PERF: Calc autofill is very slow

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=88109

raal r...@post.cz changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||r...@post.cz
  Component|Libreoffice |Spreadsheet
Summary|Calc autofill is very slow  |PERF: Calc autofill is very
   ||slow
 Ever confirmed|0   |1
 Whiteboard||perf

--- Comment #1 from raal r...@post.cz ---
Calc 4.5 and 3.5 is +- the same time (slow, tens of seconds).
Comparing to excel where this operation takes 1 sec (slower VM on my machine ),
so it's possible to make this instantly..

Marking as NEW.

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