https://bugs.freedesktop.org/show_bug.cgi?id=74558
Priority: high
Bug ID: 74558
Assignee: [email protected]
Summary: Defect with the VLOOKUP function
Severity: major
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 4.2.0.4 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 93439
--> https://bugs.freedesktop.org/attachment.cgi?id=93439&action=edit
ods file that shows the reported problem
I was editing a spreadsheet created with previous versions of LibreOffice and
modified with the previous version 4.1.4.2. The first sheet of the spreadsheet
contains a summary table, of which cells are filled using the VLOOKUP function.
Attempts to edit cells within the VLOOKUP range referenced by the function
cause the entries in cells N614:N645 to display #N/A. The VLOOKUP function in
cells N646 and below are still good but any attempts to restore the correct
answer to the cells above, for example by pasting the formula (apparently
identical) into the cells N614:N645, does not solve the problem.
If I take the defective spreadsheet and open it in another machine running
version 4.1.4.2., the problem is quickly resolved. A test file that showed this
defect is attached.
--
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
