<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 - Calc has very high memory consumption when dealing with lots of data on multiple worksheets"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116206">116206</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Calc has very high memory consumption when dealing with lots of data on multiple worksheets
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>Inherited From OOo
</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>Keywords</th>
<td>perf
</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>kelemeng@ubuntu.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=140357" name="attach_140357" title="Example file with lots of random data">attachment 140357</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=140357&action=edit" title="Example file with lots of random data">[details]</a></span>
Example file with lots of random data
LibreOffice Calc has very high memory consumption when dealing with lots of
data on multiple worksheets compared to Microsoft Excel. The result is that
Calc is unable to open more complex spreadsheets that work just fine in
Microsoft Excel on the same computer.
Steps to reproduce:
1. Create a new spreadsheet in LibreOffice Calc.
2. Add a simple function (e.g. =RAND()*1000000) to many (tens of thousands) of
cells on the first worksheet.
3. Copy the content of the first Sheet to multiple Sheets.
4. Sum the values from multiple sheets on the last sheet.
4. Save the file as XLSX.
5. Open the file in LibreOffice Calc and in Microsoft Excel.
6. Compare the memory consumption of the two applications.
Actual results:
The memory consumption of LibreOffice Calc is many times higher than the memory
consumption of Microsoft Excel. The memory consumption of Calc is even higher
when opening the XLSX file.
Expected results:
The memory consumption of LibreOffice Calc should be lower when dealing with
lots of data.</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>