[Libreoffice-bugs] [Bug 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow

[bugzilla-daemon]

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

OfficeUser  changed:

   What|Removed |Added

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

--- Comment #20 from OfficeUser  ---
Can confirm that format brush and copy-and-paste now work as expected with:

Version: 6.1.0.0.alpha0+
Build ID: f3e8d0fb317090aade384784a1e16a8c8afe3437
CPU threads: 8; OS: Linux 4.4; UI render: default; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time:
2018-03-22_08:34:58
Locale: de-DE (de_DE.UTF-8); Calc: group


I expect that it has been fixed by the patch of Comment 16.

-- 
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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow

[bugzilla-daemon]

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

--- Comment #19 from Xavier Van Wijmeersch  ---
Can not reproduce with

Version: 6.1.0.0.alpha0+
Build ID: 3939e10c515364cb9ef0a089d3db667aed0aa5ea
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

but can reproduce with

Version: 6.0.4.0.0+
Build ID: 4cb868abaf789afe3f2b4bc65454c21c08666a78
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow

[bugzilla-daemon]

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

Thomas Lendo  changed:

   What|Removed |Added

 Blocks|107318  |114912


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=107318
[Bug 107318] [META] Clone formatting (aka Format Paintbrush) and Clear direct
formatting issues
https://bugs.documentfoundation.org/show_bug.cgi?id=114912
[Bug 114912] [META] Clone formatting (aka Format Paintbrush) 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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow

[bugzilla-daemon]

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

Rainer Bielefeld Retired  changed:

   What|Removed |Added

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

-- 
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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow

[bugzilla-daemon]

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

--- Comment #18 from Xisco Faulí  ---
(In reply to Kevin Suo from comment #16)
> I just see a commit on master:
> https://cgit.freedesktop.org/libreoffice/core/commit/
> ?id=ea55492a6e55290d92a59324b3cb31ed958981ab
> 
> This commit may be a fix for this issue, but I am not sure. Maybe someone
> with a self-built master can update the build and test.

For the next time, you can also test it in the 'updater' builds from
http://dev-builds.libreoffice.org/daily/master/, which are normally updated
daily ;-)

-- 
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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow

[bugzilla-daemon]

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

--- Comment #17 from Mike Kaganski  ---
(In reply to Kevin Suo from comment #16)

That is not a fix for this, rather it's related to bug 87274.

-- 
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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow

[bugzilla-daemon]

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

Kevin Suo  changed:

   What|Removed |Added

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

-- 
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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow

[bugzilla-daemon]

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

Kevin Suo  changed:

   What|Removed |Added

 CC||suokunl...@126.com

--- Comment #16 from Kevin Suo  ---
I just see a commit on master:
https://cgit.freedesktop.org/libreoffice/core/commit/?id=ea55492a6e55290d92a59324b3cb31ed958981ab

This commit may be a fix for this issue, but I am not sure. Maybe someone with
a self-built master can update the build and test.

-- 
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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow

[bugzilla-daemon]

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

Mike Kaganski  changed:

   What|Removed |Added

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

-- 
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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow

[bugzilla-daemon]

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

Pénzes Dávid  changed:

   What|Removed |Added

 Blocks||87351


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=87351
[Bug 87351] [META] Conditional formatting 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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

Summary|Using format brush to copy  |Using format brush to copy
   |conditional formats to some |conditional formats to some
   |rows generates thousands|rows generates thousands
   |(?) additional conditional  |(?) additional conditional
   |formats making the  |formats making the
   |spreadsheet unusable slow   |spreadsheet unusable slow
   |(feels like application |
   |crash)  |

-- 
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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow ( feels like app

[bugzilla-daemon]

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

--- Comment #15 from OfficeUser  ---
I just have exported an "Slow.xls" and opened it in Excel.

Result: Excel also hangs while opening these bloated files. I had to kill
Excel. So in my opinion we have to fix a). But a) is already reported as Bug
87274.

Since this bug report (Bug 103312) has a higher importance and a focus on the
impacts of this bug I suggest to set Bug 87274 as duplicate of this bug report
(Bug 103312).

Details on how to implement a solution for a) may be copied from Bug 87274 (by
m.a.riosv).

