| Summary: | vlookup does not work | ||
|---|---|---|---|
| Product: | [Applications] calligrasheets | Reporter: | Silver Salonen <silver.salonen> |
| Component: | filter/xlsx | Assignee: | Calligra Sheets (KSpread) Bugs <calligra-sheets-bugs-null> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | alvarofernandogarcia, sebsauer |
| Priority: | NOR | ||
| Version: | 2.4-snapshots | ||
| Target Milestone: | --- | ||
| Platform: | openSUSE | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
| Attachments: | xlsx worksheet with VLOOKUP formulas | ||
Confirmed. Reproducible on: Version: Calligra Tables 2.4 beta 3, KDE SC 4.7.3 using Qt 4.7.4 OS: Arch Linux (kernel 3.1.0-4) The first time the file was opened, Tables crashed. The second time, the cells give "#PARSE!" errors. The issue happens in a fresh install. The mentioned crash was caused by other issue... There are 2 bugs here; 1. the filter produces the wrong values. For cell B2 OpenOffice displays =VLOOKUP(A2,C$1:D$1048576,2,0) while we display =VLOOKUP(A2;C:D;2;0) 2. vlookup doesn't work in Tables. When I change B2 to =VLOOKUP(A2,C1:D10,2,0) then it displays "3" while Tables displays a "#PARSE" error. Fixed with 109ec43af6c5. I expected to see the fix in beta4, but I don't. In which release will it be available? Not sure there. But if it doesn't work on beta4 then the commit was done to late and it will be in beta5. |
Created attachment 64747 [details] xlsx worksheet with VLOOKUP formulas Version: 2.4-snapshots (using KDE 4.7.2) OS: Linux I created a simple .xslx worksheet with some vlookup formulas. LibreOffice parses them just fine, but Calligra Tables gives "#PARSE!" error. Reproducible: Always Steps to Reproduce: Create VLOOKUP formula in Excel, open the file with Calligra and see what happens. Actual Results: Formula does not work. Expected Results: Formula should work.