Public bug reported:
Binary package hint: gnumeric
To reproduce:
Open a new sheet
- 1/1/2000 --> A1
- 8/1/2000 --> A2
- select A1 and A2 and extend the selection through A10 (which is then 4/3/2000)
- 1 --> B1
- 2 --> B2
- select B1 and B2 and extend the selection through B10 (which is then 10)
- =vlookup($A6,A1:C12,2) --> D6 (result is, correctly, 6)
Now the problem: extend the region selectioni n the above formula like this:
- =vlookup($A6,A1:C25,2) --> D6 (result is, incorrectly, 0)
Apparently, if the region contains more empty rows than filled rows, the
result is zero.
This happens with Gnumeric 1.8.3 (downloaded from Ubuntu) and 1.9.3 (downloaded
from Debian).
However, Gnumeric 1.8.2 (downloaded from Ubuntu) does not have this problem.
** Affects: gnumeric (Ubuntu)
Importance: Undecided
Status: New
--
vlookup broken for big areas
https://bugs.launchpad.net/bugs/313670
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
