https://bugs.documentfoundation.org/show_bug.cgi?id=166729
Bug ID: 166729
Summary: Search criteria in Dget function does not accept
reference to value
Product: LibreOffice
Version: 7.4.7.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Hello all,
Top Search criteria (a1:c2)
---------------------------
interet debut fin
<=01.09.2014 >=01.09.2014
Database Table (a7:c20)
------------------------
interet debut fin
0,1219 01.07.2008 31.12.2008
0,1062 01.01.2009 30.06.2009
0,0912 01.07.2009 31.12.2009
0,0912 01.01.2010 30.06.2010
0,0912 01.07.2010 31.12.2010
0,0912 01.01.2011 30.06.2011
0,0937 01.07.2011 31.12.2011
0,0912 01.01.2012 30.06.2012
0,0912 01.07.2012 31.12.2012
0,0887 01.01.2013 30.06.2013
0,0862 01.07.2013 31.12.2013
0,0837 01.01.2014 30.06.2014
0,0827 01.07.2014 31.12.2014
=DGET($A$7:$C$21;"interet";$A$1:$C$2)
-------------
When
b2 Is the string <=01.09.2014
and
c2 ist the string >=01.09.2014
without quoting
the formula returns the right value
When
b2 contains <=$D$2 where $D$2 contains 01.09.2014 as a date type
same for
C2 contains <=$D$2 where $D$2 contains 01.09.2014 as a date type
the function dget gets a #VALUE! error
is this the expected behaviour?
Cheers have a nice week
ced
Steps to Reproduce:
1.Create database and search criteria as in description
2.
3.
Actual Results:
dget returns value error
Expected Results:
Same result as when c2 and b2 have a string value ( with cell date format date)
Reproducible: Always
User Profile Reset: No
Additional Info:
nothing else
--
You are receiving this mail because:
You are the assignee for the bug.
