https://bugs.documentfoundation.org/show_bug.cgi?id=160922
Bug ID: 160922
Summary: A way to avoid adding 'file:///D:/....'# paths to
complex formulas when copying a tab to an other
spreadsheet
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: bor...@adott.hu
Description:
In my line of work, I have to produce documents that have complex calculations
about component parameters. In many cases, I would like to copy some tabs to an
other spreadsheet to do the calculations for a new product.
But where a cell's formula uses cells from other sheets, they will be augmented
with file refeneces to the source file in the new file. And many times not just
once, makes a formula extremly long.
This even happens where the target file has the same tabs.
There is only one solution, I have to use find and replace on formulas to
remove all file references. 'file:///D:/....'#
So it would be good to have an option like "do not change formulas" to the
window where you copy a tab to an other spreadsheet.
Some other people with the same issue:
https://ask.libreoffice.org/t/formulas-move-and-copy-in-another-file/99999/2
https://ask.libreoffice.org/t/calc-copy-formulae-without-adjusting/22474
Steps to Reproduce:
1.On spreadsheet1, create two tabs. Do some calculations on on of the first
sheet that uses a cell from the second sheet.
2.Copy first sheet to an other spreadsheet.
3.Check the formulas on the new spreadsheet
Actual Results:
Formulas that reference on cell(s) of an other tab on the source spreadsheet
got file path referenced to the source file.
Expected Results:
Have a checkbox or something to disable formula augmentation.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.6.6.3 (X86_64) / LibreOffice Community
Build ID: d97b2716a9a4a2ce1391dee1765565ea469b0ae7
CPU threads: 12; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
