[Libreoffice-bugs] [Bug 95346] XLSX file crashes LibreOffice calc when save or very slow and eats 600 MB to 2 GB of RAM

[bugzilla-daemon]

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

Luboš Luňák  changed:

   What|Removed |Added

 Resolution|DUPLICATE   |WONTFIX

--- Comment #19 from Luboš Luňák  ---
Several sheets contain a value in the last row. The export filter needs to
process all rows because of that and the internal representation needs that
memory. I don't see this pathological case worth the effort of doing something
about it.

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

[Libreoffice-bugs] [Bug 95346] XLSX file crashes LibreOffice calc when save or very slow and eats 600 MB to 2 GB of RAM

[bugzilla-daemon]

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

--- Comment #18 from Timur  ---
Luboš, please explain why it's marked a duplicate of bug 140893 when it's not
resolved with that, still 2,5 GB or RAM in saving. 
Also, you had other patches, so I guess Fixed would be a better status.

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

[Libreoffice-bugs] [Bug 95346] XLSX file crashes LibreOffice calc when save or very slow and eats 600 MB to 2 GB of RAM

[bugzilla-daemon]

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

--- Comment #17 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/4e279e8c4986ca3de79bea2216c5783cb113a5bb

reuse a vector instead of repeatedly creating it (tdf#95346)

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 95346] XLSX file crashes LibreOffice calc when save or very slow and eats 600 MB to 2 GB of RAM

[bugzilla-daemon]

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

--- Comment #16 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/f8edf0a94e9608d7e7d8ed5fb46036b2ceb71693

try to avoid using map when searching most used item (tdf#95346)

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 95346] XLSX file crashes LibreOffice calc when save or very slow and eats 600 MB to 2 GB of RAM

[bugzilla-daemon]

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

Commit Notification  changed:

   What|Removed |Added

 Whiteboard||target:7.4.0

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

[Libreoffice-bugs] [Bug 95346] XLSX file crashes LibreOffice calc when save or very slow and eats 600 MB to 2 GB of RAM

[bugzilla-daemon]

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

Luboš Luňák  changed:

   What|Removed |Added

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

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


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

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

[Libreoffice-bugs] [Bug 95346] XLSX file crashes LibreOffice calc when save or very slow and eats 600 MB to 2 GB of RAM

[bugzilla-daemon]

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

--- Comment #14 from paulyste...@web.de ---
seems ok with also 10 sec

in 7.0.0 beta2 x64 in win 10 x64

-- 
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 95346] XLSX file crashes LibreOffice calc when save or very slow and eats 600 MB to 2 GB of RAM

[bugzilla-daemon]

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

--- Comment #13 from b.  ---
save as xlsx has a slow point of about 10 sec. with below ver, but no mem
problem or crash, 

wouldn't have commented but if the document contains real world data - didn't
test but looks like - id recommend to pull it back, in many states spreading of
such private information is a verdict ... 

Version: 7.0.0.0.alpha1
Build ID: 6a03b2a54143a9bc0c6d4c7f1...
CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: gtk3; 
Locale: de-DE (en_US.UTF-8); UI: 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 95346] XLSX file crashes LibreOffice calc when save or very slow and eats 600 MB to 2 GB of RAM

[bugzilla-daemon]

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

--- Comment #12 from Julien Nabet  ---
Created attachment 158624
  --> https://bugs.documentfoundation.org/attachment.cgi?id=158624=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 95346] XLSX file crashes LibreOffice calc when save or very slow and eats 600 MB to 2 GB of RAM

[bugzilla-daemon]

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

--- Comment #11 from Timur  ---
master 7.0+: 
real0m54,719s
user1m56,268s
sys 0m5,638s

master 7.0+ with file overwrite: 
real0m57,447s
user1m54,335s
sys 0m5,673s

oldest 7.0+ with file overwrite:
real0m54,229s
user1m48,155s
sys 0m5,854s

