Ask Your Question

Named Range As Print Range

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

PAlotta gravatar image

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

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 +0100 )edit

BTW it is a address range or a range defined by a formula?

m.a.riosv gravatar imagem.a.riosv ( 2019-10-27 15:28:59 +0100 )edit

I was using a formula to create a dynamic range in the project I was working on referenced above. However, I believe that I also tried using an address range to check the behavior.

Print Previews did not show the results I was looking for.


PAlotta gravatar imagePAlotta ( 2019-10-29 01:36:53 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-10-27 03:42:43 +0100

Try changing the scope of the named range to global.

Then you should be able to select it via Format > Print Ranges > Edit.

See if Print Preview shows what you want to see. Or do a provisional export to PDF to see if you get what you want.

I came across your question while searching for help with named print ranges. I'm using LO on Win7 and it seems some aspects of them still don't work correctly. Or maybe my expectations are too high. :D

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-04-07 00:25:57 +0100

Seen: 277 times

Last updated: Oct 27 '19