<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 - The format in (all) cells of a spreadsheet is deleted when undoing the Replace All command in combination with Format."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131430">131430</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>The format in (all) cells of a spreadsheet is deleted when undoing the Replace All command in combination with Format.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.1.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (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>dscheikey@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
When you use the "Undo" command in a spreadsheet, if you have previously used
the Find & Replace command in conjunction with Format, all formats in all cells
of the current spreadsheet will be deleted.
If you only use the simple "Replace" command, the problem does not exist. Only
when using the "Replace All" command the problem appears.
Steps to Reproduce:
In the attached document, you have to use the Find & Replace command (Ctrl+H).
Please activate Format and use "Accent 1" for Find and a format of your choice
for Replace. Then click on "Replace all". You will probably have to click it
twice, because Calc only replaces when the cell is selected. But this is a
different bug! After the format has been replaced please close the dialog. Now
use the Undo command.
Actual Results:
The format in cell D3 is actually reset to the original format "Accent 1". But
all cells in the spreadsheet lose their format.
Expected Results:
The format in cell D3 is actually reset to the original format "Accent 1".
Reproducible: Always
User Profile Reset: No
Additional Info:
See also <a class="bz_bug_link
bz_status_NEW "
title="NEW - Find & Replace all for cell styles in empty cells shows an empty results window"
href="show_bug.cgi?id=112275">Bug 112275</a> - Find & Replace all for cell styles in empty cells shows
an empty results window.</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>