Joined: 07 May 2018
OpenOffice Calc will not let me reference a cell in a different sheet in the same file in certain cells of the original sheet. Many other cells on the same sheet as the cell in question contain a references to a cells in the second sheet, but the cell in question will not reference the cell in the second sheet. To create the reference I press the = sign while in the original cell, click to the other sheet, click on the cell I want to reference, and then press enter key. All I get in the original cell is the = sign. There are a few cells in this sheet that have this problem. Most cells work fine. Can anyone help?
I didn't find the right solution from the Internet.