<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Undo information for large spreadsheets is memory consuming"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131799">131799</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Undo information for large spreadsheets is memory consuming
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.0.0.0.alpha0+ Master
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>telesto@surfxs.nl
</td>
</tr></table>
<p>
<div>
<pre>Description:
Undo information for large spreadsheets is memory consuming
Steps to Reproduce:
1. Open <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=159234" name="attach_159234" title="Example file">attachment 159234</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=159234&action=edit" title="Example file">[details]</a></span> (<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Hang dragging a large column with basic formula's"
href="show_bug.cgi?id=131791">bug 131791</a>). Preferably after <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Hang dragging a large column with basic formula's"
href="show_bug.cgi?id=131791">bug 131791</a> is fixed,
it's slow as hell at this point
2. Drag columns the different columns to left right (and monitor CPU usage). It
will bump nearly every time with 200-300 MB or so.
Actual Results:
Memory usage increases with 200-300 MB for every change made, caused by undo
information (Tools -> Options -> LibreOfficeDev -> Advanced -> expert
configuration -> Search for Undo and set 100 steps back to 0)
Expected Results:
I'm guessing the actually result are always stored as undo information. I would
be more efficient to store - if possible - only the formula itself. At least
for F-J columns.
This is probably a complicated matter. As there are cells / columns/ rows with
pure 'data' (like column A/B). Cells/ columns/ rows/ with formula's and 'data'
combined. And cells/columns/rows with only a formula.
So extensive strategic optimization will probably make debugging harder and
maybe introduce new (case depended) bugs, which are hard to track down.
However, there must be some basic strategy's to make this more workable.
Especially with the amount of rows/columns/sheets allowed.
Other solutions:
- Reduce undo count for Calc in general or for large sheets
- Ask if undo information should be stored for large operations
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.0.0.0.alpha0+ (x64)
Build ID: 4501a0ba623ad61c5a4e0b807da2e96f0e4ce82c
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win;
Locale: nl-NL (nl_NL); UI-Language: en-US
Calc: CL</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>