On 08/15/2009 01:23 AM, Tamblyne wrote:
I'm trying to copy certain cells from one sheet to another. If the
first cell is empty, I want the second cell to be empty, too, ...
Testing for empty cells can be a real mess, because there are various
degrees of "emptiness" and the means of testing for it are not always
consistent.
Because of that, I try to avoid depending on whether a cell is empty or
not, but if I really have to, I use the testing functions, not a
comparison operator:
=IF(ISBLANK(A1); "No value in A1"; A1+B1)
or
=IF(ISNUMBER(A1); A1+B1; "Need a number in A1")
Things get even weirder when you start working with cells containing a
copy or reference to a cell that may be empty.
For example, Calc's behavior in this area was changed recently, and this
summary was released:
http://www.openoffice.org/servlets/ReadMsg?list=allfeatures&msgNo=3310
... makes my eyes glaze over.
Also, if there are hyperlinks in the cell in the first sheet, only the
link text appears in the cell in the second sheet -- not the hyperlink
that's supposed to go with it. Is there anything that can be done
about that?
Referencing a cell only copies its pure text or pure numeric value,
never the formatting. Something like a hyperlink is more than a simple
text or numeric value, so it can't be copied or referenced from another
cell.
If you have the hyperlink address in a cell--either as plain text, or as
a live, clickable link--then the text value can be copied and you can
use the HYPERLINK function to make a clickable link from the address text.
E.g.
A1: "http://www.openoffice.org"; -- plain text, or as a link
B1: =A1 -- copy the text
C1: =HYPERLINK(B1;"LINK") -- shows "LINK"; click goes to OO.org
The HYPERLINK text doesn't get any special formatting; you can format it
to look any way you want.
<Joe
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
