Created attachment 140732 [details]
spreadsheet showing bug
returns 8%; however, this cell(b19):
returns #VALUE! despite $C$19 containing:
as result of formula:
The b19 result should be same as b18 result.
On Win7 with LO 6.0.2, I could reproduce this.
Eike: thought you might be interested in this one.
After changing the 1st arg to yield to directly reference the data cell,
it worked. IOW:
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.
The issue was having the format between quotation marks in B3 = “YYYY-MM-DD", gives a text date inside quotes C19= "2000-01-01" , what it's not a valid text to convert in date value.