OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Creating a Blank Cell

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Sonny
Newbie
Newbie


Joined: 08 Nov 2004
Posts: 1

PostPosted: Mon Nov 08, 2004 5:11 pm    Post subject: Creating a Blank Cell Reply with quote

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
View user's profile Send private message
alphaQ
General User
General User


Joined: 08 Sep 2004
Posts: 30
Location: New York, Cubao

PostPosted: Mon Nov 08, 2004 5:30 pm    Post subject: Reply with quote

_______
Back to top
View user's profile Send private message
r_vinoya
Super User
Super User


Joined: 03 Dec 2003
Posts: 619
Location: Somewhere in the Philippines

PostPosted: Mon Nov 08, 2004 5:33 pm    Post subject: Re: Creating a Blank Cell Reply with quote

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
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Mon Nov 08, 2004 9:33 pm    Post subject: Re: Creating a Blank Cell Reply with quote

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. Sad

David.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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