Issue 24830 - Make printing named ranges easier
Summary: Make printing named ranges easier
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1 RC5
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2004-01-26 15:51 UTC by falko.tesch
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description falko.tesch 2004-01-26 15:51:22 UTC
Make printing named ranges easier

1. Since I am just creating a named range, I always look under the
   Menu-Format column. Under the Format column, I don't find ranges
   as expected. All I find is something called "print ranges". So I
   figure Star calls it's ranges "print ranges". Strange so I
   try all the options: 1) define, 2) add, 3) remove, 4) edit.
   None of these generate an option to name the range. Finally
   I check other menu options, and find Menu-Insert-Names-define.

   Whew, mutter, mutter, mutter. Ok, finally found expected option
   to either name a range by address or by selecting areas of the
   spreadsheet. Create my name and click ok.

2. My navigation steps to create a Range Name
   1-- Menu|Format|Print Ranges|define
   2-- Menu|Format|Print Ranges |Add
   3-- Menu|Format|Print Ranges|Edit
   4-- Menu|Format|Print Ranges|remove
   5-- Menu|Insert|Names|Define
   6-- Name range
   7-- click ok

3. My navigation steps to print range
   1-- Menu|file|print
       Opps, where is the option to print a named range? There is
All/Pages/Selection but no option to select named range or to select an unmamed
   2-- Find the range name selection drop down exactly where expected, to the
       left of the edit line.
   3-- select desired range name
   4-- Go to Menu|Page Preview to see what will be printing.
       Opps shows entire sheet and NOT named range. Now what????
   5-- Go and ask around for help. Come back much later and change
       definition of range to Print range.
   6-- Return to Menu|Page Preview. What??? still shows entire sheet.
       What gives. Embarassed to ask again how to print this selection.
   7-- Go to Menu|Print, weird selection is grayed out, so try printing
   8-- Darn, printed page is whole page and not named range.
   9-- Deselect named range
  10-- Select area I want to print
  11-- Menu|Print|selection
  12-- Finally got desired printout. Assume print ranges function is broken
       in scalc. Mutter, mutter, mutter.

> Navigating between different print ranges to be printed
> is also possible at the moment. Just open 'Format'=>'Print Ranges' => 'Edit'
> and select the appropriate print range you previously defined.
> If this handling doesn't seem to be 'user friendly' for our customers, I'd
> like to ask you for a proposal for an improved UI in this case. A reference
> application showing us a better UI would also be of some value for us.

The navigation method I am familar with is Lotus 1-2-3,v9.

A. Steps to create range name:
   1. Menu|Range|Name|
   2. enter name and either cell reference or selected range, and ok.

B. Steps to print range
  1. Use range navigator to left of edit line and select desired range name.
  2. Either Menu|Print or Cntl-P. Default is print entire sheet.
  3. Click on Selected range which is already defined, and click ok.

C. Step to adjust print output
   Click on one of the printing icons before printing to format
   printed range. Available toolbar icons are:

   1. page orientation, portrait
   2. page orientation, landscape
   3. fit all data on page
   4. fit all columns on printed page, automatically determines number of pages
   5. fit all rows on printed page, automatically determines number of pages needed
   6. insert horizontal page break
   7. insert vertical page break
   8. set columns as print titles
   9. set rows as print titles
   10. center vertically on page
   11. center horizontally on page
   12. center both vertically and horizontally on page

The icons I use all the time are Portrait/Landscape/ all cols on page/ all on
one page.

Some users do not like the inability of Lotus to have non-continuous named
ranges. But I have not heard of any user feedback about any other problems with
the Lotus method.

To summarize, once used to print methods.

StarOffice to name a range: 3 steps. New users forget to define as print range.
StarOffice to print a range: ?? steps.  No known method to get range of A1:j200
on a page so all columns are on the pages, except trail and errow.

Lotus to name a range: 2 steps.
Lotus to print a range: 3 steps.
Lotus additional steps to fit all columns on a page: 1 step, click on icon.

What is needed:
 1. default to define all new ranges as print ranges without selecting more
    but with user option to deselect as print range.
 2. A simplier process for printing selected range/print range.
 3. an one step method for users to adjust:
    a) print range as landscape with columns not spanning printed page, or
    b) print range as portrait with columns not spanning printed page and
       number of pages expanded as needed.
 4. I would also love to have a printing icon set where with one click I could
    adjust the print output without going thru the menus.

I can give you access to Lotus if you wish to see how they handled printing.

You may have futher questions. If so, please feel free to contact me.
Thank you.
Comment 1 falko.tesch 2004-01-26 15:51:51 UTC
Changed target
Comment 2 falko.tesch 2005-10-20 20:21:08 UTC
FT: Re-assigned to requirement default user
Comment 3 ace_dent 2008-05-16 01:42:28 UTC Issue Tracker - Feedback Request.

The Issue you raised is currently assigned to 'Requirements' pending review, but
has not been updated within the last 2+ years. Please consider re-testing with
one of the latest versions of OOo, as the problem(s) may have already been
addressed. Either use the recent stable version:
or consider trying the new OOo 3 BETA (still in testing):
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~