Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Named Range and print

In Excel I can assign the code below as a Named Range to define a dynamic print area, and then assign the Named Range under Print Range.

If I try to do the same in LibreOffice Calc it doesn't work; I can't see the Named Range when I choose Choose Format - Print Ranges - Edit.

Anyone that have any Idea what to do?

The code is

OFFSET($Sheet2.$A$1;0;0;(COUNT($Ark2.$D:$D)+1);4)

Named Range and print

In Excel I can assign the code below as a Named Range to define a dynamic print area, and then assign the Named Range under Print Range.

If I try to do the same in LibreOffice Calc it doesn't work; I can't see the Named Range when I choose Choose Format - Print Ranges - Edit.

Anyone that have any Idea what to do?

The code is

OFFSET($Sheet2.$A$1;0;0;(COUNT($Ark2.$D:$D)+1);4)
OFFSET($Sheet2.$A$1;0;0;(COUNT($Sheet2.$D:$D)+1);4)