You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openoffice.apache.org by Lei Wang <le...@apache.org> on 2012/07/05 11:52:47 UTC
[Calc] Dose Calc support Excel similar function "Move but don't size
with cell" for drawing object/picture
Hi,
In Excel, user can set object positioning properties for a drawing
object/graphic. There are three options. AOO does not have similar
properties. But it use anchor attribute to reflect these properties.
Excel AOO
Move and size with cells Anchor to cell
Move but don't size with cells ?
Don't move or size with cells Anchor to page
Does anyone know how to get the effect "Move but don't size with cell" for
drawing object in AOO.
Re: [Calc] Dose Calc support Excel similar function "Move but don't
size with cell" for drawing object/picture
Posted by Shan Zhu <sh...@gmail.com>.
Hi, Lei
I do not found coresponding setting to mapping.
A workaround for your reference.
1. Create a drawing object (say, a shape), the default anchor should be To
Cell.
2. Right click it -> Position and Size.
3. In Position and Size dialog, tick the "Size" check box in "Protect"
section, click OK.
But the side-effect is the object size can not be adjusted in anyother way,
unless uncheck the check box.
Regards,
Shan Zhu
2012/7/5 Lei Wang <le...@apache.org>
> Hi,
>
> In Excel, user can set object positioning properties for a drawing
> object/graphic. There are three options. AOO does not have similar
> properties. But it use anchor attribute to reflect these properties.
> Excel AOO
> Move and size with cells Anchor to cell
> Move but don't size with cells ?
> Don't move or size with cells Anchor to page
>
> Does anyone know how to get the effect "Move but don't size with cell" for
> drawing object in AOO.
>
Re: [Calc] Dose Calc support Excel similar function "Move but don't
size with cell" for drawing object/picture
Posted by Shan Zhu <sh...@gmail.com>.
Hi, Lei
I do not found coresponding setting to mapping.
A workaround for your reference.
1. Create a drawing object (say, a shape), the default anchor should be To
Cell.
2. Right click it -> Position and Size.
3. In Position and Size dialog, tick the "Size" check box in "Protect"
section, click OK.
But the side-effect is the object size can not be adjusted in anyother way,
unless uncheck the check box.
Regards,
Shan Zhu
2012/7/5 Lei Wang <le...@apache.org>
> Hi,
>
> In Excel, user can set object positioning properties for a drawing
> object/graphic. There are three options. AOO does not have similar
> properties. But it use anchor attribute to reflect these properties.
> Excel AOO
> Move and size with cells Anchor to cell
> Move but don't size with cells ?
> Don't move or size with cells Anchor to page
>
> Does anyone know how to get the effect "Move but don't size with cell" for
> drawing object in AOO.
>