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 remove the extra space when wrapping text?

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


Joined: 21 Mar 2011
Posts: 5

PostPosted: Mon Mar 21, 2011 10:03 am    Post subject: How to remove the extra space when wrapping text? Reply with quote

Hello,

I use some bigger pieces of text in 1 cell with the option of wrapping the text.
This works so far without a problem, given the editing perspective.

My problem is, when I look at the print preview or print the file or export it to pfd,
in cells where text is wrapped, some extra space shows up (depending on font
type and size this is more or less). This is before the text if the vertical allignment
is set at the bottom, or after the text if the allignment is set to top.

This results in ~1cm wasted space in each cell due to my current settings of font
type and size. Default formatting to arial and size 10 or something like that has the
same problem only this is less visible...

Anybody noticed this and has a practical solution? Thanks in advance,

Zoppa
Back to top
View user's profile Send private message
ken johnson
Super User
Super User


Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

PostPosted: Mon Mar 21, 2011 4:15 pm    Post subject: Reply with quote

I have submitted a bug report...
Bug 117496 - unwanted white space in page preview and in print out
http://openoffice.org/bugzilla/show_bug.cgi?id=117496
Seems like you have to deliberately make the cells too small for the text to get rid of the unwanted white space.
Until the bug is fixed, if you open an extra window then shrink both windows so that they can be viewed side-by side, with one window in Page Preview and the other not, you can adjust the row heights while watching the white space disappear in the Page Preview window.

Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Back to top
View user's profile Send private message
ftack
Moderator
Moderator


Joined: 27 Jan 2003
Posts: 3102
Location: Belgium

PostPosted: Mon Mar 21, 2011 11:59 pm    Post subject: Reply with quote

I cannot reproduce this issue on LibreOffice 3.3. In page preview nor in a PDF export, there is extraneous white space before or after the text.

Is this being observed in the latest Ooo 3.3? If not, see if the problem persists, if yes, then it would be an issue that specifically was addressed in LibreOffice, which is a fork of OOo.
_________________
--
GNU/Linux (Ubuntu)
Back to top
View user's profile Send private message
ken johnson
Super User
Super User


Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

PostPosted: Tue Mar 22, 2011 12:50 am    Post subject: Reply with quote

ftack wrote:
Is this being observed in the latest Ooo 3.3? If not, see if the problem persists, if yes, then it would be an issue that specifically was addressed in LibreOffice, which is a fork of OOo.

I have observed it in OpenOffice.org 3.3.0 OOO330m17 (Build:9551)
Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Back to top
View user's profile Send private message
Zoppa
General User
General User


Joined: 21 Mar 2011
Posts: 5

PostPosted: Tue Mar 22, 2011 3:41 am    Post subject: Reply with quote

My version is OpenOffice.org 3.3.0 OOO330m20 (Build:9567)

Indeed, I noticed that this workaround is possible, for the time beeing I
will live with the extra space, because I have too large documents
to start adjusting every cell for itself.

Thank you for making the bug report. Can you change or edit that?
Maybe you can add that this white space is depending on font type
and size?
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