[Libreoffice-bugs] [Bug 119904] Spreadsheet formula corrupt with 6.1.1.2

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119904

--- Comment #3 from tim at tim-passingham.co.uk ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180916/21994b09/attachment-0001.html>