<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Spreadsheet formula corrupt with 6.1.1.2"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=119904#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Spreadsheet formula corrupt with 6.1.1.2"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=119904">bug 119904</a>
from <span class="vcard"><a class="email" href="mailto:tim@tim-passingham.co.uk" title="tim@tim-passingham.co.uk">tim@tim-passingham.co.uk</a>
</span></b>
<pre>I've tried amending the (trivial) formula like:
=IF(G2,C2,"")
in several ways.
Omitting the "" entirely doesn't work (or it did for a moment but then failed
when copying the formula to other cells).
I tried " " instead. This seemed to work until I replaced all the similar
cells and then it went wrong again.
I tried "NA" and that seemed to work, so the formulae are now like:
=IF(G2,C2,"NA")
and so on. Having done this, I then tried " " again, which failed, so went
back to "NA", and that failed as well. Luckily I kept a copy.
This is very weird.</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>