[Libreoffice-bugs] [Bug 148778] Librecalc memory likage - it cannot empty memory

2022-04-29 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=148778

--- Comment #9 from elias estatistics  ---
I like open source programs.
and i thank you for your time for creating a such wonderful product.

However, i think this problem is very serious (low mem systems almost will hung
as it happened previously to me often).

You must have a very big RED sign when someone is downloading and using this
program cause this may cause computer problems. And he/she must be aware of
that problem in order to watch his/her memory when is reaching full... in order
to shutting down librecalc 

(note: why when i terminate libre calc also libre writer and all the other
libre apps terminate too? this is bug too?) 

I ate many hours to find out what was causing my system to hung up. 

Until now, the 2 most serious bugs of Libre calc are not solved:
a) memory problem 
b) adapt height row

Both causing a lot of work hours lost for me and possibly for many other people
that are formula-calc oriented with large tables. 

Hopefully, by upgrading memory solved in part the mem problem for now. 
For (b) problem, no solution 

i know that you offer your free time, and this is suburb. however, If it is
hard to fix this bug, put a warning sign please... (or tell them to have mem
>12GB otherwise hungs may occur)

sincerely,
Elias the vegan, for animals

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

[Libreoffice-bugs] [Bug 148778] Librecalc memory likage - it cannot empty memory

2022-04-29 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=148778

Michael Warner  changed:

   What|Removed |Added

 Resolution|--- |WONTFIX
 Status|UNCONFIRMED |RESOLVED

--- Comment #8 from Michael Warner  ---
I think this is just another example of the memory fragmentation problem, which
has been reported before. See, for example, here: 
https://bugs.documentfoundation.org/show_bug.cgi?id=140505#c3

Unfortunately, as it says in that comment, this is a problem which will likely
never be fixed. Therefore I recommend this be closed as WF. 

Workaround is just to restart LibO when memory usage gets too high.

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

[Libreoffice-bugs] [Bug 148778] Librecalc memory likage - it cannot empty memory

2022-04-26 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=148778

QA Administrators  changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

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

[Libreoffice-bugs] [Bug 148778] Librecalc memory likage - it cannot empty memory

2022-04-26 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=148778

--- Comment #7 from QA Administrators  ---
[Automated Action] NeedInfo-To-Unconfirmed

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

[Libreoffice-bugs] [Bug 148778] Librecalc memory likage - it cannot empty memory

2022-04-26 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=148778

--- Comment #6 from elias estatistics  ---
* video for 30 days

* i can give the workbooks if u want, but you may better make something more
meaningful.

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

[Libreoffice-bugs] [Bug 148778] Librecalc memory likage - it cannot empty memory

2022-04-26 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=148778

--- Comment #5 from elias estatistics  ---
Please watch video fully. (i was not very organized at first minutes). 
https://easyupload.io/ss75q1


a) Calc opens with clean profile in safe mode - ~1GB mem (out of 8gb)  
b) I open my formula workbook (A)
c) I open simple html file from calc (B)
d) copy html tables to formula sheet
e) then copy the new produced tables to a 3rd workbook (C)
f) close (B) and save (C)


1) I repeat this process about 9 times or less.
2) It is clearly seen that when open html file and copy tables to formula sheet
about 500mb memory are charged each time (1 time 1GB !)
3) When finished, I closed ALL workbooks except the simplest one (C)
4) C workbook had only 1 sheet with tables without formulas... mem at ~5.5GB. 
5) I even delete entirely that sheet with tables, leaving open only an empty
sheet... 
6) mem at 5.5GB for about ~3 whole minutes without even later to goes down to
~1Gb... 


My questions:

a) Even when i copied tables and formulas were calculated, why 500mbs of mem
data were produced? The formula workbook was loaded already... in these 500mbs
of mem, they are saving also every recalculation that is processed previously
from formulas or what? 
---I repeat - i copied about 20-30 text tables ONLYthis is a load of 500mb
of mem?

b) Even when i am closing ALL except the simplest one, memory is not emptied
from CALC why??? Why is keeping past useless data in memory even when only
an empty sheet is open???



Reproduce:
I repeat:
a) make a complicated large formula sheet that produce something from tables...
b) repeat many times this process... and watch memory...
c) then close all workbooks except the simplest one... 
d) memory is not emptied

I think this is a very serious bug cause causing to my computer to hung
cause memory is getting full...

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

[Libreoffice-bugs] [Bug 148778] Librecalc memory likage - it cannot empty memory

2022-04-26 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=148778

m.a.riosv  changed:

   What|Removed |Added

 CC||miguelangelrv@libreoffice.o
   ||rg
 Status|UNCONFIRMED |NEEDINFO
 Ever confirmed|0   |1

--- Comment #4 from m.a.riosv  ---
Please test with a clean profile, Menu/Help/Restart in Safe Mode

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

[Libreoffice-bugs] [Bug 148778] Librecalc memory likage - it cannot empty memory

2022-04-26 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=148778

--- Comment #3 from Telesto  ---
(In reply to elias estatistics from comment #1)
> Created attachment 179765 [details]
> workbench with simple tables.

What I'm I supposed to with this file to reproduce excessive memory usage?

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

[Libreoffice-bugs] [Bug 148778] Librecalc memory likage - it cannot empty memory

2022-04-25 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=148778

--- Comment #2 from elias estatistics  ---
In my machine, i can reproduce, freeze, very well.

I think that it has to do with "adapt-row" topic.

Cause, when i am copying some tables over formula sheet, it may need 1 minute
(!!) in order to copy them

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

[Libreoffice-bugs] [Bug 148778] Librecalc memory likage - it cannot empty memory

2022-04-25 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=148778

--- Comment #1 from elias estatistics  ---
Created attachment 179765
  --> https://bugs.documentfoundation.org/attachment.cgi?id=179765&action=edit
workbench with simple tables.

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