Bug 158674 - Pasting formulas in Writer tables does not dynamically adjust cell references
Summary: Pasting formulas in Writer tables does not dynamically adjust cell references
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-12 22:32 UTC by William Friedman
Modified: 2023-12-15 07:48 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-12 22:32:03 UTC
Description:
Copying and pasting formulas from a cell in a Writer table to other cells does not adjust the cell references accordingly, as it does in Calc and, apparently, in AOO (see the fourth comment here: https://forum.openoffice.org/en/forum/viewtopic.php?t=110041).

Steps to Reproduce:
1. Create a 3x3 table.
2. Enter numbers in cells A1, B1, A2, B2, A3, and B3.
3. In C1, enter the formula =<A1>+<B1>.
4. Select the entire cell C1.
5. Copy that cell.
6. Select cells C2 and C3.
7. Paste.

Actual Results:
The formula =<A1>+<B1> is pasted into cells C2 and C3.

Expected Results:
The formula in cell C2 should be =<A2>+<B2> and in cell C3 should be =<A3>+<B3>.


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:48:56 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 ***