XLOOKUP Return Value doesn't match IF test

Marty9191 commented 3 weeks ago

I'm using XLOOKUP to return a string from the return array, when it matches the lookup array. The function successfully returns the string. However, the string does not match an IF test in another cell

e.g. =XLOOKUP("TEST",B2:B4,C2:C4,"ERR") TEST ReturnString =ReturnString

However, an IF function will not match "ReturnString"

ovari commented 3 days ago

@Marty9191 can you please test LibreOffice 24.8 or later to see if this has been resolved?

For your information, OASIS OFFICE-4154 add XLOOKUP function has been implemented in Bug 127293 - Add XLOOKUP function in Calc and available in LibreOffice Calc 24.8.

Thank you

Marty9191 commented 17 hours ago

This problem exists in LibreOffice 24.2.4.2. I don't see a 24.8

---- On Sat, 29 Jun 2024 05:35:39 -0500 ovari @.***> wrote ---

https://github.com/Marty9191 can you please test LibreOffice 24.8 or later to see if this has been resolved?

For your information, OASIS https://issues.oasis-open.org/browse/OFFICE-4154 has been implemented in https://bugs.documentfoundation.org/show_bug.cgi?id=127293 and available in https://wiki.documentfoundation.org/ReleaseNotes/24.8#Calc.

Thank you

— Reply to this email directly, https://github.com/goosepirate/lox365/issues/21#issuecomment-2198093735, or https://github.com/notifications/unsubscribe-auth/BJDKKHHF4X6WOYTCADJODWTZJ2EXXAVCNFSM6AAAAABJEVCSG2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCOJYGA4TGNZTGU. You are receiving this because you were mentioned.

ovari commented 7 hours ago

This problem exists in LibreOffice 24.2.4.2. I don't see a 24.8

Operating Systems

LibreOffice 24.8.0 is available for the following operating systems/architectures:

Marty9191 commented 4 hours ago

Thanks, I found it. The problem described persists in 24.8.0.0_beta1

---- On Tue, 02 Jul 2024 16:25:59 -0500 ovari @.***> wrote ---

This problem exists in LibreOffice 24.2.4.2. I don't see a 24.8

Operating Systems

LibreOffice 24.8.0 is available for the following operating systems/architectures:

https://www.libreoffice.org/download/download-libreoffice/?type=deb-x86_64&version=24.8.0&lang=en-US

https://www.libreoffice.org/download/download-libreoffice/?type=rpm-x86_64&version=24.8.0&lang=en-US

https://www.libreoffice.org/download/download-libreoffice/?type=mac-aarch64&version=24.8.0&lang=en-US

https://www.libreoffice.org/download/download-libreoffice/?type=mac-x86_64&version=24.8.0&lang=en-US

https://www.libreoffice.org/download/download-libreoffice/?type=win-x86&version=24.8.0&lang=en-US

https://www.libreoffice.org/download/download-libreoffice/?type=win-x86_64&version=24.8.0&lang=en-US

— Reply to this email directly, https://github.com/goosepirate/lox365/issues/21#issuecomment-2204473919, or https://github.com/notifications/unsubscribe-auth/BJDKKHAWUAXDZKXLN2OWWW3ZKMLGPAVCNFSM6AAAAABJEVCSG2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMBUGQ3TGOJRHE. You are receiving this because you were mentioned.

ovari commented 3 hours ago

Thanks, I found it. The problem described persists in 24.8.0.0_beta1

Can you please attach a sample file with a comment at https://bugs.documentfoundation.org/show_bug.cgi?id=127293?

Thank you

goosepirate / lox365

XLOOKUP Return Value doesn't match IF test #21

Operating Systems