[Libreoffice-bugs] [Bug 118438] xls tables mixup

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118438

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEEDINFO
     Ever confirmed|0                           |1

--- Comment #2 from Eike Rathke <erack at redhat.com> ---
Lookup how? There are no formulas in the document, using a simple Find or
Find&Replace the cell in C884 is found and there seems to be no other value
1931370121.

If you used the VLOOKUP() function (which isn't anywhere in your document) then
make sure that either the range to be looked up (here the Unique# column) is
sorted ascending if the 4th parameter 'Sort order' is not given or another
value than 0 (for range-lookup), or specify the value 0 as 4th argument fo an
unsorted lookup.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180628/9e30ae7c/attachment.html>