[Libreoffice-bugs] [Bug 138825] New: Calc Formula references not consistant

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138825

            Bug ID: 138825
           Summary: Calc Formula references not consistant
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dbondo1 at gmail.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201211/0474e47f/attachment.htm>