<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - opening ods file (saved in Office 5.3) and adding new data in office 6.0.7.3; pivot table refresh get errors"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122727">bug 122727</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEW
</td>
<td>RESOLVED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - opening ods file (saved in Office 5.3) and adding new data in office 6.0.7.3; pivot table refresh get errors"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122727#c7">Comment # 7</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - opening ods file (saved in Office 5.3) and adding new data in office 6.0.7.3; pivot table refresh get errors"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122727">bug 122727</a>
from <span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>The formula in cell BH2 needs to be changed, it is wrong anyway,
=COUNTIF(J1:AH1;"<>""")
counts cells that do not have a string of " which in this case are all (earlier
versions did not include empty cells there, which was wrong). If that was
supposed to check for not empty string the criteria should had been "<>"""""
instead.
Meant was probably to count cells that are not empty, which would be
=COUNTIF(J1:AH1;"<>")
and results in the desired 13 again.</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>