Created attachment 140732 [details] 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.
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: =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.
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.