https://bugs.freedesktop.org/show_bug.cgi?id=71800
Priority: medium
Bug ID: 71800
Assignee: [email protected]
Summary: Wrong result from LOOKUP
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.1.2.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 89482
--> https://bugs.freedesktop.org/attachment.cgi?id=89482&action=edit
A spreadsheet to generate a printed diary, with fixed entries listed on a
second sheet
Version: 4.1.2.3
Build ID: 40b2d7fde7e8d2d7bc5a449dc65df4d08a7dd38
Spreadsheet function LOOKUP
works as expected except that empty "looked-up" cells display "30" in the
result cell; non-empty entries are copied correctly to the result cells.
Any text entry added to the looked-up array clears ALL the unwanted 30s.
I wondered whether empty cells were being read as numbers and the result
somehow appearing in hex. The look-up array had indeed been formatted as
"number". Correcting this to 'text' format made no difference.
Adding any text, even one space, anywhere in the "look-up" array, even if then
deleted, clears all the 30s. By this means I was able to generate a pdf output
and print the file. Without that manoeuvre, the 30s appeared in the pdf and
thus the print-out.
Is it a clue that the first week of this calendar file does not suffer the
error?
Saving the "corrected" ods file and re-opening it brings back the unwanted 30s.
I attach this file, a 2014 calendar, stripped of the personal info.
--
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
