<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 - Conditional formatting breaks on adding then deleting a new sheet"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107289">107289</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Conditional formatting breaks on adding then deleting a new sheet
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>3.3.0 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</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>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>erike4@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
I have an accounting spreadsheet where some fields are changed to a red
background when certain cells are not equal. doing things to other sheets
tends to break these even though the formula, data, and the style are the same.
It is repeatable when I accidently create another sheet (ok) and delete it
(fails).
Steps to Reproduce:
1.create sheet
2.delete sheet
3.
Actual Results:
create a new sheet
delete the sheet
go to original sheet and conditions do not work (in this case all showing
errors ie background standard rather that what is defined in style from
conditional format equation.
Expected Results:
conditions do not work (in this case all showing errors ie background standard
rather that what is defined in style from conditional format equation.
I have found no way to fix except go back to last save and re-apply changes and
I hope not to bump whatever is putting up the create new sheet dialog (i have
arthritis)
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Builds ID: LibreOffice 5.3.2.2
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/57.0.2987.133 Safari/537.36</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>