Issue 47088

Summary: Math Object doesn't anchor to cell
Product: Calc Reporter: redndahead <amoore>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: 680m87   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: PATCH Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
Calc file with math objects
Row Resize Test Spreadsheet.ods
Partial Patch for Row Resizes, Font Changes
Updated sc-object-row-position.diff. none

Description redndahead 2005-04-09 18:05:34 UTC
If you enter a math object into a cell it doesn't anchor to it.  If you resize
the cell it doesn't resize with it.

I believe this worked in M79.  will attach file
Comment 1 redndahead 2005-04-09 18:06:30 UTC
Created attachment 24868 [details]
Calc file with math objects
Comment 2 redndahead 2005-04-12 06:12:42 UTC
confirmed with m91 too

Adam M.
Comment 3 redndahead 2005-04-14 16:28:34 UTC
It doesn't work with m79 either.  so maybe I was fooling myself that it did work
at one point in time.  What I am looking for is the math object should be able
to be treated as a character.  So it moves with text being put before it etc. 
This helps line up the math objects with your sentences.  So, it might be an RFE.

Adam M.
Comment 4 frank 2005-04-15 07:15:45 UTC

reflaged as enhancement and send to requirements team.

IMHO this is not necessary because Calc isn't a wordprocessor. You do not have
any paragraph settings either. So the Math Object or every other Object can and
should only be anchored to the Page or the cell.

Comment 5 redndahead 2005-04-15 15:26:46 UTC
Ok understood, but if the object is inside the cell and it's set to anchor to 
cell and then you resize the cell shouldn't the object stay in the cell?

Adam M.
Comment 6 jpryor 2007-10-05 21:58:26 UTC
redndahead: yes.

Here's the requirements: when an object is flagged as Anchor To Cell, it should
<em>stay within the cell no matter what you do to the cell</em>, i.e. Do The
Expected Thing.

  - insert a new row or column (supported)
  - Manually resize a column width (supported)
  - Manually resize a row height (broken)
  - Change the font size of the Default style (broken)
  - Deleting a row or column should delete the object (broken)
Comment 7 jpryor 2007-10-18 21:48:36 UTC
Created attachment 49015 [details]
Row Resize Test Spreadsheet.ods
Comment 8 jpryor 2007-10-18 21:50:07 UTC
`a.ods' shows a current issue with row resizing in Calc.

Load it, and notice that a rectangle object is located within cell B2.

Resize Row 1.  You'd expect the rectangle to move so that it's inside the new
cell B2 position, but it doesn't move at all.
Comment 9 jpryor 2007-10-18 22:15:08 UTC
Created attachment 49016 [details]
Partial Patch for Row Resizes, Font Changes
Comment 10 jpryor 2007-10-18 22:16:26 UTC
The attached sc-object-row-position.diff patch fixes:

  - Manually resize a row height (broken)
  - Change the font size of the Default style (broken)

The only thing remaining is to delete objects when their containing row or
column is deleted.
Comment 11 frank 2007-10-19 08:40:40 UTC
Hi Niklas,

please have a look at this one.

Comment 12 jpryor 2007-10-30 01:17:02 UTC
Created attachment 49258 [details]
Updated sc-object-row-position.diff.
Comment 13 jpryor 2007-10-30 01:18:45 UTC
The 2007-10-30 sc-object-row-position.diff file implements deletion of drawing
objects within a column/row when the containing column/row is deleted.

This completes the remaining Do The Expected Thing items.
Comment 14 niklas.nebel 2009-05-11 11:50:48 UTC
m47 has a slightly different solution for the row heights, for issue 94991.

The "delete objects" part needs some extension to handle undo correctly. I'll
look at that later.
Comment 15 constencate 2010-11-10 16:21:09 UTC
Created attachment 73158
Comment 16 Rob Weir 2013-03-11 15:01:53 UTC
I'm adding this comment to all open issues with Issue Type == PATCH.  We have 220 such issues, many of them quite old.  I apologize for that.  

We need your help in prioritizing which patches should be integrated into our next release, Apache OpenOffice 4.0.

If you have submitted a patch and think it is applicable for AOO 4.0, please respond with a comment to let us know.

On the other hand, if the patch is no longer relevant, please let us know that as well.

If you have any general questions or want to discuss this further, please send a note to our dev mailing list:


Comment 17 Marcus 2017-05-20 11:13:34 UTC
Reset assigne to the default "".