John M Collins wrote:
Is there a way, in Calc, where a cell has a formula, of replacing its
contents with whatever is currently being displayed so it's just a
number?
John Collins Xi Software Ltd www.xisl.com
========================
John,
I don't have an answer but I do have a question.
Why on earth would you want to do that? It will destroy the very thing
that makes the display change with changing conditions.
It would probably be better to layout another section of the
sheet and simply echo the display(s) there. Something like having DD12
be =B19. Then you could export the 'echo' section to cvs and re-import
to a new sheet and have just numbers, etc. No functions in final sheet
to give away your secrets. Changes to original will auto update the
section to export/re-import to a new sheet and bingo - should accomplish
what you want.
Steve
[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
