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:

  1. Open the LibreOffice Calc spreadsheet.
  2. Click on the cell where you want to reference the cell in the different sheet.
  3. Type the equal sign (=) to start the formula.
  4. 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'!
  5. 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.
  6. 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.