Created attachment 49248 [details]
Spreadsheet created in LibO3.3.2
Data ranges created in prior versions of LibreOffice (by Data--> define range)show up in the navigator as Database ranges.
However, when they are used in formulas (e.g.> Vlookup) they seem to be not recognized and return #Name?.
The attached document was created in LibO 3.3.3 and contains a datarange (A_testrange). Cell E3 contains =VLOOKUP(D3;A_testrange;2;0) and returns 14 when saved in LibO 3.3.3 but contains =VLOOKUP(D3;#NAME?;2;0) when opened in LibO3.4.2
Confirmed with [Win2K LibreOffice 3.4.2 OOO340m1 (Build:201)]
I'll have a look at it
It seems it is a bug in our formula api. We have some other bug reports regarding database ranges in formulas already.
I hope I will have time to fix this for 3.4.3
fixed already, should be in 3.4.3 and 3.5
(In reply to comment #4)
> fixed already, should be in 3.4.3 and 3.5
Can't wait to see it. Looking forward to put 3.4.3 in production use in August-September.
*** Bug 40019 has been marked as a duplicate of this bug. ***