Description: With writer, it is possible to use simple functions in tables (sum, max, min, etc.). It used to be possible to copy a cell's content to other cells, in which case cells references in formulas were updated accordingly upon pasting. This is no longer the case. Steps to Reproduce: 1. create simple table in Writer 2. set the value 1 in cell A1 3. set the formula =<A1>+1 in cell A2. It gives 2 as a result. 4. select whole A2 cell, copy and paste it in A3. Actual Results: Result in A3 is 2: the pasted formula in A3 is =<A1>+1. Cell reference <A1> has not been changed to <A2> upon pasting. Expected Results: Result in A3 should be 3: the pasted formula in A3 should have evolved to =<A2>+1. Reproducible: Always User Profile Reset: Yes Additional Info: I noticed this bug today. My libreoffice has been updated to 7.6.2.1. Same behaviour with Libreoffice snap 7.6.1.2
Created attachment 189885 [details] example file with actual and expected paste results
Created attachment 189886 [details] corrected example file (correct cells references in description)
Tested with previous installed version (7.3.7.2), Writer behaves as expected. So this is a confirmed bug in 7.6 series.
Tested with 7.5.6.2, no problem whatsoever. So this bug probably affects only newest 7.6 branch.
Thank you for the report! Reproduced in: Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: e9374f74385d7dfe77d1902d3d82af20143bc775 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Version: 7.6.2.1 (X86_64) / LibreOffice Community Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded No repro in: Version: 7.5.7.1 (X86_64) / LibreOffice Community Build ID: 47eb0cf7efbacdee9b19ae25d6752381ede23126 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded I bibisected before realising it was already reported in bug 157132. Bibisected with linux-64-7.6 repo to first bad commit 1a2e4312444d568a2b9e0aa113e496dd08f83e39 which points to core commit: commit 8a3dc12a13a3b9e99dbd5000ca6a1d541cf472f7 author Bjoern Michaelsen Sat Mar 04 02:18:58 2023 +0100 committer Michael Stahl Tue Mar 14 10:25:01 2023 +0000 remove support for TBL_BOXNAME TBL_RELBOXNAME in ChangeState * PtrToBoxNm and ToRelBoxNm are both public -- use just them directly instead. Reviewed-on: https://gerrit.libreoffice.org/c/core/+/148213 *** This bug has been marked as a duplicate of bug 157132 ***