Hello, I am searching for the equivalent of adding dollar signs in calc for writer.
e.g. =SUM(C6:C7)
in libreoffice calc corresponds to =sum<C6:C7>
in a libreoffice writer table.
What is the equivalent of SUM(C6:$C$7)
?
Hello, I am searching for the equivalent of adding dollar signs in calc for writer.
e.g. =SUM(C6:C7)
in libreoffice calc corresponds to =sum<C6:C7>
in a libreoffice writer table.
What is the equivalent of SUM(C6:$C$7)
?
Quoting @Denny1: “What is the equivalent of SUM(C6:$C$7)?”
There is none. Writer tables, and in specific using them with formulas is a mess.
The formula “language” is extremely poor and next to useless. Imo?
Thank you, that is a pity…