Issue 85342 - problem with text wrap in Calc cell
Summary: problem with text wrap in Calc cell
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.3.1
Hardware: All Windows XP
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@sc
Keywords: oooqa
Depends on: 96397 88864 94387 107600
  Show dependency tree
Reported: 2008-01-17 23:57 UTC by oodotouser1
Modified: 2017-05-20 10:33 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Example file where text wrap was different on my Windows setup (7.75 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-04-23 17:54 UTC, niklas.nebel
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description oodotouser1 2008-01-17 23:57:06 UTC
When text wrap and "Use printer metrics for text formatting" are turned on in
Calc in OpenOffice 2.3.1, cells containing text with a certain line length
relative to column width will show that the text exceeds the cell boundary. All
of the text will not be wrapped and the small red triangle will be shown at the
right cell boundary. Page preview will show correctly, however, that all the
text will be printed. This problem does not occur with OpenOffice 1.1.4. In this
earlier version, the same cell content will be shown in the editing view and in
the page preview. In the newer version, the text wraps at the same points as in
the old version for the page preview and when it is printed, but it wraps
differently and incorrectly in the editing view. This is only for some and not
all cells. It seems to have a problem if a word on a line comes close to the
right boundary. In the editing view in this case it breaks the line before a
word that would end near but not over the right cell boundary, but in the page
preview and on the printed page the break comes (correctly) after this word. For
anyone to replicate this problem, simply enter one line of text in a cell, then
modify the column width by dragging until it makes the rightmost word on the
line disappear. The way that I encounter this problem, which cannot be given as
a specific example since it depends on my printer metrics, is to have, as I do,
spreadsheets with many cells containing text. A certain number of these will
just happen to have a line of text of the length that causes this problem to occur.
Comment 1 amy2008 2008-09-17 09:22:52 UTC
Duplicate to issue26125

*** This issue has been marked as a duplicate of 26125 ***
Comment 2 amy2008 2008-09-17 09:29:10 UTC
Sorry, it's wrong. 
It's not a duplicate of issue26125.
I'll reopen it again
Comment 3 amy2008 2008-09-18 03:10:46 UTC
Confirmed in OOo3.0_RC1 on WinXP
Follow your description, I check "wrap text automatically" and "Use printer 
metrics for text formatting". Found it is different between the page preview 
and the format displaying on the screen. 
Li Meiying
Comment 4 corigo 2008-10-20 09:07:34 UTC
I'm not sure about the "Use Printer metrics" as I couldn't find this setting 
anywhere in the cell formatting dialogue.

I did find that many cells in my document would not auto-resize to fit all text 
wrapped text. Then I right clicked on the cell in question and selected default 
formatting only to find that all the content fit in the cell without a wrap. It 
seems that the content is wrapping before it needs to and the cell is correctly 
sizing itself. The result of which is that in edit mode, while the cell size is 
correct the content is wrapping incorrectly and can't all be viewed and has a 
red arrow in the cell. 
Comment 5 corigo 2008-10-20 09:44:40 UTC
In a second case when text formatting (e.g. bold) actuall does require the text 
to wrap then the cell does not correctly recognize this and continues to size 
itself based on the default text format. 
Comment 6 Mechtilde 2010-01-23 09:38:08 UTC
It seems there are several issues with different description about the same
technical reason
Comment 7 Mechtilde 2010-01-23 20:24:19 UTC
similar to 88864,94387,96397,107600
Comment 8 niklas.nebel 2010-04-23 17:39:40 UTC
This issue is different from the others, because it's about the case when "Use
printer metrics" is on.
Comment 9 niklas.nebel 2010-04-23 17:53:00 UTC
I found some cases where even with "Use printer metrics", text wrap is different
between normal view and preview/printing. This is fixed in CWS "calc53".

You can check if your example is affected: Press F2 to enter edit mode for the
cell. If in edit mode, the text wrap is the same as in print preview, then it's
probably the case that is fixed now.
Comment 10 niklas.nebel 2010-04-23 17:54:19 UTC
Created attachment 69077 [details]
Example file where text wrap was different on my Windows setup
Comment 11 niklas.nebel 2010-04-29 17:43:11 UTC
reassigning to QA for verification
Comment 12 kla 2010-05-10 16:01:04 UTC
Seen ok in CWS calc53 -> verified
Comment 13 jvossoug 2010-09-13 17:45:06 UTC
I do not find any problem with normal text wrap, but if the text is made into
hypertext link then it will not wrap. Also I do not see a reason why such links
are force-displayed as dark gray "text background".
Comment 14 Mechtilde 2010-09-13 17:53:02 UTC
@  jvossoug

please fill a separate issue for that behavour

nobody will work on this issue further