https://bugs.documentfoundation.org/show_bug.cgi?id=147879
Bug ID: 147879
Summary: Cell formula reference is broken when I delete several
columns which are not referenced by the formula
Product: LibreOffice
Version: 7.4.0.0 alpha0+ Master
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 178753
--> https://bugs.documentfoundation.org/attachment.cgi?id=178753&action=edit
refTest.xlsx
Steps to Reproduce:
1. Open the attached xlsx file.
2. Ctrl+A to select all, then right-click on any column header and select "Show
Columns". Observe that the cell formulas in the last two columns do not
reference to any cells in columns N:S.
3. Delete columns N:S.
Current Result:
Cells in the last two columns (e.g. W:X) are shown as #VALUE!.
Note that although cells W8:X8 are not #VALUE!, the cell reference is already
broken and a hard-recalculation will make it #VALUE!.
Expected Result:
Cells in the last two columns should remain is they were before the (previous)
columns N:S were deleted, as the formula references in these cells did not
referenced to any cells in those deleted columns.
Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: 279abd670317760dd1d58c549a0589c3a31c1e4d
CPU threads: 8; OS: Linux 5.16; UI render: default; VCL: gtk3
Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN
Build Platform: Fedora34@X64, Branch:master, bibisect-linux-64-7.4-CN
Calc: threaded
Fedora 34, Gnome 40.8 x11.
--
You are receiving this mail because:
You are the assignee for the bug.
