Bug 127269 - Calc and Formulas copying: Issue if a cell with formulas that use recognized names as addressing, is copy-pasted to a range of cells
Summary: Calc and Formulas copying: Issue if a cell with formulas that use recognized ...
Status: RESOLVED DUPLICATE of bug 115654
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4 all versions
Hardware: IA64 (Itanium) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-09-01 21:31 UTC by Andsper
Modified: 2020-04-29 22:51 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 Andsper 2019-09-01 21:31:46 UTC
Description:
If a cell with formulas that use recognized names as addressing (for example to multiply the value of two columns), is copy-pasted to a range of cells, the formulas are pasted, but the cells show the value of the copied cell.
If the cell is copy / pasted to another cell in the same column, the pasted cell shows the updated value.
Example:
1      Price   Quantity   Total
2       1       25         ='Price'*'Quantity'
3
4

It works if the formula is copied below to line 3 or 4
It does not work if it is pasted to both line 3 and 4

It happened on a previous version 5.XX, but I didn't note which one it was exactly. Same happens with 6.1.6.3

Steps to Reproduce:
1.Create column titles
2.Create a formula that uses recognized names as addressing (see example)
3.Type values in the two columns that are used by the formula
4.Copy paste the formula to a range of cells below


Actual Results:
The formulas show the value of the cell that was copied.
To see the right value in a specific line, you must copy the original cell to the specific line (not no a range of cells)

Expected Results:
After doing paste, it should display the right calculation


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Comment 1 Mike Kaganski 2019-09-02 04:20:35 UTC
Reproducible with Version: 6.3.1.1 (x64)
Build ID: e979878b49a48dab15ebe528f238b88125e32c65
CPU threads: 12; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded
Comment 2 Mike Kaganski 2019-09-02 04:22:41 UTC
Options->LibreOffice Calc->Calculate must have "[x] Automatically find column and row labels" checkbox checked.
Comment 3 Gilward Kukel 2020-04-29 22:51:52 UTC

*** This bug has been marked as a duplicate of bug 115654 ***