To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=89555
------- Additional comments from [EMAIL PROTECTED] Mon Aug 4 17:26:38 +0000 2008 ------- I have the same problem with version 2.4.1 on Mandriva 2008.1 This problem existed also with version 2.4.0 (on Mandriva) and version 2.3.1 (on both Mandriva 2007.0 and Ms-xp-sp2) (French version) It may have existed on earlier versions. Identical symptoms in all versions. The problem is a little more general than given here. My description could be useful. I use a fixed-width font, generally size 7 or 8. The problem occurs on the coincidence of several factors : 1) A cell in a spreadsheet contains text content which is at least almost the width of the cell, or longer. 2) The cell in question is set to wrap. 3) The file containing the cell has been saved, and is subsequently loaded. Result: Most cells meeting the above conditions are displayed with one or more extra (blank) lines. Extra lines are more likely when the text wraps to multiple lines (more than 2), and if close to filling the lines it wraps to. (i.e., almost one full line, almost 2 full lines, etc.) For example, a cell which wraps to 1 1/2 lines is unlikely to display with extra lines. But a cell that wraps to 5 1/2 lines, or just short of 2 full lines, is very likely to. Note also that : 1) A freshly entered cell is always properly displayed. 2) Any change to a cell displayed improperly, (or any other cell on the same row), results in the problem cell(s) on that row being properly displayed. This includes reversed changes (such as adding and removing a space), toggling the cell to no-wrap then back to wrap, or setting a cell to default format. (A faster way to correct the display is to set an empty column to default format.) 3) If a cell wraps to multiple lines, there could be 2 or 3 extra (blank) lines. ** so to provide an easy test, use a cell which wraps to many lines ** (I suspect that the problem might be that Openoffice just estimates the width required when displaying the initial matrix, but when a cell is modified, a detailed calculation is made for every cell in the row.) I hope this helps. It is VERY frustrating on a large spreadsheet with a lot of wrapped text. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