I guess those numbers confirm what I wrote ,please correct if not.

-- 
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 95346] XLSX file crashes LibreOffice calc when save or very slow and eats 600 MB to 2 GB of RAM

[bugzilla-daemon]

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

Timur  changed:

   What|Removed |Added

 Resolution|WORKSFORME  |---
 Status|RESOLVED|NEW

--- Comment #10 from Timur  ---
I have a slow Linux test system and it takes 50 secs with master
a11c10a83f6fceae6cfb519725d06f8eaf1013fb of yesterday.
And oldest 7.0+ was 60 secs, just slightly better.
Saving from XLSX to XLSX.
I'll set New until retested.

-- 
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 95346] XLSX file crashes LibreOffice calc when save or very slow and eats 600 MB to 2 GB of RAM

[bugzilla-daemon]

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

--- Comment #9 from Buovjaga  ---
Tested saving to XLSX (the original problem) and it only takes like 10 secs, so
WFM is correct status.

Arch Linux 64-bit
Version: 7.0.0.0.alpha0+
Build ID: 08334285ec9c7d5356f4b89192a5fba6e6733328
CPU threads: 8; OS: Linux 5.5; UI render: default; VCL: kf5; 
Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US
Calc: threaded
Built on 8 March 2020

-- 
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 95346] XLSX file crashes LibreOffice calc when save or very slow and eats 600 MB to 2 GB of RAM

[bugzilla-daemon]

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

paulyste...@web.de changed:

   What|Removed |Added

 Resolution|--- |WORKSFORME
 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 95346] XLSX file crashes LibreOffice calc when save or very slow and eats 600 MB to 2 GB of RAM

[bugzilla-daemon]

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

--- Comment #8 from paulyste...@web.de ---
Created attachment 158580
  --> https://bugs.documentfoundation.org/attachment.cgi?id=158580=edit
doc saved as ods in LO 6.4.1.2

doc saved as ods in LO 6.4.1.2 x64 win 10-64

no problem 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 95346] XLSX file crashes LibreOffice calc when save or very slow and eats 600 MB to 2 GB of RAM

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 CC||todven...@suomi24.fi

--- Comment #7 from Buovjaga  ---
Created attachment 150884
  --> https://bugs.documentfoundation.org/attachment.cgi?id=150884=edit
Perf flamegraph of saving

Pretty nice plateaus in there

Arch Linux 64-bit
Version: 6.3.0.0.alpha0+
Build ID: 1fee3f1da6291bfbcd75455512726215d41b3e83
CPU threads: 8; OS: Linux 5.0; UI render: default; VCL: gtk3; 
Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US
Calc: threaded
Built on 18 April 2019

-- 
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 95346] XLSX file crashes LibreOffice calc when save or very slow and eats 600 MB to 2 GB of RAM

[bugzilla-daemon]

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

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

   What|Removed |Added

 Blocks||108897, 122652


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker
https://bugs.documentfoundation.org/show_bug.cgi?id=122652
[Bug 122652] [META] Memory problems in LibreOffice
-- 
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 95346] XLSX file crashes LibreOffice calc when save or very slow and eats 600 MB to 2 GB of RAM

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 CC||todven...@suomi24.fi

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

>From saving

Arch Linux 64-bit
Version: 6.2.0.0.alpha0+
Build ID: 8b1501d80dc9d3f42c351c6e026fa737e116cae5
CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: gtk3_kde5; 
Locale: fi-FI (fi_FI.UTF-8); Calc: threaded
Built on 23 September 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 95346] XLSX file crashes LibreOffice calc when save or very slow and eats 600 MB to 2 GB of RAM

[bugzilla-daemon]

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

Korrawit Pruegsanusak  changed:

   What|Removed |Added

 Attachment #119985|application/force-download  |application/vnd.openxmlform
  mime type||ats-officedocument.spreadsh
   ||eetml.sheet

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