Bug 158716 - Cutting and pasting columns in Writer tables breaks formulas
Summary: Cutting and pasting columns in Writer tables breaks formulas
Status: RESOLVED DUPLICATE of bug 157132
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
7.6.2.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-12-14 23:10 UTC by William Friedman
Modified: 2023-12-15 07:47 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description William Friedman 2023-12-14 23:10:09 UTC
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
Comment 1 Xisco Faulí 2023-12-15 07:47:20 UTC
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 ***