To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75868 Issue #|75868 Summary|Math objects anchored to cells in Calc move when rows |above are added/removed/resized Component|Spreadsheet Version|OOo 2.1 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|llewelyn_mt
------- Additional comments from [EMAIL PROTECTED] Thu Mar 29 14:03:50 +0000 2007 ------- I'm amazed nobody reported this before. I consider it a major issue. Maybe I didn't look hard enough. Excuse me if it was addressed before. SYNOPSIS: While writing my thesis I noticed that the Math objects (representing the in-cell formulae, used for calculations) inserted into Calc move, even though they are anchored to cells in appropriate rows. It happens when a row (or rows) above is (are) added/removed/resized (using any of the available methods). The row the object is anchored to stays the same, but the objects' position relative to the cells change. The objects' relative position to one another is kept. OUTCOME: This wreaks havoc to the document's formatting, as deletion of 2 rows can shift all the inserted objects below one or two rows higher. The work if effectively lost, as I cannot save the document with messed up formatting. (Ctrl-Z is the only alternative.) If I do happen to save the document so 'fixed' I have to (a) remove anchor, (b) move misplaced object and (c) anchor it back in the right place. Everything for each and every object so affected. It's no fun at all for a spreadsheet with 50+ objects. I've done this way to many times already. PROBABLE CAUSE: My best guess as to what creates the problem is that objects' location is stored based on the position on the page, rather than relative to appriopriate cell's top-left corner, even though it's meant to be locked to a specific cell. The way it is, when rows above change, the cells below change their location, but the objects anchored to them don't (or do it wrong). The fact that the objects don't move relative to each other seems to support that. ADDITIONAL COMMENTS: * It's probably also true for other objects, but I never use them. * It's *hard* to reproduce, as it doesn't happen from the start. Once it happens though, it's persistent and only application restart helps. I can't put my finger on what causes it to occur. * The affected versions are 2.0.x (release) and 2.1 (I haven't tried later versions). I encountered problems on Linux (i386 (K|)Ubuntu 6.06 & 6.10, with OOo packages), Windows 2000 SP4 and Windows XP SP1. --------------------------------------------------------------------- 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]
