As a gnumeric (upstream) developer I regularly check for bugs reported in ubuntu since it typically takes a while before problems are forwarded upstream (and we like to fix bugs asap).
The problem you reported should have been restricted to case where hlookup and vlookup access the same cell region. So as long as you have different regions everything should work (the regions should even be able to overlap as long as they are not exactly the same.) -- 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
