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

How to Limit Text within Column (no overflow to next column)
Goto page 1, 2  Next
 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
abrandt
General User
General User


Joined: 05 Dec 2003
Posts: 47
Location: Fort Worth, TX

PostPosted: Wed Mar 31, 2010 7:34 am    Post subject: How to Limit Text within Column (no overflow to next column) Reply with quote

Hello Members:

Quick question, please.

Question How to LIMIT TEXT to within a column to AVOID overflow to next column... (without having to insert text in the next column to truncate the previous column)?

I hope this question is clear enough to be decipherable!

Thanks much in advance for a prompt and clear response,

Alan
Back to top
View user's profile Send private message
thomasjk
Super User
Super User


Joined: 16 Dec 2005
Posts: 2374

PostPosted: Wed Mar 31, 2010 8:45 am    Post subject: Reply with quote

Format--->Cells--->Alignment Check "Wrap Text"
Back to top
View user's profile Send private message
abrandt
General User
General User


Joined: 05 Dec 2003
Posts: 47
Location: Fort Worth, TX

PostPosted: Wed Mar 31, 2010 11:15 am    Post subject: How to Limit Text within Column (no overflow to next column) Reply with quote

Hello thomasjk:

If I'm not mistaken, WRAPPING will increase the HEIGHT of a row... don't want that.

My goal is: TEXT visible only within column width only... then red ARROW displays - indicating more text to view in the cell.

POSSIBLE???

Thanks much in advance for a prompt clarification and response,

Alan
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed Mar 31, 2010 11:18 am    Post subject: Reply with quote

Put some invisible content into the neigbour column (space or ="").
Hide that column.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
thomasjk
Super User
Super User


Joined: 16 Dec 2005
Posts: 2374

PostPosted: Wed Mar 31, 2010 12:47 pm    Post subject: Reply with quote

Then check "Shrink to fit cell size" or make the columns wider.
Back to top
View user's profile Send private message
abrandt
General User
General User


Joined: 05 Dec 2003
Posts: 47
Location: Fort Worth, TX

PostPosted: Wed Mar 31, 2010 2:14 pm    Post subject: Reply with quote

Hello thomasjk:

Appreciate your follow-up.

Upon Googling what "Shrink to fit cell size" means... it appears that this function will REDUCE FONT SIZE to fit within a set column length... however I could not find SHRINK anywhere under the FORMAT TAB within OO 3.1.1 build OOO310m (build:9429).

Still that's not what I'm hoping to achieve. I would like retain CALIBRI - 8 font... and only show that portion of the TEXT that fits within column width, with the remainder hidden (column arrow on right).

Is this doable?

Thanks much again.

Alan
Back to top
View user's profile Send private message
thomasjk
Super User
Super User


Joined: 16 Dec 2005
Posts: 2374

PostPosted: Wed Mar 31, 2010 3:46 pm    Post subject: Reply with quote

Best to try Villeroy's suggestion.
Back to top
View user's profile Send private message
abrandt
General User
General User


Joined: 05 Dec 2003
Posts: 47
Location: Fort Worth, TX

PostPosted: Wed Mar 31, 2010 4:35 pm    Post subject: RE: How to Limit Text within Column Reply with quote

Quote:
Best to try Villeroy's suggestion.


Thank you, but not at all practical when building a spreadsheet... and besides, this is something that Excel is easily able to accommodate.

Any other ideas,

Alan
Back to top
View user's profile Send private message
thomasjk
Super User
Super User


Joined: 16 Dec 2005
Posts: 2374

PostPosted: Wed Mar 31, 2010 7:11 pm    Post subject: Reply with quote

Use Excel.
Back to top
View user's profile Send private message
pkon
OOo Enthusiast
OOo Enthusiast


Joined: 26 Feb 2010
Posts: 116

PostPosted: Wed Mar 31, 2010 9:03 pm    Post subject: Reply with quote

Please have a look at Format cells - Alignment - Shrink to fit cell size.

