Named Range As Print Range

asked 2018-04-07 00:25:57 +0200

PAlotta gravatar image

updated 2018-04-07 00:26:19 +0200

I am using LO Calc Version: (x64). I am trying to set a print range using a named range. I set up the named range under Sheet > Named Ranges and Expressions > Define, named and defined the range, and selected the "Print Range" check box under "Range Options". The Help file for this option says that "Print range Defines the area as a print range".

So now how do I use it? If I define a print range under Format > Print Ranges > Edit, I can't see how to use the named range. If I type the name into the Print Range field after selecting "- user defined -" from the drop-down, I get the error "Invalid sheet reference." The scope of the named range is the sheet and the Help file says nothing about print range definition format.

What am I doing wrong?


edit retag flag offensive close merge delete


I take it that this was a dumb question.

PAlotta gravatar imagePAlotta ( 2018-05-03 02:55:36 +0200 )edit