<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 - Loss of data in every sheet after conditional formatting"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116057">116057</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Loss of data in every sheet after conditional formatting
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.1.6.2 release
</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>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>keumar76@hotmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
When manipulating conditional formatting in one of my sheets, I realised that I
lost all the data (basically on the same amount of lines on which I'm applying
or deleting the CF) in every other sheet (looks like just the ones before not
after). The data above those lines stayed. I tried to check what kind of
operation did that but couldn't solve it. Just noticed that it looks to be when
I deleted some of the CF in the global list.
I could reproduced it in an other file.
Actual Results:
Fill a first sheet with data let's say on 20 lines.
Fill second one with 10 lines. I did it with numbers and applied conditional
formatting with colour scale on each line so that 0 got red, 1 yellow and 2
green.
Then try to modify the CF on some lines or go in the list and delete it for
some lines.
Expected Results:
Go back to the first sheet and the 10 first lines should have been deleted. If
you create more sheets (before the one you're applying CF), the data should
disappear as well.
Reproducible: Always
User Profile Reset: No
Additional Info:
Well don't get why the CF on one sheet can have an impact on other sheets. I
almost lost the data on a very important file because I was only working on
this specific sheet without checking all the others before saving and closing.
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/64.0.3282.168 Safari/537.36 OPR/51.0.2830.40</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>