Andreas Guelzow wrote: > When you open the file you see the results stored in the file. Gnumeric > will not recalculate automatically since you want to see what was > stored.
Understood. > When you press F9 you are recalculating and you see the answer > your current version of Gnumeric produces. Not really. The results stored in the file were produced by the _same_ version of Gnumeric after editing those formulae. The purpose of this file is to show that F9 changes the results from what the same version of Gnumeric already calculated - which it should never do, when there are no circular dependencies. > Are you seeing any changes on further F9s? Yes I have, as the report explains: I have seen a series of changes on up to three F9 presses in a row, but I have not been able to produce a file showing it. > After the recalculation in a current version of Gnumeric I see 2005-2006 > in C6, 2007-2008 in D6 and #N/A in C7:D8. This all seems correct to me. You are right. I accedentally omitted to set as_index to TRUE in the inner vlookup calls in this file, as I was editing it so much and nothing I did produced working formulae. No, I wasn't trying to be Excel compatible, I was trying to demonstrate a problem and made a mistake in those formulae because the correct formulae produced the same error. Append TRUE to the arguments of the inner vlookup formulae, and you'll see it still shows #N/A. That's the basic problem. > On first glance, the #N/A in F6 to F8 seems to be incorrect. Yes. I have managed to workaround the problem by writing hlookup+vlookup using the match function instead. I suspect match is not cached like hlookup and vlookup (it probably should be, once the cache is fixed). -- 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
