Same behaviour, in my Ubuntu 10.04 with OpenOffice 3.2 of Oracle, in
english (DSUM) and spanish (BDSUM).
To reproduce error, put in a new Sheet
1A B C D E F
2 A B
3 10 1 A A
4 20 2 >20 >20
5 30 3 >20
CONCATENATE(">2","0")
6 40 4
7 50 5 20 0
8 60 6 DSUM(B2:C8,"B",D3:D4) DSUM(B2:C8,"B",E3:E4)
In the column D I wrote >20 with keys, but in column E I wrote the equation
=CONCATENATE(">2","0") in cell E4.
The results is 20 in manual and 0 with concatenate equation.
--
DSUM() does not recognise concatenated values for search criteria in OO 3.2
(does in 3.1 and windows OO 3.2)
https://bugs.launchpad.net/bugs/587209
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
