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...
Status: CONFIRMED
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:
URL:
Keywords: usability
Depends on:
Blocks:
 
Reported: 2006-11-29 12:37 UTC by mroe
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
sample document (6.29 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-03-14 07:02 UTC, Rainer Bielefeld 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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 
Hello!

Sample:
- 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 
Hi,

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.

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