On Sat, 15 Aug 2009 19:09:02 -0400, Joe Smith <[email protected]> wrote:
> 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 Thanks for the help, Joe! --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
