Issue 72098 - Format - Print Ranges - Edit... lists named (print) ranges that not correspondent to the actual sheet
Summary: Format - Print Ranges - Edit... lists named (print) ranges that not correspon...
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.0.4
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: usability
Depends on:
Reported: 2006-11-29 12:37 UTC by mroe
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

sample document (6.29 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-03-14 07:02 UTC, Rainer Bielefeld
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description mroe 2006-11-29 12:37:07 UTC

- activate Sheet1
- Insert - Names - Define...
.. Name: printrange01
.. Assignd to: $Sheet1.$B$2:$G$8
. [ More ]
.. [x] Print range
. [ OK ]
- activate Sheet3
- Format - Print Ranges - Edit...
 => Listbox Print Range contains "printrange01"
If you select this entry then you define a print range $B$2:$G$8 on the actual
sheet Sheet3.

I think, that a named (print) range which is defined absolute to a sheet should
not appear at other sheets. If the range is defined relative to a sheet
($B$2:$G$8 or Sheet1.$B$2:$G$8), then it is right that the named print range
appear at all sheets.

greetings MRoe
Comment 1 olly600 2006-12-20 10:32:05 UTC
Can you please try this out with OOo version 2.1 release Candidate 2 as I can't
replicate it.
Comment 2 Rainer Bielefeld 2007-03-14 07:00:56 UTC
I checked with "2.2.0RC2  Multilanguage/German version WIN XP:
[680m9(Build9124)]"  and can confirm the problem. Steps to reproduce: 

1. Open attached "samplefile.ods"
2. Go to 'Sheet1'
3. Menu 'Insert > Name > define'
   You will find "ptintrange01" for '$Sheet1.$B$2:$G$8' 
   (click on name to see the range).
4. close dialogue
5. change to "Sheet3"
6. Menu 'Format > Print Ranges > Edit...'
7. Select "ptintrange01" in pulldown for Print range'
   expected: displayed range '$Sheet1.$B$2:$G$8'
   actual: displayed range   '$B$2:$G$8'
The print range has been defined for 'Sheet1' (and you will see so when you
define more print ranges with 'Insert > Name > define'), but in step 7 it looks
as if it has been defined for 'Sheet3'.

@mroe: please specify your OS and Platform!
Comment 3 Rainer Bielefeld 2007-03-14 07:02:25 UTC
Created attachment 43694 [details]
sample document
Comment 4 frank 2007-03-14 16:36:25 UTC

IMHO not a bug. With Insert-Names-Define you have defined a name for a
Printrange. With Format-Printranges-Edit you can define and activate the
printrange independend for each sheet. So these options are totally different. 

But let's UX decide.

Comment 5 matthias.mueller-prove 2009-09-06 10:55:56 UTC
I am no longer officially active on OOo. Please take over.