Created attachment 6424 [details]
sample doc. attached

Hi Daniel, have a look at the margins. It seems that they are not
correctly set.

taking ownership

On further investigation, this document does not contain any explicit 
page breaks but instead the page breaks are automatically created 
from the print settings. In order to ensure compatability, the Excel 
option of 'Fit To' in the File -> Page Setup -> Page should be set 
and this is imported to Calc as "Fit to Pages". See also issue 11381 
and issue 14579. I will close this as invalid.

closed

re-opening this issue. One problem I overlooked is that the margins 
sizes are different in Calc and Excel. The reason is that there are 
no margins explicitly set. Thus Excel uses the following default 
values:
2.5cm top/bootom margins
1.9cm left/right margins 

while Calc defaults to 2.0cm for top/bottom/left/right. Where no 
margins have been set, Calc should default the xls file to the Excel 
default settings. This does not fix the page breaks. The workaround 
on 'Fit to pages' is still necessary. 

Created attachment 6682 [details]
proof of concept patch

started

checked in fix today into CWS calc16.

set to verified

closed verified

closed accidentially, so reopening

Frank

restoring status as fixed.

Frank

reopen to assign to QA

assign to QA

reset to fixed

Verified in internal build calc16

closed because fixed