https://bugs.documentfoundation.org/show_bug.cgi?id=147916
Bug ID: 147916
Summary: When copying a cell to a newly inserted sheet,
absolute sheet name is not reserved thus the pasted
formula is broken
Product: LibreOffice
Version: 6.1 all versions
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: suokunl...@126.com
Created attachment 178795
--> https://bugs.documentfoundation.org/attachment.cgi?id=178795&action=edit
sheet_name_ref_test.ods
Steps to Reproduce:
1. Open the attached ods file.
2. Select A1:B2 in sheet1, ctrl+c to copy.
3. Insert a new sheet between sheet1 and sheet2 (it's named as "Sheet 5").
4. Select a cell in "Sheet 5", ctrl+v to paste.
Current Result:
In cell B2 of "Sheet 5", the pasted formula is =VLOOKUP(A2,$sheet3.A:B,2,0)
thus the result is #N/A.
It seems that the absolute reference $ is ignored during copy paste of the
formula.
Expected Result:
In cell B2 of "Sheet 5", the pasted formula should be
=VLOOKUP(A2,$sheet4.A:B,2,0) thus the result should be 100, because the source
formula uses absolute reference and it should be retained during copy paste.
Reproducible on
Version: 7.3.2.0.0+ / LibreOffice Community
Build ID: 789fbf732ad6db002fd83b307385940c392cc457
CPU threads: 8; OS: Linux 5.16; UI render: default; VCL: gtk3
Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN
Calc: threaded
and also on current master
Also in Version: 6.1.7.0.0+
Build ID: 5b3765f4d881e7ddefd0c4aad6886a46f000b4fc
CPU threads: 8; OS: Linux 5.16; UI render: default; VCL: gtk3;
Locale: zh-CN (zh_CN.UTF-8); Calc: group threaded
--
You are receiving this mail because:
You are the assignee for the bug.
