# Test Name: Sheet Property 'Print Entire Sheet'

Document Owner: Vladimir Kozlovsky | Last Document Change: 27. Apr. 2009 | Status of Document: Preliminary

### Test purpose

Verify that the menu item 'Format -> Print Ranges - > Edit...' works as expected

### Known issues:

- issue 4063

### Preconditions of the test:

- none

### Test documents:

- i4063_Sheet Property 'Print Entire Sheet'_TCS.xls

### Test cases:

Verify if 'Format -> Print Ranges - > Edit...' works as expected

- Open a new calc document by 'File -> New -> Spreadsheet'

- Select 'Sheet1'

  Select 'Format -> Print Ranges -> Edit'

  ##### Expected result:

  Drop Down List 'Page range' is set to '- none -' and has 'empty' value

  Click 'Cancel'

- Select 'Sheet2'

  Select 'Format -> Print Ranges -> Edit'

  ##### Expected result:

  Drop Down List 'Page range' is set to '- none -' and has 'empty' value

  Click 'Cancel'

- Select 'Sheet3'

  Select 'Format -> Print Ranges -> Edit'

  ##### Expected result:

  Drop Down List 'Page range' is set to '- none -' and has 'empty' value

  Click 'Cancel'

  Click on clickable image 'Page Preview'

  ##### Expected result:

  nothing is previewed

  Click on clickable image 'Page Preview' to return to 'edit' mode

- Select 'Sheet1'

  Select A1 cell

  Populate A1 cell with text "Sheet1 TL"

  Select F49 cell

  Populate F49 cell with text "Sheet1 BR"

  Select 'Sheet2'

  Select A1 cell

  Populate A1 cell with text "Sheet2 TL"

  Select F49 cell

  Populate F49 cell with text "Sheet2 BR"

  Select 'Sheet3'

  Select A1 cell

  Populate A1 cell with text "Sheet3 TL"

  Select F49 cell

  Populate F49 cell with text "Shrrt3 BR"

  Select 'View -> Page Break Preview'

  ##### Expected result:

  text "Sheet3 TL" is on the top left cell of the page

  text "Sheet3 BR" is on the bottom right cell of the page

  Select 'Sheet2'

  ##### Expected result:

  text "Sheet2 TL" is on the top left cell of the page

  text "Sheet2 BR" is on the bottom right cell of the page

  Select 'Sheet1'

  ##### Expected result:

  text "Sheet1 TL" is on the top left cell of the page

  text "Sheet1 BR" is on the bottom right cell of the page

  Select 'View -> Normal'

  Click on clickable image 'Page Preview'

  ##### Expected result:

  Preview of 3 sheets is available.

  Placement of the text on this preview is corresponded to the placement shown in 'Page Break Preview'

  Click on clickable image 'Page Preview'

- Select by mouse area 'C11:E20'

  Select 'Format -> Print Ranges -> Define'

  ##### Expected result:

  lines defining printable cell range, they correspond to selected area.

  Select 'Format -> Print Ranges -> Edit...'

  ##### Expected result:

  Drop Down List 'Page range' is set to '- selection -' and has '$C$11:$E$20' value

  Click 'Cancel'

  SSelect 'Sheet2'

  Select 'Format -> Print Ranges -> Edit...'

  ##### Expected result:

  Nothing changed

  Click 'Cancel'

  Select 'Sheet3'

  Select 'Format -> Print Ranges -> Edit...'

  ##### Expected result:

  Nothing changed

  Click 'Cancel'

  Select 'Sheet1'

  Populate area 'C11:E20' with text "Sheet1"

  Populate cells B10, B15, B21, D10, D21, F10, F15, F21 with text "Out of selection"

  Click on clickable image 'Page Preview'

  ##### Expected result:

  only defined as printable area of 'Sheet1' is previewed (filled with "Sheet1" text)

  Click on clickable image 'Page Preview'

- Select 'Sheet2'

  Select 'Format -> Print Ranges -> Edit...'

  Select 'Print range -> - entire sheet -'

  Click 'OK'

  Select 'Sheet3'

  Select 'Format -> Print Ranges -> Edit...'

  Select 'Print range -> - entire sheet -'

  Click 'OK'

  Click on clickable image 'Page Preview'

  ##### Expected result:

  defined as printable area of 'Sheet1' is previewed (filled with "Sheet1" text)

  area of 'Sheet2' defined by page parameters (with text "Sheet2 TL" in the top left corner of the page and text "Sheet2 BR" in the bottom right corner of the page) is previewed

  area of 'Sheet3' defined by page parameters (with text "Sheet3 TL" in the top left corner of the page and text "Sheet3 BR" in the bottom right corner of the page) is previewed

  Click on clickable image 'Page Preview'

