libreoffice reference cell in different sheet with sheet name with space
To reference a cell in a different sheet with a sheet name that contains a space in C language using LibreOffice, follow these steps:
- Open the LibreOffice Calc spreadsheet.
- Click on the cell where you want to reference the cell in the different sheet.
- Type the equal sign (=) to start the formula.
- Type the sheet name in single quotes ('') followed by an exclamation mark (!). For example, if the sheet name is "Sheet Name", the formula would be: 'Sheet Name'!
- Type the cell reference after the sheet name. For example, if you want to reference cell A1 in the "Sheet Name" sheet, the formula would be: 'Sheet Name'!A1.
- Press Enter to complete the formula and display the value of the referenced cell.
By following these steps, you can reference a cell in a different sheet with a sheet name that contains a space using LibreOffice Calc.