-- 
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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow ( feels like app

[bugzilla-daemon]

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

--- Comment #14 from m.a.riosv  ---
This is one of that matters, really annoying, making an amazing tool like is
Conditional Format after a great development nearly to unusable on many cases.

In my order of importance:

1- The break of the CF cell ranges with copy/paste/move/brush, with no tool to
reunify.
2- It's slow enter data on cells that are part of a CF, curious it doesn't
happen pasting, specially visible on hard spreadsheet, needs autocalculate
active.
3- No option to move the conditions down/up
4- No option to copy/duplicate a condition
5- Difficult duplicate a CF, it needs to be done with a workaround.

Perhaps a good candidate for GSoc.

-- 
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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow ( feels like app

[bugzilla-daemon]

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

--- Comment #13 from Heiko Tietze  ---
(In reply to OfficeUser from comment #12)
> I am not sure if it a good idea to separate both problems.

Let's wait for someone who fixes the problem that opening your examples almost
crashes the app. I was trying during the latest hackfest, sitting next to
Xisco, and it took some minutes (i7-4712 CPU) while Xiscos PC (i5?) refused to
do that. Once the doc is open any operation takes seconds to minutes, for
example scrolling. We made just sure that you don't have a large number of data
or styles to exclude this reason. So please be patient (and try another way of
conditional formatting meanwhile).

-- 
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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow ( feels like app

[bugzilla-daemon]

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

--- Comment #12 from OfficeUser  ---
I am not sure if it a good idea to separate both problems. I don't even know if
b) can be fixed or lets say optimized. So fixing a) (the root cause) may be the
only solution.

Do you know how Excel performs on b) (opening bloated documents)?

-- 
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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow ( feels like app

[bugzilla-daemon]

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

--- Comment #11 from Xisco Faulí  ---
I can confirm back to 4.1.0.0.alpha0+ that calc hangs at import time and it's
impossible to work with the attached spreadsheet.
Please report each problem in different bugs.

-- 
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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow ( feels like app

[bugzilla-daemon]

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

--- Comment #10 from OfficeUser  ---
@Xisco Fauli

Thanks. But which behavior can you confirm with that build?

We have to problems here:

a) Format brush and copy paste are bloating the spreadsheets with "thousands"
of conditional formattings.

b) An already "bloated" spreadsheet (like the one attached) cannot be used
anymore because of EXTREME bad performance.

-- 
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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow ( feels like app

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

   Keywords||bibisectRequest, perf,
   ||regression
   Priority|medium  |high
Version|5.2.2.2 release |4.1 all versions
   Severity|normal  |major

--- Comment #9 from Xisco Faulí  ---
Reproduced in

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

and 

Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)

but not in

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

-- 
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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow ( feels like app

[bugzilla-daemon]

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

Heiko Tietze  changed:

   What|Removed |Added

 CC||tietze.he...@gmail.com,
   ||xiscofa...@libreoffice.org

--- Comment #8 from Heiko Tietze  ---
I can confirm that opening attachment 1 takes minutes on a fairly fast
computer. Any operation in the document such as scrolling is almost impossible.

Version: 5.3.0.3
Build ID: 5.3.0-1
CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: kde4; Layout
Engine: new; 
Locale: de-DE (en_US.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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow ( feels like app

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 CC||miguelangelrv@libreoffice.o
   ||rg

--- Comment #7 from m.a.riosv  ---
There is an enhancement rquest for this matter.

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

-- 
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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow ( feels like app

[bugzilla-daemon]

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

OfficeUser  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow ( feels like app

[bugzilla-daemon]

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

--- Comment #6 from OfficeUser  ---
Created attachment 128099
  --> https://bugs.documentfoundation.org/attachment.cgi?id=128099=edit
Slow2.ods

-- 
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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow ( feels like app

[bugzilla-daemon]

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

--- Comment #5 from OfficeUser  ---
Same bug happens if I copy and paste a hole single row:

- open the attached spreadsheet "Slow2.ods"

- click on Format/Conditional Formatting/Manage... and note there is a single
range item A2:K2.

- Close the Manage Conditional Formatting window

- select row 2

- press ctrl+c

- paste into row 3

- click on Format/Conditional Formatting/Manage... and note there now hundrets
of range items for just one additional rows

When pasting some more rows, the document becomes unusable slow!

-- 
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 103312] Using format brush to copy conditional formats to some rows generates thousands (?) additional conditional formats making the spreadsheet unusable slow ( feels like app

[bugzilla-daemon]

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

OfficeUser  changed:

   What|Removed |Added

Summary|Conditional formattings |Using format brush to copy
   |make simple spreadsheet |conditional formats to some
   |extremely slow (feels like  |rows generates thousands
   |application crash)  |(?) additional conditional
   ||formats making the
   ||spreadsheet unusable slow
   ||(feels like application
   ||crash)

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