To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92143 Issue #|92143 Summary|text getRangeExtents reports incorrect 'x' values for |spreadsheet cells Component|Spreadsheet Version|1.0.0 Platform|Sun URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|tbe Reported by|williewalker
------- Additional comments from [EMAIL PROTECTED] Fri Jul 25 14:24:34 +0000 2008 ------- Building upon http://www.openoffice.org/issues/show_bug.cgi?id=70916... I'm still not sure the text extents are reported properly, even in the left justified case. It looks as though the y, width, and height are accurate, but the x position is incorrect for spreadsheet cells. The patch at http://bugzilla.gnome.org/show_bug.cgi?id=363820 contains some print statements in it to help debug the problem. Here's an example when looking at dynamic.ods (attached to 70916): Information for cell C4 ("Column Heading C"), which is cut off at the 'd' on my display. That's the 'd' in 'Heading'. As a result, I can only see "Column Head" being displayed, and only part of the 'd' is showing. Something seems wrong with the text extent calculations. In the following, OBJECT EXTENTS are the extents of the cell. Each line thereafter represents the extents of the string. OBJECT EXTENTS: x=475 y=256 width=78 height=14 C: x=475 y=256 width=10 height=14 Co: x=475 y=256 width=16 height=14 Col: x=475 y=256 width=19 height=14 Colu: x=475 y=256 width=25 height=14 Colum: x=475 y=256 width=35 height=14 Column: x=475 y=256 width=42 height=14 Column : x=475 y=256 width=45 height=14 Column H: x=475 y=256 width=54 height=14 Column He: x=475 y=256 width=60 height=14 Column Hea: x=475 y=256 width=67 height=14 Column Head: x=475 y=256 width=73 height=14 Column Headi: x=475 y=256 width=76 height=14 Column Headin: x=475 y=256 width=82 height=14 Here's what seems wrong: 1) The 'x' position of the 'C' starts flush with the left edge of the cell. This leads me to believe that cell borders might not be taken into account, assuming the OBJECT EXTENTS are correct. 2) It seems as though the above is telling us the 'i' and perhaps part of the 'n' are within the cell boundary, which they are not. This again might be related to the left border not being taken into account. Furthermore, when looking at a cell with right justfication, cell C5 ("100"), the text extents seem to lead us to believe it's left justified: OBJECT EXTENTS: x=475 y=270 width=78 height=14 1: x=475 y=270 width=8 height=14 10: x=475 y=270 width=14 height=14 100: x=475 y=270 width=21 height=14 By using Orca's flat review functionality for characters (KP_1, KP_2, KP_3), which draws a rectangle around the character, it's also obvious that the text extents are not correct. Again, the y, width, and height seem right. It's just the 'x' position that is wrong. Thanks! --------------------------------------------------------------------- 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]
