Answers for "libreoffice reference cell in different sheet with sheet name with space"

C

0

libreoffice reference cell in different sheet with sheet name with space

# Sheet name without spaces or special characters
=SheetName.A1

# Sheet name with spaces or special characters
='Sheet name'.A1
# or if you wath to make sure the sheet name does not change
=$'Sheet name'.A1

# src: https://help.libreoffice.org/3.3/Calc/Referencing_a_Cell_in_Another_Document
# src: https://ask.libreoffice.org/en/question/170921/calc-need-syntax-for-sheet-with-a-space-in-its-name/

Posted by: Guest on June-18-2021

Source

Code answers related to "libreoffice reference cell in different sheet with sheet name with space"

Code answers related to "C"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#