<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 - FILESAVE incorrect value for conditionalformatting srqef?"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=128462">128462</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILESAVE incorrect value for conditionalformatting srqef?
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.2.7.2 release
</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>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>mark.dufour@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>for a certain private document, libreoffice saves the following
conditionalformatting:
<conditionalFormatting sqref="I42,G42:G50">
but unfortunately this is rejected by the openpyxl library as being invalid:
<a href="https://bitbucket.org/openpyxl/openpyxl/issues/1358/conditionalformatting-issue-libreoffice">https://bitbucket.org/openpyxl/openpyxl/issues/1358/conditionalformatting-issue-libreoffice</a>
I personally can't find any documentation about what the exact format should
be, or what the above value indicates precisely.
the problem goes away when loading and saving the file again, but it would
still be nice to know if this can still occur and that both projects agree on
what is valid.. ^^</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>