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
Created attachment 168065 [details] Spreadsheet with formulas Forgot to include this with the bug report
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.
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.