On Jun 15, 2008, at 8:42 AM, Michele wrote:
2008/6/15 Dave Barton <[EMAIL PROTECTED]>:
I have been asked a Calc question to which my immediate thought was
to
reply: "No, that is not the way spreadsheets work". On reflection,
I began
to wonder if the following was possible.
Cell A1=1 cell B1=2 cell C1=A1+B1 The result "3" is displayed in C1
The question: "Other than over-typing the function in C1 with a
number
value, is it possible to convert the result into a permanent value,
which
would allow the contents of A1 and/or B1 to be deleted?"
I don't know why the user wants to do this and I don't much care.
It's more
a case of satisfying my own curiosity.
Any thoughts?
I think you were right at the very beginning: this is not how
spreadsheets work.
Well, yes and no. The function has existed in most historic
spreadsheets, going all the way back to VisiCalc. But I notice that I
cannot find it in Numbers '08 (from Apple's iWork suite) at all, and
OOo's way of doing it is a little on the arcane side.
--
John W Kennedy
"The blind rulers of Logres
Nourished the land on a fallacy of rational virtue."
-- Charles Williams. "Taliessin through Logres: Prelude"
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
