[Libreoffice-bugs] [Bug 116514] yield function doesn't accept ref as 1st arg
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Tue Mar 20 15:23:47 UTC 2018
https://bugs.documentfoundation.org/show_bug.cgi?id=116514
--- Comment #2 from Larry <cppljevans at gmail.com> ---
After changing the 1st arg to yield to directly reference the data cell,
it worked. IOW:
=YIELD(B10,B11,B9,B15,100,B12,B2)
returned 8%.
I could have sworn I'd tried that before and got some error msg,
but maybe that was before I changed the format of the B10 and B11
cells to date or something.
Sorry for noise, but I would strongly suggest providing more
helpful error msg than #VALUE!. It's very confusing when
a literal date value, "01/01/2000", works, but a reference
to the same value in a cell doesn't.
--
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/20180320/53bb33ca/attachment.html>
More information about the Libreoffice-bugs
mailing list