Cassio Neri wrote:
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.
ok, lets assume that OOo Calc would become viable, the issues would be
fixed and the missing features would be implemented. What do you think
would people really think about a shift from Excel to Calc or is it more
hypothetical. I mean is there really interest to move to an open source
solution with all the pro and cons to save money, to become standard
based, to become open etc.?
It would be really helpful to get some more insight and it helps also to
prioritize our efforts correct.
Juergen
Regards,
Cassio.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
