I am using LO Calc Version: 22.214.171.124 (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?