[Libreoffice-bugs] [Bug 144257] Recalculating after deleting cell contents (used in formulas) increased from 2 to 10 seconds if multi-threaded

2022-05-12 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144257

--- Comment #19 from Timur  ---
It's 4 secs for me now in 7.4+ with multi-threaded calc. 
Not as good as without it (why?) but better than before.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144257] Recalculating after deleting cell contents (used in formulas) increased from 2 to 10 seconds if multi-threaded

2022-05-11 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144257

Luboš Luňák  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |DUPLICATE

--- Comment #18 from Luboš Luňák  ---


*** This bug has been marked as a duplicate of bug 144777 ***

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144257] Recalculating after deleting cell contents (used in formulas) increased from 2 to 10 seconds if multi-threaded

2022-01-24 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144257

--- Comment #17 from Timur  ---
(In reply to Timur from comment #5)
> 6.0 master:  2 sec
> 6.1 oldest:100+, frozen
> 6.1 master: 12 sec
> 6.2 before commit:  12 sec
> 7.3+ 8 sec
7.4+   

We have different systems, but versions with change were identified. 
So now are relevant for test: 6.0 master/latest to see how fast it was, 7.3
oldest to see how it was when reported, master which is 7.4+ to see it now.

7.4+ seem unchanged from 7.3-, faster than 6.2 but slower than without
multi-threaded calc, which is almost instant. 
So key question remains: why is multi-threaded calc slower?

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144257] Recalculating after deleting cell contents (used in formulas) increased from 2 to 10 seconds if multi-threaded

2022-01-24 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144257

--- Comment #16 from Buovjaga  ---
Sorry, I was deleting row, not cell.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144257] Recalculating after deleting cell contents (used in formulas) increased from 2 to 10 seconds if multi-threaded

2022-01-23 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144257

--- Comment #15 from stragu  ---
ugh, sorry about the previous comment, I was confusing this report with the
scrolling one: Bug 144250

Here it is again, focusing on the issue reported here:

(In reply to Timur from comment #11)
> stragu, thanks for checking, but please test always with trouble version and
> fresh or beter master to compare on the same system.

What do you mean by "trouble version"? The earliest version affected according
to this bug report is 6.2, which is an unmaintained branch, and the most recent
version tested by Telesto in Comment 0 was 7.3, which is the one I picked to
test (a currently maintained branch). I think my WFM was a justified call, but
I said I'd like someone else to check and I'm happy to do more testing.

I tested a number of times to have a better idea of how much time it takes
before the values are updated:

In 7.2.5: about 3 seconds
in 7.3.0.2: about 3 seconds
In 7.4 alpha0+: about 3 seconds

Undoing the operation seems to take a similar time.

Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: 571438a34ad9aba0d496a89e8345851331740fbd
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

Setting back to NEW.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144257] Recalculating after deleting cell contents (used in formulas) increased from 2 to 10 seconds if multi-threaded

2022-01-23 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144257

stragu  changed:

   What|Removed |Added

 Ever confirmed|0   |1
 Status|UNCONFIRMED |NEW

--- Comment #14 from stragu  ---
(In reply to Timur from comment #11)
> stragu, thanks for checking, but please test always with trouble version and
> fresh or beter master to compare on the same system.

What do you mean by "trouble version"? The earliest version affected according
to this bug report is 6.2, which is an unmaintained branch, and the most recent
version tested by Telesto in Comment 0 was 7.3, which is the one I picked to
test (a currently maintained branch). I think my WFM was a justified call, but
I said I'd like someone else to check and I'm happy to do more testing.

I realised the two seconds I mentioned was until the scrolling _started_ to
respond, but it was still stuttering or stopping for a few more seconds
afterwards.

Time before I can scroll without stuttering is actually pretty similar between
versions:

In 7.2.5: about 6 seconds
in 7.3.0.2: about 6 seconds
In 7.4 alpha0+: about 7 seconds

There is a clear delay between when the cell values are updated (emptied or
result of formula changed) and when the scrolling is smooth.

Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: 571438a34ad9aba0d496a89e8345851331740fbd
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

Setting back to NEW.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144257] Recalculating after deleting cell contents (used in formulas) increased from 2 to 10 seconds if multi-threaded

