Arnold Huzen wrote:
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]
===========================================
UHmmmmmm??
The question was:
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?
You state (as an example) Columns A & B are to be deleted after creating
Column C and Paste Special keeps the composite. OK But, Now the spread
sheet is butchered. And all original data is destroyed.
IF the 'other area' is formatted correctly, composites where wanted
(like name or address grouping) and rest of "to be displayed static"
is likewise grouped as wanted in the other part of the sheet and then
that "for display static" is exported as csv and re-imported to a new
sheet, nothing is lost, recovery/edit is possible and display is static
and 'pretty'.
Static - only the formulated data exists - not the formula it replaced.
"... where a cell has a formula, of replacing its contents ..." with
just the displayed -whatever-. ie. to replace Col-A's formula with what
it calculated. (f(x))/3 with 9 or whatever.
The new sheet Col-A will be the leftmost of the other area selected to
go to csv. And since it is 'over there' in original, individual cell
tweaks are allowed to give a final polish. Replacing left side of
original with varying dimension new data (different number of cells wide
and/or lines long) for next run is simple matter of just doing so. Then
looking at right side (export side in this case) one can easily tweak
any cells needing it. (Splitting long names to above/below in cell).
Bottom line, each method yields a similar result, one is destructive and
one is not. Which to use is user choice. Meaning that there is nothing
wrong with your method, but I consider mine safer. :)
I do admit that I am far more long winded that you. :)
I hope this message finds you on a pleasant day which you get to enjoy.
Steve
[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
