https://bugs.documentfoundation.org/show_bug.cgi?id=106575
--- Comment #11 from Amit Seal Ami <[email protected]> ---
(In reply to Xisco Faulí from comment #10)
> Could you please mention the steps to reproduce it with the new file?
> better to have a list of steps than a video
I am not sure how it can be reproduced.
I've been using LibreOffice for years, and this is the first time something
like this happened which only affected a few cells. I simply used vlookup to
refer values from one sheet to another the usual way. Later after printing and
checking, - I suddenly found that the values being shown were not correct, even
though the formula was right. The formulas were applied throughout the columns
by double-clicking the cell handler after writing it once.
I provided the file as a sample so that the existence of the bug can be
confirmed. I am providing further details so that it is easier to understand
what is being referred where.
1. The 2ndTrimester sheet contains data related to results, first column Roll
is going to be used as lookup index in vlookup function.
2. The Detailed Sheet is using IFERROR(VLOOKUP()) to get values from
2ndTrimester sheet. It is looking at the roll from the first column, using it
to lookup a particular row in A22 to O60 range in 2ndTrimester Sheet, if
matched - it is taking the value from the specified column, if there is any
error, it is replacing the value with 0.
3. For example, check A16 in Detailed Sheet. The J16 contains the following
formula:
=IFERROR(VLOOKUP($A16,$2ndTrimester.$A$22:$O$60,5,0), 0)
for 1612, the value being of A16, the value of $2ndTrimester.$A$22:$O$60 is
3.75.
However, the value being shown at J16 is ... 0. The same goes for K16, L16,
M16, J17, K17, M17, J18, K18, L18, M18, J19, K19, L19, M19.
An interesting observation is that the bug affected columns seemingly shifted a
row. Here is what I mean shown in this picture: http://imgur.com/a/Hxdq3
I hope this will be informative enough.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
