| View previous topic :: View next topic |
| Author |
Message |
Sonny
Newbie
Joined: 08 Nov 2004
Posts: 1
|
 Posted: Mon Nov 08, 2004 5:11 pm Post subject: Creating a Blank Cell |
 |
|
Fire up a blank workbook.
In any cell, type the following "Here is a long line of text for testing purposes."
Click the cell to the right of it and type in the following:
=""
The above formula should create a blank cell, and in most cases it does. But as you can see it has cut off the text from the left hand cell.
Is there a way to create a *real* blank cell ?
This is a failing in MS Office, so far I assume it is a failing in OOo aswell.
The purpose is obviously for a formula to output a blank cell.
Cordially,
Sonny. |
|
| Back to top |
|
 |
alphaQ
General User
Joined: 08 Sep 2004
Posts: 30
Location: New York, Cubao
|
| Posted: Mon Nov 08, 2004 5:30 pm Post subject: |
|
|
| _______ |
|
| Back to top |
|
|
r_vinoya
Super User
Joined: 03 Dec 2003
Posts: 619
Location: Somewhere in the Philippines
|
| Posted: Mon Nov 08, 2004 5:33 pm Post subject: Re: Creating a Blank Cell |
|
|
| Sonny wrote: | Fire up a blank workbook.
In any cell, type the following "Here is a long line of text for testing purposes."
Click the cell to the right of it and type in the following:
=""
The above formula should create a blank cell, and in most cases it does. But as you can see it has cut off the text from the left hand cell.
Is there a way to create a *real* blank cell ?
This is a failing in MS Office, so far I assume it is a failing in OOo aswell.
The purpose is obviously for a formula to output a blank cell.
Cordially,
Sonny. |
Why would you create a blank cell anyway? By default spreadsheet cells are blank.
_________________
# : - ) |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Mon Nov 08, 2004 9:33 pm Post subject: Re: Creating a Blank Cell |
|
|
| Sonny wrote: | Fire up a blank workbook.
In any cell, type the following "Here is a long line of text for testing purposes."
Click the cell to the right of it and type in the following:
=""
The above formula should create a blank cell, and in most cases it does. But as you can see it has cut off the text from the left hand cell.
Is there a way to create a *real* blank cell ?
This is a failing in MS Office, so far I assume it is a failing in OOo aswell.
The purpose is obviously for a formula to output a blank cell.
Cordially,
Sonny. |
It is not a failing in either, but more an attempt to please as much as possible. A "blank" cell, is not an empty cell, as was discussed in a recent posting asking about a count of blank cells. For example, the formula in B1, =IF(A1="";"";1) will result in a "blank" cell, but it is not empty, since it contains the formula. So the entry does curtail the first entry which is long ...and you should therefore expand the cell width to fit. Past that, it's just semantics I think. ...but I've been wrong before. 
David. |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
