This is ridiculous. I opened this bug over 3 months ago and gave very
detailed information including steps to reproduce and uploaded a
specific example. The bug was confirmed by a third party over a month
ago. I don't understand why it needed to be a bug in 8.10 before 8.10
was even released.
I
I get Err:522 at step 4 when trying to replicate this which is:
522 - Circular reference - Formula refers directly or indirectly to
itself and the Iterations option is not set under Tools - Options -
OpenOffice.org Calc - Calculate.
--
OpenOffice Calc shows wrong value for vlookup in copied
We are closing this bug report because it lacks the information we need
to investigate the problem, as described in the previous comments.
Please reopen it if you can give us the missing information, and don't
hesitate to submit bug reports in the future. To reopen the bug report
you can click on
We are closing this bug report because it lacks the information we need
to investigate the problem, as described in the previous comments.
Please reopen it if you can give us the missing information, and don't
hesitate to submit bug reports in the future. To reopen the bug report
you can click on
Do you still have this problem with openoffice.org 1:2.4.1-11ubuntu2 in
Ubuntu 8.10?
** Changed in: openoffice.org (Ubuntu)
Status: Confirmed = Incomplete
--
OpenOffice Calc shows wrong value for vlookup in copied sheet
https://bugs.launchpad.net/bugs/257446
You received this bug
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).
** Attachment added: Copy Sheet1, and you'll get messed up values.
http://launchpadlibrarian.net/16733824/test_case.ods
--
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
As I stated in the description, the results change based on where you
place the copied Sheet, so you should also try placing the copy before
Sheet1, Sheet3, and at the end. Also in the array portion of the
vlookup, I specified the range as:
Sheet2.$A$1:$B$2
You may want to experiment with:
