https://bugs.documentfoundation.org/show_bug.cgi?id=160922
Borisz <bor...@adott.hu> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |bor...@adott.hu
Resolution|WONTFIX |FIXED
--- Comment #2 from Borisz <bor...@adott.hu> ---
(In reply to Eike Rathke from comment #1)
> It has to be that way. If a reference references another sheet, copying only
> the referencing sheet into another document has to create such external
> reference, otherwise it would be broken, pointing to an arbitrary other
> sheet or resulting in #REF! in case an accordingly positional sheet does not
> exist. You can however copy _both_, the referencing and the referenced
> sheets, _all at once_ (i.e. multi-select the sheets before copying), then
> the references are kept intact and still will point to the sheet(s) copied
> along.
But the referenced sheet(s) are already there in the target file. That's why I
can fix this by manually remove the file path strings from the formulas using
find and replace. But it is a quite tediuos process...
>From my point of view, I can fix any missing reference later, that's why I
suggest a checkbox or something to Calc do not touch the formulas.
--
You are receiving this mail because:
You are the assignee for the bug.
