[Libreoffice-bugs] [Bug 122634] New: Cannot reference cell when referencing cell "Number format" is Text

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 122634
           Summary: Cannot reference cell when referencing cell "Number
                    format" is Text
           Product: LibreOffice
           Version: 6.1.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: matti.jaatinen at norelco.fi

Description:
Cell B1 Number format is Text
Cell B2 Number format is General
Changing B1 function does not work.
Example:
- change function to =A2 then the displayed value is =A2.
- change function to back =A1 then the displayed value is =A1.

But changing B2 works. 
Example:
- change function to =A1 then the displayed value is 11.
- change function to =A2 then the displayed value is 22.

Steps to Reproduce:
1. 
Add cell A1 value 11 and A2 value 22.

2. 
Change cells B1 and B2 Number format to General.
Add cell B1 function =A1, should now evaluate as 11.
Add B2 function =A2, should now evaluate as 22.

3. 
Change B1 Number format to Text.
Change B1 function to =A2 it should now evaluate as =A2.
Change B2 function to =A1 it should now evaluate as 11.
Change B1 function to =A1 it should now evaluate as =A1.
Change B2 function to =A2 it should now evaluate as 22.
Change B1 Number format to General.
Change B1 function to =A2 it should now evaluate as 22.
Change B2 function to =A1 it should now evaluate as 11.



Actual Results:
1. 
Add cell A1 value 11 and A2 value 22.

2. 
Change cells B1 and B2 Number format to General.
Add cell B1 function =A1, should now evaluate as 11.
Add B2 function =A2, should now evaluate as 22.

3. 
Change B1 Number format to Text.
Change B1 function to =A2 it should now evaluate as =A2.
Change B2 function to =A1 it should now evaluate as 11.
Change B1 function to =A1 it should now evaluate as =A1.
Change B2 function to =A2 it should now evaluate as 22.
Change B1 Number format to General.
Change B1 function to =A2 it should now evaluate as 22.
Change B2 function to =A1 it should now evaluate as 11.


Expected Results:
1. 
Add cell A1 value 11 and A2 value 22.

2. 
Change cells B1 and B2 Number format to General.
Add cell B1 function =A1, should now evaluate as 11.
Add B2 function =A2, should now evaluate as 22.

3. 
Change B1 Number format to Text.
Change B1 function to =A2 it should now evaluate as 22.
Change B2 function to =A1 it should now evaluate as 11.
Change B1 function to =A1 it should now evaluate as 11.
Change B2 function to =A2 it should now evaluate as 22.
Change B1 Number format to General.
Change B1 function to =A2 it should now evaluate as 22.
Change B2 function to =A1 it should now evaluate as 11.



Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:

-- 
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/20190110/5b745149/attachment.html>