[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 #11 from tim at tim-passingham.co.uk ---
(In reply to tim from comment #3)
> 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.

-- 
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/27924b2b/attachment-0001.html>