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:
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Created attachment 149247 [details] Example with 4 sheets.
It is the expected behaviour: https://ask.libreoffice.org/en/question/41364/functions-ignored-in-calc/