To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=47600





------- Additional comments from [email protected] Thu Sep 24 16:21:41 
+0000 2009 -------
** Context **
a workbook with 3 sheets, and data in those sheets.

Action =|=> result
1- menu> View > Page Break Preview =|=> see that on all sheets a default Print
range is set.
2- for all sheets: menu> Format > Print Range > Edit =|=> Print Range set to 
'none'
3- menu> File > Print, Print option set to 'All sheets' =|=> all sheets are
printed with the default print range
4- on sheet 'Sheet1': select a range of cells, menu> Format > Print Range > Add
=|=> a print range is added to the 'Sheet1' + default print range on 'Sheet2'
and 'Sheet3' are deleted
5- menu> File > Print, Print option set to 'All sheets' =|=> only the cells of
the Print Range in 'Sheet1' are printed

step 1, 2 and 3 are correct.
step 4: 'add' or 'set' a print range on one sheet, delete the default print
range of other sheet. This behavior is burden for the users, who expects to have
the Excel behavior (ie. keep default print range)
step 5: the user expects Calc to print the defined range of cells + all sheets,
which the user doesn't specify a print range, in 'entire sheet' mode.


** Test files **
- test_47600_before.ods -> the workbook before step 4
- test_47600_before.pdf -> pdf export, which show the print resutl of the
workbook before step 4
- test_47600_after.ods -> the workbook after step 4
- test_47600_after.pdf -> pdf export, which show the print resutl of workbook
after step 4
- test_47600_after_expected.pdf -> pdf export, which show the *expected* print
result of workbook after step 4


** Patch **
file: document.cxx.patch
full path: sc/source/core/data/document.cxx
OOo version : OOO310m11 (Build:9399)
modified methods: ScDocument::AddPrintRange, ScDocument::SetPrintRange,
ScDocument::SetPrintEntireSheet
UI modification: NO
tested on Linux: YES
tested on Windows: YES, Windows 2000 and Windows XP SP3

** Description of the patch **
IF the user (( add a Print OR set a Print Range OR set 'entire sheet' print
range option on a sheet )) AND (( that the document has no print range at all ))
AND (( no print properties on sheets )) THEN force the 'entire sheet' print
property on all other sheet.

---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to