-
Notifications
You must be signed in to change notification settings - Fork 15
Description
I've noticed a problem where occasionally when saving a sheet the references will be replaced by the values. For example, let's say I create a new 100x100 image in A1
, then open an existing 10x10 image in A2
, and use Image_insert_item
to insert A2
into A1
in A3
. If I set A3.place.left
to A1.width / 2
, sometimes when I save an re-open the worksheet, the value of A3.place.left
will be A1.width / 2
and sometimes it will be 50
.
I can't yet pinpoint under what circumstances the reference is lost, and not all references in the worksheet will be lost. I haven't kept careful track but my impression is that it's more likely for references in sub-rows rather than main rows. E.g. If I set A2
to C2
, that seems more "sticky" than if I set A3.place.left
to C2
.
Thanks!