At 11:54 09/10/2012 -0400, Jay Lozier wrote:
If A1 has a string (Sunday) the try =if(len(a1)>0,"",""). This will
put any empty string in the cell whether the expression evaluates to
true or false.
Indeed it will! In other words, your formula is identical to just
="" and does not depend on th
On 2012-10-10 00:54, Jay Lozier wrote:
On 10/09/2012 04:44 AM, IGraham wrote:
Hello
A Calc question
I have a grid of cells 7x20, one row for each day of the week, cells may
contain no data today
Daily I update the relevant cells
I want to copy and paste this grid to another sheet in the same bo
On 10/09/2012 04:44 AM, IGraham wrote:
> Hello
> A Calc question
> I have a grid of cells 7x20, one row for each day of the week, cells may
> contain no data today
> Daily I update the relevant cells
> I want to copy and paste this grid to another sheet in the same book
> I select grid and copy, go
Hello
A Calc question
I have a grid of cells 7x20, one row for each day of the week, cells may
contain no data today
Daily I update the relevant cells
I want to copy and paste this grid to another sheet in the same book
I select grid and copy, go to other sheet right click a cell, select paste
spec
