https://bugs.freedesktop.org/show_bug.cgi?id=74622
Priority: medium
Bug ID: 74622
Assignee: [email protected]
Summary: In Calc v lookup does not reference a number stored as
text with a preceding ' without reloading
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 4.2.0.4 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 93539
--> https://bugs.freedesktop.org/attachment.cgi?id=93539&action=edit
Source data with preceding '
Hi all,
Please see the attached test case documents.
1) There are source data columns in an xls with numbers stored with a preceding
' select these and copy the data.
2) Open the V looup test case document and past into the top cells enclosed by
the yellow.
Expected behaviour - the v looup fields in below should populate, instead they
remain with status of #NA
Solution - once pasted data into top cells, save the spreadsheet and re-open.
Result is expected behaviour - the #NA has gone and the V lookup works. (No
changes to the cell formatting done by the user).
I have only noticed this from 4.2
--
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
