Apache OpenOffice (AOO) Bugzilla – Issue 75868
Math objects anchored to cells in Calc move when rows above are added/removed/resized
Last modified: 2007-06-27 14:30:43 UTC
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.
Confirm: 1. OOo 2.2 on Win2K; 2. OOo 2.0.4 on OpenSUSE 10.2.
Confirming as per helen_russian. Helen, please provide sample doc and detailed steps so that developers could quickly see the problem. Issue http://qa.openoffice.org/issues/show_bug.cgi?id=76776 seems to be related.
How to reproduce (variant 1): 1. Open blank spreadsheet 2. go to cell "A3" 3. Insert - Object - Formula 4. create simple formula (y=x+1) 5. go back to spreadsheet (click in sheet's area) 6. reduce height of the second row Formula object doesn't move up, but row 3 does. variant 2: 1. Open new spreadsheet 2. go to cell "C3" 3. Insert - Object - Formula 4. create simple formula (2*5/3) 5. go back to spreadsheet (click in sheet's area) 6. enter any value in cell "A3" 7. move formula object to cell "B3" 8. go to cell "A3" 9. insert row above is (Insert - Rows) Formula object doesn't move down, but row 3 does.
Created attachment 46132 [details] Sample doc
There might be some relation to issue 75868, as mentioned by kpalagin. The Math objects also rarely change size, but I have noticed it only while saving the file and then restoring it upon application restart. I changed the version to 2.2 as it is the latest I've used under Linux (Kubuntu 7.04, Oo.org package, PL locale), and it was already confirmed for Windows. I still have to test 2.2.1 though. I wouldn't be surprised if it was still there. I also changed the issue's subcomponent to "formatting", as I guess it fits better.
I meant issue 76776 above. My mistake.
this is a double to Issue 8303 and Issue 10019 *** This issue has been marked as a duplicate of 10019 ***
closed double