Re: Drag & Drop between workbooks

[Jody Goldberg <jody gnome org>]

On Mon, Mar 03, 2003 at 10:54:50AM +0100, Lutz M?ller wrote:
> On Mon, 2003-03-03 at 04:53, Jody Goldberg wrote:
> > > * src/commands.[c,h] (cmd_delete_sheet, cmd_insert_sheet): New.
> >
> > There is quite a bit of deep magic in the sheet life cycle.  The
> > simple life cycle you posit in your implementation would be nice,
> > but is definitely not reality.  Detaching will leave dangling
> > references to the sheet, and re-attaching will not restore all of
> > the changed things.
>
> I checked only the references in the sheet that got moved, and those
> will be made absolute (i.e. changed from "=Sheet2!A1" to
> "=[/home/lutz/Test.gnumeric]Sheet2!A1"). So, no problem here. 

Yes, that is taken care of trivially.
 
> However, you are right, the references _to_ the sheet need to be
> adjusted, too. Will look into this.
Its non trivial.  There is a major open design issue to support
undoable sheet deletetion.
    sheet_deps_destroy

does some magic to handle names, and different types of references
to and from.

You best bet may be to simply move all of the content from the old
sheet to the new sheet.  That will not handle objects or names, but
will handle references to and from.