Summary: | A way to avoid adding 'file:///D:/....'# paths to complex formulas when copying a tab to an other spreadsheet | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Borisz <borisz> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED WONTFIX | ||
Severity: | enhancement | CC: | borisz, JunkYardMail1 |
Priority: | medium | ||
Version: | unspecified | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: |
Description
Borisz
2024-05-03 10:38:45 UTC
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. (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. *** Bug 160928 has been marked as a duplicate of this bug. *** (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. If it is an option with the default being the current behavior then referencing a not existent sheet is not an issue. The values are copied. But sometimes the user wants the formulas, even if broken. They will fix them (add sheets, point them elsewhere, etc.) In such case, having a broken link is helpful. Makes them easier to spot. Break Link dialog option proposal (Menu: Links to External Files...) Replace with source document: O Values (default) O Formulas (value if local source not exist) O Formulas (forced) Being an option should take care of the case where the local source (sheet) does not exist. Hi! I agree. I have this issue regularly. A popup window would be the proper way to to let the user handling these situations. At least, it would be nice to warn the user if the copied sheet contains external references from the destination document's point of view. So is this issue will remain unsolved? |