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@lists.freedesktop.org
Reporter: matti.jaati...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
