We're discussing this on a bug filed against the Ubuntu Gnumeric package, on the Ubuntu bug tracker, not the Gnumeric upstream bug tracker, so my apologies if people accidentally found themselves here without knowing much about Ubuntu ;-)
Karmic is the name of the current Ubuntu development release; it's where I'd expect the upstream package to appear eventually. Unfortunately that may be bit slow if there's no Ubuntu packager tracking this bug report. I thought that was you because of your fast response; sorry for my mistake. There's a separate bug tracker for Gnome and Gnumeric upstream, and I understand you relayed this bug to there (thank you). I understand that hlookup() and vlookup() were incorrectly sharing the same cache. Just to check, can you confirm that lookups in different sheets in the same workbook use separate caches too? Since you're there, please pass on that the match() function should be cached in the same way as hlookup() and vlookup(). In fact you can write hlookup() and vlookup() in terms of match(), which is what I did to workaround this bug. (I also found it's the only way to make a sheet that also works in OpenOffice.org, which doesn't support the as_index option. That's what match() is for (in conjunction with offset()); as_index was never really needed). Thanks for your help getting the bug fixed. I look forward to testing it when it percolates downstream. -- hlookup and vlookup return invalid results, and F9 (force recalculate) can break or fix the result, so can "editing" formula with no changes https://bugs.launchpad.net/bugs/418366 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
