<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 - Range operations setting the values of previously empty cells can not be undone"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114038">114038</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Range operations setting the values of previously empty cells can not be undone
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (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>BASIC
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>jzombi@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=137971" name="attach_137971" title="small spreadsheet demonstrating the bug">attachment 137971</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=137971&action=edit" title="small spreadsheet demonstrating the bug">[details]</a></span>
small spreadsheet demonstrating the bug
In LibreOffice Calc BASIC macros setting the values of empty cell ranges can
not be undone. The new values will remain in the previously empty cells after
pressing undo.
Tested functions, undo does not work after these:
targetRange.setDataArray(valueArray)
targetRange.DataArray = sourceRange.DataArray
Steps to reproduce:
1. create a macro that sets the values in a range of empty cells using the
above functions
2. execute the macro
3. press undo
Expected behaviour: the cells content will be erased after undo, restoring
their original state.
Actual behaviour: the cells content does not change, the values set by the
macro remains there.
See the attached .ods file.
Tested on:
Version: 5.4.3.2
Build ID: 5.4.3-2
CPU threads: 6; OS: Linux 4.13; UI render: default; VCL: kde4;
Locale: hu-HU (hu_HU.UTF-8); Calc: group</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>