2022-01-23 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144257

Telesto  changed:

   What|Removed |Added

 Resolution|WORKSFORME  |---
 Ever confirmed|1   |0
 Status|RESOLVED|UNCONFIRMED

--- Comment #13 from Telesto  ---
Well for me is selected cell A8 & pressing delete still slow (selecting row a8
& delete being fast)
Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 4a388f5e01ebb5a512931d11e48c4380382239c8
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: en-US
Calc: CL

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144257] Recalculating after deleting cell contents (used in formulas) increased from 2 to 10 seconds if multi-threaded

2022-01-23 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144257

--- Comment #12 from Buovjaga  ---
I have 1 sec or less delay on Linux and Windows, but this is also with 7.2.5.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144257] Recalculating after deleting cell contents (used in formulas) increased from 2 to 10 seconds if multi-threaded

2022-01-23 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144257

--- Comment #11 from Timur  ---
stragu, thanks for checking, but please test always with trouble version and
fresh or beter master to compare on the same system.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144257] Recalculating after deleting cell contents (used in formulas) increased from 2 to 10 seconds if multi-threaded

2022-01-23 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144257

stragu  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 CC||stephane.guil...@member.fsf
   ||.org
 Resolution|--- |WORKSFORME

--- Comment #10 from stragu  ---
Just tested on Ubuntu 18.04.6 with LO 7.3.0.2 and it took 2.5 seconds.
Wondering if the fix for Bug 144249 helped here too.

Marking as WFM but please do double-check.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144257] Recalculating after deleting cell contents (used in formulas) increased from 2 to 10 seconds if multi-threaded

2021-09-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144257

Xisco Faulí  changed:

   What|Removed |Added

 CC||xiscofa...@libreoffice.org
   Priority|high|medium

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144257] Recalculating after deleting cell contents (used in formulas) increased from 2 to 10 seconds if multi-threaded

2021-09-15 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144257

Timur  changed:

   What|Removed |Added

   Priority|medium  |high

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144257] Recalculating after deleting cell contents (used in formulas) increased from 2 to 10 seconds if multi-threaded

2021-09-03 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144257

Telesto  changed:

   What|Removed |Added

 CC||l.lu...@collabora.com,
   ||michael.me...@collabora.com

--- Comment #9 from Telesto  ---
Adding CC: to Michael Meeks (based on comment 6)
Adding CC: to Luboš Luňák  (based on comment 2) & his work on the FormulaGroup
code

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144257] Recalculating after deleting cell contents (used in formulas) increased from 2 to 10 seconds if multi-threaded

2021-09-03 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144257

--- Comment #8 from Telesto  ---
Would someone mind to verify my Windows bibisect result, please. There might
well be a difference between Windows & Linux...

I find it pretty particular that both bibisects point (Linux/Win) both point to
"FormulaGroups" code, only different code..  

Also the 'bug' at bug 144250 points to yet again the FormulaGroups code, but
again different commit. 


It's my impression that for somehow a recalculation is trigger followed (or
together with) a by row height recalculation. But well I could be totally
wrong...

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144257] Recalculating after deleting cell contents (used in formulas) increased from 2 to 10 seconds if multi-threaded

2021-09-03 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144257

Timur  changed:

   What|Removed |Added

   Keywords|regression  |

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144257] Recalculating after deleting cell contents (used in formulas) increased from 2 to 10 seconds if multi-threaded

2021-09-03 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144257

Timur  changed:

   What|Removed |Added

Summary|Recalculating after |Recalculating after
   |deleting cell increased |deleting cell contents
   |from 2 to 10 seconds if |(used in formulas)
   |multi-threaded  |increased from 2 to 10
   ||seconds if multi-threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.