Description: Inserting and deleting columns in a Writer table preserves formulas by switching existing column references in formulas to the new column. Cutting and pasting, however, breaks existing formulas. Steps to Reproduce: 1. Create a 3x2 table. 2. Put numbers in cells A1, B1, and C1. 3. In cells A2, B2, and C2, put formulas =<A1>, =<B1>, and =<C1>. 4. Click on cell A1. Right-click | insert column after. 5. Notice that the formulas now in C2 and D2 have been updated. 6. Select the new column and delete it. 7. Notice that the formulas now in B2 and C2 have been updated. 8. Select column 3. Cut it (ctrl-x). 9. Go into cell B1. Paste. Notice that the formula in B2 has now been switched correctly to C2, but that the new B2 says ** Expression is faulty ** and that the formula is now =<?>. 10. Empty column 2. Select the text of column 1 or 3 and copy it (ctrl-c). Paste it into column 2. 11. Notice that the formula in B2 is either =<A1> or =<C1>, rather than the being updated to =<B2>. Actual Results: Cutting and pasting breaks the formula (=<?>); copying and pasting fails to update the formula. Expected Results: The formula should be updated to correspond to the new columns. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.6.2.1 (X86_64) / LibreOffice Community Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333 CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded
This looks like a duplicate of bug 157132. Please update your Libreoffice version to the latest 7.6.4.1 *** This bug has been marked as a duplicate of bug 157132 ***