https://bugs.freedesktop.org/show_bug.cgi?id=78074
Priority: medium
Bug ID: 78074
Assignee: [email protected]
Summary: Other: Paste Special should have an option to paste
raw formulas
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.0.4 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
Currently, there is no way to copy and paste a range of cells containing
formulas without changing any cell coordinate or spreadsheet references
contained in formulas.
There should be an option in the Paste Special dialogue to let the user paste
formulas without having them modified according to the where it is pasted.
This option could be presented as a box to tick, and could be named "paste raw
formulas".
This could be useful for example for documents or sheets sharing the same
structure and referring to data that shows different values but is organised in
the same manner. If a table is enhanced in one spreadsheet, the user might want
to copy it and replace the ones in the other sheets/documents.
A table could contain fixed coordinates (using "$") and non-fixed coordinates
and the user would like to copy the raw formulas without worrying about the
action linking cells from a different spreadsheet or document.
Another case would be that the user simply wants to place a number of
formula-containing cells somewhere else in the sheet without getting all the
coordinates shifted accordingly, and without having to go back into each
formula to add "$" signs.
As this option could result in errors (especially when copying from one
document to another with different sheet names), there could be a warning
dialogue letting the user know that "This option might produce errors in cells
that contain a reference to an object that does not exist in the document".
This dialogue could appear only when the action is made from one document to
another.
Operating System: All
Version: 4.1.0.4 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
