[Libreoffice-bugs] [Bug 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2022-03-06 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

Luboš Luňák  changed:

   What|Removed |Added

 CC||william.gathoye@libreoffice
   ||.org

--- Comment #35 from Luboš Luňák  ---
*** Bug 122040 has been marked as a duplicate of this bug. ***

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

[Libreoffice-bugs] [Bug 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2022-02-21 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

Xisco Faulí  changed:

   What|Removed |Added

 Status|RESOLVED|VERIFIED

--- Comment #34 from Xisco Faulí  ---
XLSX file takes

real0m13,726s
user0m13,826s
sys 0m0,211s

in

Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: 0723b41bed9bb4ad50d2993744a60177966d1a21
CPU threads: 8; OS: Linux 5.10; UI render: default; VCL: gtk3
Locale: es-ES (es_ES.UTF-8); UI: en-US
Calc: threaded

while the ODS takes

real0m24,153s
user0m24,177s
sys 0m0,189s

@Luboš Luňák, thanks for fixing this issue!!

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

[Libreoffice-bugs] [Bug 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2022-02-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

Luboš Luňák  changed:

   What|Removed |Added

 Status|REOPENED|RESOLVED
 Resolution|--- |FIXED

--- Comment #33 from Luboš Luňák  ---
This now needs 15-20s here. With Noel's reverted change it could get somewhere
to 12s, but somebody would need to figure out comment #28 first. Let's call
this good enough.

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

[Libreoffice-bugs] [Bug 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2022-02-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

--- Comment #32 from Commit Notification 
 ---
Luboš Luňák committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/0d402556af53790adb06380b4b04ea421d14d09e

fix usage of std::lower_bound() in SfxItemPool (tdf#81765)

It will be available in 7.4.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] [Bug 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2022-02-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

Commit Notification  changed:

   What|Removed |Added

 Whiteboard|BSA target:6.3.0|BSA target:6.3.0
   ||target:7.4.0

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

[Libreoffice-bugs] [Bug 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2022-02-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

--- Comment #31 from Luboš Luňák  ---
*** Bug 135215 has been marked as a duplicate of this bug. ***

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

[Libreoffice-bugs] [Bug 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2022-02-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

Luboš Luňák  changed:

   What|Removed |Added

 Resolution|DUPLICATE   |---
 Status|RESOLVED|REOPENED

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

[Libreoffice-bugs] [Bug 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2022-02-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

Luboš Luňák  changed:

   What|Removed |Added

 Status|REOPENED|RESOLVED
 CC||l.lu...@collabora.com
 Resolution|--- |DUPLICATE

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


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

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

[Libreoffice-bugs] [Bug 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2021-02-19 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

NISZ LibreOffice Team  changed:

   What|Removed |Added

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

-- 
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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-05-03 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

--- Comment #29 from Xisco Faulí  ---
back to

real3m44,168s
user3m36,107s
sys 0m4,511s

in

Version: 6.3.0.0.alpha0+
Build ID: f20810f7829d9f3b7167df316e1303810b746366
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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-05-03 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

--- Comment #28 from Noel Grandin  ---
Attaching the IRC discussion of this problem 

May 02 14:10:15so of the items we stick into pools we modify
all over the place
May 02 14:10:20s/so/some
May 02 14:10:39 noelgrandin, that sounds very wrong
May 02 14:11:44mst___, ScPatternAttr 
May 02 14:12:17and of course there are the SvxFieldItem things
that editeng likes to modify
May 02 14:12:29 *   mst___ is surprised that such horrible abuse of
interface contract is in sc, not sw...
May 02 14:13:12I think its a case of (a)busing the
de-duplicate functionality they have
May 02 14:13:25  noelgrandin: where does that modify items in the pool?
May 02 14:14:27erAck, ScPatternAttr ends up in a pool, and
ScPatternAttr extends SfxSetItem, and lots of places (1500+ lines) call
GetItemSet() on it and modify stuff inside it, and it's operator== is dependant
on it's contents
May 02 14:17:00which was not a problem when the code would
always scan all the ScPatternAttr's in a pool to find a match, but as soon as I
tried to make the scanning smarter...
May 02 14:19:21 *   erAck doesn't quite understand.. and doesn't have time
to spend hours to dig into it now
May 02 14:21:11erAck, pool contain items, and when we add an
item, we attempt to match against an existing item (de-duplicate for memory
saving I guess). that process of matching becomes O(n^2) when loading certain
documents. I made the scanning faster by sorting the list. But that sorting
fails because various code likes to modify the ScPatternAttr that are inside a
pool, resulting in an unsorted list inside the pool
May 02 14:23:44 noelgrandin: perhaps good to have some
stack-traces from a hardware watchpoint of the state being changed (?) =)
May 02 14:24:59mmeeks, it gets changed from tons of places, I
have a 1500+ line patch where I tried to move the changing inside the class so
I could trigger a manual re-sort of the cached items in the pool.
May 02 14:25:02  noelgrandin: so what you call a pool is actually the
SfxItemSet?
May 02 14:25:20erAck, no, the SfxItemSet is itself also an
item in a pool 
May 02 14:25:41erAck, sorry, that should be SfxSetItem (which
contains an SfxItemSet)
May 02 14:25:53all rather confusing
May 02 14:27:10anyhow, just a load-time perf improvement,
backing it out no big deal

-- 
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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-05-02 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

Noel Grandin  changed:

   What|Removed |Added

 Status|VERIFIED|REOPENED
 Resolution|FIXED   |---

--- Comment #27 from Noel Grandin  ---
Reopen this because I had to revert the major speedup part

-- 
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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-05-02 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

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

https://git.libreoffice.org/core/+/585e0ac43b9bd8a2f714903034e435c84ae3fc96%5E%21

revert part of "tdf#81765 slow loading of .ods"

It will be available in 6.3.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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-04-24 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

Aron Budea  changed:

   What|Removed |Added

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

-- 
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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-04-24 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

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

https://git.libreoffice.org/core/+/943a2f44bdc67cc795e553fd98693dba501ad717%5E%21

tdf#81765 slow loading of .ods with >1000 of conditional formats, part 4

It will be available in 6.3.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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-04-23 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

--- Comment #24 from Aron Budea  ---
Opening the XLS with today's daily build in Windows takes ~20s for me, nice
improvement!

(In reply to Commit Notification from comment #15)
> https://git.libreoffice.org/core/+/
> 003d11f410b7e515981b3efbd65d936d94d87121%5E%21
> 
> tdf#81765 slow loading of .ods with >1000 of conditional formats
Let's mention the follow-up fix as well:
https://cgit.freedesktop.org/libreoffice/core/commit/?id=1e3d0a57689006cd7244481958025177c01e4d09
author  Noel Grandin  2019-04-23
11:23:36 +0200
committer   Noel Grandin  2019-04-23
19:56:53 +0200

fix bad comparison in StrCmp/StrLess

-- 
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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-04-23 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

--- Comment #23 from Xisco Faulí  ---
Checked again in

Version: 6.3.0.0.alpha0+
Build ID: 0a04150b6eefb5feb7ecefaa5cd63dbac8c1574f
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

and the time measure is even better for me ( tried a few times )

real0m22,981s
user0m22,592s
sys 0m0,316s

-- 
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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-04-23 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

Xisco Faulí  changed:

   What|Removed |Added

 CC||tagishsi...@gmail.com

--- Comment #22 from Xisco Faulí  ---
*** Bug 115488 has been marked as a duplicate of this bug. ***

-- 
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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-04-22 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

Xisco Faulí  changed:

   What|Removed |Added

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

-- 
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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-04-22 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

Xisco Faulí  changed:

   What|Removed |Added

 CC||user1...@bk.ru

--- Comment #21 from Xisco Faulí  ---
*** Bug 61484 has been marked as a duplicate of this bug. ***

-- 
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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-04-22 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

Xisco Faulí  changed:

   What|Removed |Added

 Status|RESOLVED|VERIFIED

--- Comment #20 from Xisco Faulí  ---
(In reply to Xisco Faulí from comment #9)
> ODS file takes
> 
> real  3m20,457s
> user  3m19,592s
> sys   0m0,441s

now it takes

real0m28,094s
user0m27,225s
sys 0m0,398s

in

Version: 6.3.0.0.alpha0+
Build ID: e913727c7ee3af0bb4031c6829abfb3373306492
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

the XLSX takes

real0m29,372s
user0m29,097s
sys 0m0,380s

@Noel, thanks a lot for the huge improvements 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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-04-21 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

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

https://git.libreoffice.org/core/+/aae39e5dbfde76726e3ad6a2e99874490515da58%5E%21

tdf#81765 slow loading of .ods with >1000 of conditional formats, part 3

It will be available in 6.3.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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-04-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

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

https://git.libreoffice.org/core/+/c757117afb398277a46e79ba22066c5bbf2c9f72%5E%21

tdf#81765 slow loading of .ods with >1000 of conditional formats, part 2

It will be available in 6.3.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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-04-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

--- Comment #17 from Telesto  ---
(In reply to Noel Grandin from comment #16)
> I've got a couple of small tweaks still coming for this, but with the time
> now under 15s for me, I consider this closed

Nice, many thanks Noel!

-- 
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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-04-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

Noel Grandin  changed:

   What|Removed |Added

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

--- Comment #16 from Noel Grandin  ---
I've got a couple of small tweaks still coming for this, but with the time now
under 15s for me, I consider this closed

-- 
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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-04-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

--- 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/+/003d11f410b7e515981b3efbd65d936d94d87121%5E%21

tdf#81765 slow loading of .ods with >1000 of conditional formats

It will be available in 6.3.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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-04-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

Buovjaga  changed:

   What|Removed |Added

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

-- 
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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-04-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

--- Comment #14 from Noel Grandin  ---
buovjava, that was just laying the groundwork, haven't landed the real
improvement yet :-)

-- 
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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-04-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

--- Comment #13 from Buovjaga  ---
Did a new build just now and the XLSX opening is significantly improved.

Opening XLSX

6.3.0:
real1m33,838s
user1m25,919s
sys 0m2,076s

6.2.2:
real2m1,142s
user2m0,547s
sys 0m0,272s

Opening ODS:

6.3.0:
real1m34,639s
user1m34,088s
sys 0m0,285s

6.2.2:
real1m36,199s
user1m35,475s
sys 0m0,286s

-- 
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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-04-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

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

https://git.libreoffice.org/core/+/bcb0c9b4bee1d943d9c60f9d4512dba901f85f54%5E%21

flatten SfxItemPool_Impl (tdf#81765 related)

It will be available in 6.3.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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-04-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

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

https://git.libreoffice.org/core/+/ec7ba61a6164c805f5a71b077715b7e1521a2d62%5E%21

simplify SfxPoolItemArray_Impl (tdf#81765 related)

It will be available in 6.3.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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-04-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

Commit Notification  changed:

   What|Removed |Added

 Whiteboard|BSA |BSA target:6.3.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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-04-02 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

--- Comment #10 from Xisco Faulí  ---
(In reply to Xisco Faulí from comment #9)
> ODS file takes
> 
> real  3m20,457s
> user  3m19,592s
> sys   0m0,441s
> 
> in
> 
> Version: 5.2.0.0.alpha1+
> Build ID: 5b168b3fa568e48e795234dc5fa454bf24c9805e
> CPU Threads: 4; OS Version: Linux 4.15; UI Render: default; 
> Locale: ca-ES (ca_ES.UTF-8)
> 
> @Noel, seeing your recent optimizations, I thought you might be interested
> in this issue...

I meant

Version: 6.3.0.0.alpha0+
Build ID: 3b518953a8141b0d5043c2f3996a92956fdc3a47
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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-04-02 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

Xisco Faulí  changed:

   What|Removed |Added

 CC||noelgran...@gmail.com,
   ||xiscofa...@libreoffice.org

--- Comment #9 from Xisco Faulí  ---
ODS file takes

real3m20,457s
user3m19,592s
sys 0m0,441s

in

Version: 5.2.0.0.alpha1+
Build ID: 5b168b3fa568e48e795234dc5fa454bf24c9805e
CPU Threads: 4; OS Version: Linux 4.15; UI Render: default; 
Locale: ca-ES (ca_ES.UTF-8)

@Noel, seeing your recent optimizations, I thought you might be interested in
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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2019-02-15 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

Roman Kuznetsov <79045_79...@mail.ru> 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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2018-09-22 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

Buovjaga  changed:

   What|Removed |Added

 CC||todven...@suomi24.fi

--- Comment #8 from Buovjaga  ---
Created attachment 145108
  --> https://bugs.documentfoundation.org/attachment.cgi?id=145108=edit
Callgrind output from master

Callgrind from opening the XLSX in case it might help

Arch Linux 64-bit
Version: 6.2.0.0.alpha0+
Build ID: 0ffa7a733d834647dfd59b864c52a015028822b6
CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: gtk3_kde5; 
Locale: fi-FI (fi_FI.UTF-8); Calc: threaded
Built on September 21st 2018

-- 
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 81765] FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump

2018-07-25 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=81765

Timur  changed:

   What|Removed |Added

Summary|FILEOPEN: slow loading in   |FILEOPEN: slow loading in
   |minutes of .ods and .xlsx   |minutes of .ods and .xlsx
   |with >1000 of conditional   |with >1000 of conditional
   |formats |formats, also dump

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