I could reproduce the problem too (using the above test file). Strange behavior
indeed.
However, I noted that after saving and closing the file, then re-opening it,
the correct values are displayed (both in Sheet1 and Sheet1_2). Seems to be
primarily a display update problem (on sheet copying).
** Changed in: openoffice.org (Ubuntu)
Status: New => Confirmed
--
OpenOffice Calc shows wrong value for vlookup in copied sheet
https://bugs.launchpad.net/bugs/257446
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
