https://bugs.documentfoundation.org/show_bug.cgi?id=119904
--- Comment #11 from [email protected] ---
(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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
