How to insert fixed cell reference in libreoffice writer table

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…