VLOOKUP does not fetch the correct cell (problem with uppercase?) - Githubissues

ONLYOFFICE / DocumentServer

ONLYOFFICE Docs is a free collaborative online office suite comprising viewers and editors for texts, spreadsheets and presentations, forms and PDF, fully compatible with Office Open XML formats: .docx, .xlsx, .pptx and enabling collaborative editing in real time.

https://www.onlyoffice.com

GNU Affero General Public License v3.0

4.82k stars 1.08k forks source link

VLOOKUP does not fetch the correct cell (problem with uppercase?) #1558

Closed pdehaye closed 4 months ago

pdehaye commented 2 years ago

This issue is unique.

[X] I have used the search tool and did not find an issue describing my bug.

Operating System

Windows 10 / 8.1 / 7

Version information

6.4.2.6

Expected Behavior

In the use case screenshotted below, I would expect the first two columns to be identical, since I am using a simple VLOOKUP formula.

Actual Behavior

Rows 9, 16 and 17 contain two different entries in the example.

test_vlookup.ods

Reproduction Steps

See attached file.

Additional information

The issue is also present on the Document Server, see https://github.com/ONLYOFFICE/DocumentServer/issues/1544

ShockwaveNN commented 2 years ago

Thank you for your report

We've created issue 54560 in our private issue tracker to figure out this problem

Moving this issue to DocumentServer repo, since it's our base product and problem actual there too

rsnegirev commented 5 months ago

Hi @pdehaye

The problem was fixed in this one commit: https://github.com/ONLYOFFICE/sdkjs/commit/a8b628dfee92a2fbf613c019db1c740bfaf031b4

Fixes will be released in the next major version.

Rita-Bubnova commented 4 months ago

DocumentServer v8.1.0 is released so I close this issue. Feel free to comment or reopen it if you got further questions.