accepted

fixed in src680/dr19

Additional comments on differences between Calc and Excel:

If header is switched off:

Behaviour of Calc and Excel is equal: "Top border" describes distance from sheet 
data to top border of paper.

If header is switched on:

- "Top border" in Calc is distance between top border of paper and top of header.
- "Top border" in Excel still is distance between top border of paper and *sheet 
data*. Header is inside this distance (and may overlay the sheet data if too big).

- "Header margin" in Calc is distance between bottom of header and top of sheet 
data. Therefore: Position of sheet data is "Top border" + header height + "Header 
margin".
- "Header margin" in Excel is distance between top border of paper and header. It is 
completely unrelated to sheet data position.

In Calc, the header margin must be >=0. This implies that in Calc it is not possible 
to let the header overlay the sheet data (see issue 30586).

Import/export filter now converts the Calc and Excel margins as good as possible.
On import, if header overlays sheet data, an explicit header height is set, that cuts 
the lower part of the header. This way the position of the sheet data is imported 
correctly. Otherwise the header height is calculated dynamically (the setting 
"Dynamic header height" is switched on).
On export, if the "Dynamic header height" setting is switched on, the current size 
of the header is calculated and used. If switched off, the explicit height is used. 
This would return to Excel's behaviour to overlay the sheet data with the header.

All above applies to footers too, related to bottom border of paper.

reopened

Created attachment 16289 [details]
the test doc for import and export

another problem: picture not visible after import -> issue 30613

back to QA

fixed

verified in interal build cws_dr19

Found integrated in master src680m54 using Linux and Windows build

*** Issue 76209 has been marked as a duplicate of this issue. ***