Calc Print Settings
Sheet Property “Print Entire Sheet”

OpenOffice.org 2.0

Document - ID	Specification Owner	Last Change	Status
	Daniel Rentz	2003-10-15	Final
Conforms to	StarOffice Specification Workflow v0.1, Aug 2003
Applies to	Calc
Task ID(s)	i4063
Category	Feature

Abstract

To increase compatibility to Microsoft Excel, Calc needs addition for document print settings. This setting will allow printing of entire sheets in case they do not contain any defined print ranges.

This specification will define how Calc will implement this feature.

i-Team Members

	Name	E-mail Address
Specification Owner	Daniel Rentz (dr)	daniel.rentz@sun.com
User Experience	Falko Tesch (ft)	falko@sun.com
Development	Daniel Rentz (dr)	daniel.rentz@sun.com
Quality Assurance	Oliver Crämer (oc)	oliver.craemer@sun.com
Documentation	Frank Peters (fpe)	fpe@sun.com

Approved for Implementation

	Approved by	Date
User Experience	Falko Tesch	2003-09-24
Development	Daniel Rentz	2003-10-14
Quality Assurance	Frank Stecher	2003-10-14
Documentation	Frank Peters	2003-10-14
String Review	Elizabeth Matthis (em)	2003-10-15

Document Change History

Rev. Level	Change	Initials	Date
1.0	Initial version	dr	2003-06-29
1.1	Converted to new specification template	dr	2003-09-24
1.2	Reviewed by User Experience	ft	2003-09-24
1.3	Reviewed by Quality Assurance and Documentation	fst/fpe	2003-10-14
1.4	Final UI string review	em	2003-10-15

Contents

Glossary	1

1	Motivation	1

2	Goals	1

3	Requirements and Dependencies	1

3.1	Requirements	1

3.2	Technical Dependencies	1

4	User Scenarios	1

5	Competitive Analyses	1

6	Detailed Specification	2

6.1	Error Conditions	2

7	Future Tasks	2

8	Legal Issues	2

9	Notes	3

10	References	3

Glossary

Term	Description
Print range or print area	A range of cells in a sheet that will be printed.
Automatic print range	The minimal cell range containing all data in a sheet, if it does not contain a user-defined print range.

Motivation

Enhancing Ease-of-Use as well as easing the learning curve for MS Excel users and enhancing the compatibility of imported Excel documents.

Goals

Interoperability with MS Excel documents.

Ease-of-Use with Excel. It is mandatory that the users find a comparable interface within the same interface structure as in Excel.

Consistency. Although this feature should fulfill the expectations of most users, it must fit seamlessly into the existing Calc user interface and naming conventions and glossary.

Requirements and Dependencies

Requirements

Imported MS Excel documents should behave equally in Calc. This feature adjusts the behavior on printing the document.

Technical Dependencies

None.

User Scenarios

Most users of spreadsheet applications define print ranges in their spreadsheets when they want to print a different range in the current sheet. They do not expect a change of the automatic print ranges on other sheets.

Competitive Analyses

See chapter 6 “Detailed Specification“.

Detailed Specification

The current behavior of other spreadsheet applications is to print all defined print ranges, and additionally all sheets that do not contain print ranges. SO/OOo Calc prints the defined print ranges only, or the entire document, if there are no print ranges at all. It omits all sheets that do not contain a print range.

A new predefined print range “entire sheet” will be added to each sheet. This print range will occur in the list box of the “Edit Print Ranges” dialog of the current sheet (Format – Print Ranges – Edit). There are already the predefined print ranges “-none-” and “-user defined-”.

Figure 1: The “Edit Print Ranges” dialog The XML filter will be set to “none” to keep the old behavior. The Microsoft Excel import filter will use the new print range for sheets without print ranges to achieve the new behavior.

The default for new documents remains “no print range”.

String list

Item	English	German	Comments
New predefined print range in “Format – Print Ranges – Edit” dialog	- entire sheet -	- ganze Tabelle -	

Tab Order

No change of any tab order.

Key Board Shortcuts

No new shortcuts.

Error Conditions

None.

Future Tasks

Final decision on the default setting for new documents. This decision must be made by the MS Interoperability team.

Legal Issues

None.

Notes

None.

References

OpenOffice.org issue: http://www.openoffice.org/issues/show_bug.cgi?id=4063

PCD-ID: MSInteroperability-8

Calc Print Settings – Sheet Property “Print Entire Sheet”

Page 3

http://specs.openoffice.org/calc/compatibility/printsheet.sxw

Calc Print Settings Sheet Property “Print Entire Sheet”

Daniel Rentz

2003-09-24T12:14:25

Matthias Müller-Prove