Steve,
A reason why you might want to do this procedure would be that you have
data in column A (first names or street address) and in column B (last
name or housenumber) that you want to join together in column C. After
joining the data you only need column C and want to delete columns A and
B. Without the suggested procedure using Paste Special you will lose the
constructed data in column C.
I've used this myself several times with exported data from other
applications.
Arnold Huzen
norseman schreef:
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