Also try to find it in the manual.

Works on 3.2 and 3.3 developer version.
Back to top
View user's profile Send private message
abrandt
General User
General User


Joined: 05 Dec 2003
Posts: 47
Location: Fort Worth, TX

PostPosted: Thu Apr 01, 2010 5:27 am    Post subject: Reply with quote

Hello pkon:

Appreciate your follow-up post.

In OO 3.1.1 build OOO310m (build:9429), "Shrink to fit cell size" is located at:
    - FORMAT tab >
    - drop down menu (CELLS or CTRL + 1)
    - SHRINK TO FIT CELL SIZE (bottom left - radial box)


Yes, it will successfully SHRINK text to fit within any column width, but renders all the text UNREADABLE (too small).

In contrast, I want to retain READABLE text at CALIBRI - 8 font - within the COLUMN WIDTH... and then have text at right border of column become TRUNCATED (not visible) until one clicks on that CELL where the text becomes visible in the TOP TEXT area (cell formula / text bar).


From responses so far, it would appear this capability is not yet a current OO FEATURE.

A truncated cell text SOLUTION would be very much appreciated, if anyone has figured this out.

Thanks much again!

Alan
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Thu Apr 01, 2010 5:46 am    Post subject: Reply with quote

Please, stop nagging. This is a spreadsheet calculation program in the first place. It is not a "table editor", layout program or anything like that.
We are users like you, making suggestions how to handle some problem or shortcoming of this software.
I still don't get how you want to display a long text in a short cell without wrapping nor shrinking
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
thomasjk
Super User
Super User


Joined: 16 Dec 2005
Posts: 2374

PostPosted: Thu Apr 01, 2010 5:53 am    Post subject: Reply with quote

abrandt wrote:
Hello pkon:

Appreciate your follow-up post.

In OO 3.1.1 build OOO310m (build:9429), "Shrink to fit cell size" is located at:
    - FORMAT tab >
    - drop down menu (CELLS or CTRL + 1)
    - SHRINK TO FIT CELL SIZE (bottom left - radial box)


Yes, it will successfully SHRINK text to fit within any column width, but renders all the text UNREADABLE (too small).

In contrast, I want to retain READABLE text at CALIBRI - 8 font - within the COLUMN WIDTH... and then have text at right border of column become TRUNCATED (not visible) until one clicks on that CELL where the text becomes visible in the TOP TEXT area (cell formula / text bar).


From responses so far, it would appear this capability is not yet a current OO FEATURE.

A truncated cell text SOLUTION would be very much appreciated, if anyone has figured this out.

Thanks much again!

Alan


As I said last night use Excel if it has this feature.
Back to top
View user's profile Send private message
Phosphaenus
Newbie
Newbie


Joined: 04 Apr 2010
Posts: 2

PostPosted: Sun Apr 04, 2010 4:19 am    Post subject: Reply with quote

I think you can achieve what you're asking for as follows:

1) Tools - Options - Text overflow [tick]

2) [Select all spreadsheet]

3) Format - Cells - Alignment - Wrap text automatically [tick]

4) Format - Row - Height [find a height which shows only one line]

[The row height that works for me, with Calibri 12 font, is 0.65 cm; note also that text alignment in all my cells is Left Top.]

This gives you the red arrow indicating truncation. You can view the cell's full content by double-clicking it.

Works for me, anyway.


Last edited by Phosphaenus on Sun Apr 04, 2010 12:38 pm; edited 1 time in total
Back to top
View user's profile Send private message
stevesaunders
OOo Advocate
OOo Advocate


Joined: 26 Dec 2009
Posts: 408

PostPosted: Sun Apr 04, 2010 5:51 am    Post subject: Limit text in cell Reply with quote

=LEFT(A1;20)
_________________
Steve ~ Tennessee USA
Mac OS X 10.6.2 Open Office 3.1
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
Goto page 1, 2  Next
Page 1 of 2

 
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