How to define a print range with INDIRECT()? [closed]

asked 2014-03-05 09:57:53 +0200

jene gravatar image

updated 2015-09-11 21:43:55 +0200

Alex Kemp gravatar image

Hi,

I'm using LibreOffice 4.2.1.1, English and I want to define a print range using indirect:

=INDIRECT($Sheet1.$A$1)
  1. I tried to insert it directly in the Edit Print Range, didn't succeed -> Invalid sheet reference.
  2. I defined a name (Insert - Names - Define) with Range: =INDIRECT($Sheet1.$A$1), Scope: Document (Global), Range Options: Print range The Name doesn't show up in the Edit Print Range...

What am I missing?

Thanks

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-20 06:08:47.333194