I have a spreadsheet created in Excel and now using libre office calc ( I have saved the file in the ODS extension) and there is a cell in sheet 2 that reference a cell in sheet 1. I have tried to simply copy the cell from sheet 1 to the cell in sheet 2 and this doesnt work. I have tried to type in directly and no success. The result is the cell shows #NAME? Is there a way to reference the cell in sheet 1 and use it in sheet 2?
Thanks in advance