https://bugs.documentfoundation.org/show_bug.cgi?id=97150
Bug ID: 97150
Summary: VLOOKUP returns wrong data when it is used at many
cells
Product: LibreOffice
Version: 5.0.4.2 rc
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 121951
--> https://bugs.documentfoundation.org/attachment.cgi?id=121951&action=edit
vlookup file whe it is used in many rows
I have a Calc file with two pages. The second one use VLOOKUP on the first
page.
The original file was created in v4.3.5.2 and it's work correctly.
When I open the file in v5.0.4.2 doesn't work correctly. It changes all the
correct values (text) to numbers.
It doesn't work in version 5.0 compiled at 14/01/2016
In the attached file you must go to the second page, I use VLOOKUP at column G.
If you copy one cell that use VLOOKUP to other cell in the same column (or int
he same cell) it changes all the values in that column to numbers.
If you modify the function it's work correctly again (Try to put an space
before the parenthesis)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
