I want to use a fixed start cell in a range for a SUM function.
I'm working with XSLT 1.0 where I create this:
<Cell ss:StyleID="s76" ss:Formula="=SUM(K6:R[-1]C)">
But the formula appears in Excel as =SUM('K6':K19), and an error message pops up "The formula contains the unrecognized text".
I have tried this:
But this is not a good option, because the range can be changed.