https://bugs.documentfoundation.org/show_bug.cgi?id=157896
Bug ID: 157896
Summary: CALC: VLOOKUP can't find numbers formatted as text by
import dialog
Product: LibreOffice
Version: 7.6.2.1 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 190389
--> https://bugs.documentfoundation.org/attachment.cgi?id=190389&action=edit
example with data
When I paste Tab separated columns with some order information I use text
import dialog and tell it to treat column with order numbers as text (since
some companies use preceding zeros, and normal paste drops them).
However, this causes the VLookup to fail to find data. It is caused by
apostrophe (or single quote mark, char 39) inserted in front of order number,
but this apostrophe is invisible in formula bar under cell formatting set by
text import dialog. Only after cloning formatting from cell unaffected by text
import dialog can I see this apostrophe. This makes determining why VLookup
fails quite frustrating.
Now I don't know if any of this should be considered a wrong behavior, but I
think that VLookup should be enhanced to handle data regardless of that
preceding apostrophe, since it is there only for formatting purposes.
--
You are receiving this mail because:
You are the assignee for the bug.
