Bug 138825

Summary:	Calc Formula references not consistant
Product:	LibreOffice	Reporter:	Doug <dbondo1>
Component:	Calc	Assignee:	Doug <dbondo1>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	miguelangelrv, srdosm
Priority:	medium
Version:	Inherited From OOo
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Spreadsheet with formulas

Description Doug 2020-12-11 15:17:16 UTC

Description:
Creation of a formula such as "=($B$2-$B$3)/$B$3 and using this symbol "$"  to restrict the formula to the cell location still does not work. If you move or cut the numeric value in the cell and move or paste it into another cell in that same spreadsheet, the formula moves with the numeric value rather than staying with the cell

The only way to change the location of of the numeric value and not have the formula follow the location is to cut it from the spreadsheet paste it special into another spreadsheet without the formula and then either copy it and paste it back into the original spreadsheet.

Example attached.

Steps to Reproduce:
1.Move value in cell from B2 to B3
2.  or cut cell value in B2 and paste into any other spread sheet cell
3. Cut B2 value, paste special into a different spread sheet without formula and then copy the value into the original spreadsheet B3

Actual Results:
$B$2 designation to a specific cell does not restrict a formula to that cell

Expected Results:
It works,  but cumbersome.


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no

Comment 1 Doug 2020-12-11 15:19:52 UTC

Created attachment 168065 [details]
Spreadsheet with formulas

Forgot to include this with the bug report

Comment 2 m_a_riosv 2020-12-12 11:11:32 UTC

If you want to copy only the value in B2 to B3.
- Copy [Ctrl+C]
- Go to B3
  - Right click - Paste - Number
  or
  - Paste special [Shift+Ctrl+V] without formula

Maybe I don't understand what it's wanted to do.

Comment 3 Martin Srdoš 2020-12-19 20:26:11 UTC

How m.a.riosv say,
use copying. When you use move, the address of cell is also changed. The $ means that the address don't move only in sense of one formula inside the cell.