- Select 'File -> Save'

  Populate text field 'Save As:' with "i4063_Sheet Property 'Print Entire Sheet'_TCS_O"

  Click 'Save'

  Select 'File -> Close'

  Select 'File -> Open'

  Select "i4063_Sheet Property 'Print Entire Sheet'_TCS_O.ods"

  Click 'Open'

- Select 'Sheet1' Click on clickable image 'Page Preview'

  ##### Expected result:

  defined as printable area of 'Sheet1' is previewed (filled with "Sheet1" text)

  area of 'Sheet2' defined by page parameters (with text "Sheet2 TL" in the top left corner of the page and text "Sheet2 BR" in the bottom right corner of the page) is previewed

  area of 'Sheet3' defined by page parameters (with text "Sheet3 TL" in the top left corner of the page and text "Sheet3 BR" in the bottom right corner of the page) is previewed

  Select 'Format -> Print Ranges -> Edit...'

  ##### Expected result:

  Drop Down List 'Page range' is set to '- user defined -' and has '$C$11:$E$20' value

  Click 'Cancel'

- Select 'Sheet2'

  Select 'Format -> Print Ranges -> Edit...'

  Select 'Print range -> - none -'

  Click 'OK'

  Select 'Sheet3'

  Select 'Format -> Print Ranges -> Edit...'

  Select 'Print range -> - none -'

  Click 'OK'

  Click on clickable image 'Page Preview'

  ##### Expected result:

  only defined as printable area of 'Sheet1' is previewed (filled with "Sheet1" text).

  Click on clickable image 'Page Preview'

  Select 'File -> Close'

  Click 'Discard'

Verify compatibility with Microsoft Excel

- Select 'File -> Open'

  Select "i4063_Sheet Property 'Print Entire Sheet'_TCS.xls"

  Click 'Open'

- Select 'Sheet1'

  ##### Expected result:

  lines defining printable cell range appears, they correspond to 'C11:E20' area

  area 'C11:E20' is populated with text "Sheet1"

  cells B10, B15, B21, D10, D21, F10, F15, F21 are populated with text "Out of selection"

  cell A1 is populated with "Sheet1 TL", cell F49 is populated with "Sheet1 BR"

  Select 'Sheet2'

  ##### Expected result:

  cell A1 is populated with "Sheet2 TL"

  cell F49 is populated with ` "Sheet2 BR"

  Select 'Sheet3'

  ##### Expected result:

  cell A1 is populated with "Sheet3 TL"

  cell F49 is populated with "Sheet3 BR"

- Select 'Sheet1'

  Select 'Format -> Print Ranges -> Edit...'

  ##### Expected result:

  Drop Down List 'Page range' is set to 'Excel_Builtin_Print_Area_1' and has '$C$11:$E$20' value

  Click 'Cancel'

  Select 'Sheet2'

  Select 'Format -> Print Ranges -> Edit...'

  ##### Expected result:

  Drop Down List 'Page range' is set to '- entire sheet -'

  Click 'Cancel'

  Select 'Sheet3'

  Select 'Format -> Print Ranges -> Edit...'

  ##### Expected result:

  Drop Down List 'Page range' is set to '- entire sheet -'

  Click 'Cancel'

  Click on clickable image 'Page Preview'

  ##### Expected result:

  defined as printable area of 'Sheet1' is previewed (filled with "Sheet1" text)

  area of 'Sheet2' defined by page parameters (with text "Sheet2 TL" in the top left corner of the page and text "Sheet2 BR" in the bottom right corner of the page) is previewed

  area of 'Sheet3' defined by page parameters (with text "Sheet3 TL" in the top left corner of the page and text "Sheet3 BR" in the bottom right corner of the page) is previewed

  Click on clickable image 'Page Preview'

- Select 'Sheet2'

  Select 'Format -> Print Ranges -> Edit...'

  Select 'Print range -> - none -'

  Click 'OK'

  Select 'Sheet3'

  Select 'Format -> Print Ranges -> Edit...'

  Select 'Print range -> - none -'

  Click 'OK'

  Click on clickable image 'Page Preview'

  ##### Expected result:

  only defined as printable area of 'Sheet1' is previewed (filled with "Sheet1" text)

  Click on clickable image 'Page Preview'

  Select 'File -> Close'

  Click 'Discard'

### References (specification):

- http://specs.openoffice.org/