vlookup always returns #NA; the same problem does not occur with 4.1.5.3-1. The following macro 'VLOOKUP(C10,ProvidersTable,2)' fails 100% of the time and troubleshooting the problem caused several crashes, one reproted separately. 'VLOOKUP(C10,$Providers.$A$2:$D$100,2)' also fails. The spreadsheet is one that I've used for a long time with earlier versions and now fails.
Please, attach a test document. Best regards. JBF
Created attachment 94938 [details] Sample document I thought I attached this...my bad.
Hi Larry, I filed a bug (74622) for a similar issue experienced when referencing data pasted into cells. This has been fixed, but I haven't seen it come through yet, I'm hoping to see it in 4.2.2. David
Indeed, works in version 4.1.5, does not work in version (dev.) 4.2.3.0.0+ under Linux / Ubuntu 13.10 x86-64 Best regards. JBF
I'll take it.
Found the error. Will work on a fix.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=e5802954853a9ec64fb5fec917f8c3b2daba6526 fdo#75642: Add test case for this. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c078d5fef98ba77751b7a9593691d88dfc1c9ba1 fdo#75642: Check the high position block correctly. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
4.2 backport: https://gerrit.libreoffice.org/8573
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=6293d898c16bafeb703129ed0d33857934ab1dfb&h=libreoffice-4-2 fdo#75642: Check the high position block correctly. It will be available in LibreOffice 4.2.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Fixed.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-2-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=b4bba09ba98cfa40d559f98aaf8ae4730c6f075a&h=libreoffice-4-2-3 fdo#75642: Check the high position block correctly. It will be available already in LibreOffice 4.2.3. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Thanks Kohei. Verified Win7x64: Version: 4.2.4.0.0+ Build ID: e1823627f35e4419880769fdd05acddbd0a9c25c TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-03-18_14:25:19 Version: 4.3.0.0.alpha0+ Build ID: 12ae7672f285da1d4c730315e8db23b3396b71cc TinderBox: Win-x86@39, Branch:master, Time: 2014-03-14_00:18:00
*** Bug 76482 has been marked as a duplicate of this bug. ***
Sorry for the delay testing. I tried the same test spreadsheet attached and have the same results with 4.2.3.1.
For me the bug is fixed in version 4.2.4.0.0+ Best regards. JBF
Go it. I misunderstood that it was in 4.2.3. I will confirm when I can test with 4.2.4. Thanks for the help.
(In reply to comment #17) > Go it. I misunderstood that it was in 4.2.3. I will confirm when I can > test with 4.2.4. No, the fix is in 4.2.3 branch but it is newer than 4.2.3 RC1, it will be in the RC2 (4.2.3.2). https://gerrit.libreoffice.org/gitweb?p=core.git;a=shortlog;h=refs/heads/libreoffice-4-2-3 Set back to FIXED. Best regards. JBF
Confirmed. The bug is corrected in 4.2.3.2-3. Thanks.
*** Bug 101988 has been marked as a duplicate of this bug. ***