[Libreoffice-bugs] [Bug 116514] New: yield function doesn't accept ref as 1st arg

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 116514
           Summary: yield function doesn't accept ref as 1st arg
           Product: LibreOffice
           Version: 5.1.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: cppljevans at gmail.com

Created attachment 140732
  --> https://bugs.documentfoundation.org/attachment.cgi?id=140732&action=edit
spreadsheet showing bug

This cell(b18):

=YIELD("2000-01-01","2002-01-01",0.1,103.63,100,2)

returns 8%; however, this cell(b19):

=YIELD($C$19,"2002-01-01",0.1,103.63,100,2)

returns #VALUE! despite $C$19 containing:

“2000-01-01”

as result of formula:

=TEXT($B$10,$B$3)

The b19 result should be same as b18 result.

-- 
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/45c1a21a/attachment.html>