On Tue, Nov 17, 2009 at 9:29 AM, Andreas Saeger <[email protected]> wrote: > Just like in Excel, when automatic calculation is off, F9 calculates all > dirty cells which would have been calculated if automatic calculation had > been on. A dirty cell has a formula which depends on a modified input > argument.
Yes. I don't have any doubt about that and I've never said otherwise. But, please, check the OOo Calc Help: 1. Press F1; 2. On tab "Find" search for the term "F9"; 3. Select one result among "Recalculate", "Cell contents" or "Shortcut for Spreadsheets". On the right you'll see: "press F9 to recalculate all CHANGED formulas in the CURRENT sheet." (Sorry for the capitals, I just want to emphasize and not to shout.) That's is wrong! Do you see what I mean? However, our major problem is the following. For us (people developing Excel add-ins in the financial markets) it's very important to be able to: Recalculate ALL formulas in the CURRENT sheet (our major problem) That's not possible in OOo Calc (is it?). To be fair, that's not possible in Excel either. However, in Excel 1. Shift+F9 calculates all CHANGED formulas in the CURRENT sheet. 2. We can make all our add-in functions "volatile". Toghether these two features allow for a partial, though sufficient, solution for our major problem. More precisely, Shift+F9 recalculates all OUR add-in functions in the CURRENT sheet. In OOo Calc behavior #1 above is not implemented (neither F9 nor Shift+Ctrl+F9 do so, as Andreas said) and volatile add-in functions don't exist in OOo Calc (as Niklas said quoting er in issue #69903... Ah, a brand new patch came out yesterday). One intention (among others) of my previous messages was to propose a solution for our major problem. By doing so, OOo Calc will make one step to become a viable option for very important applications we have in financial markets. I'm very sorry to say that currently only Excel is viable. Regards, Cassio. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
