<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Spreadsheet formula corrupt with 6.1.1.2" href="https://bugs.documentfoundation.org/show_bug.cgi?id=119904#c11">Comment # 11</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Spreadsheet formula corrupt with 6.1.1.2" href="https://bugs.documentfoundation.org/show_bug.cgi?id=119904">bug 119904</a> from <a class="email" href="mailto:tim@tim-passingham.co.uk" title="tim@tim-passingham.co.uk">tim@tim-passingham.co.uk</a> <pre>(In reply to tim from <a href="show_bug.cgi?id=119904#c3">comment #3</a>) > 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. I tried this same change on the other version of this sheet, and it didn't work. The number of rows in that version is many fewer This is even weirder.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>