If a merged-cell block is selected and then added to Print Ranges, then the printed result truncates the content of the cell. It appears that the content is truncated to the portion which overlaps only the first cell of the merged set.
Steps to Reproduce:
Open attached demo, or do the following:
1. Create a new spreadsheet. Select A1 and B1, Format->Merge Cells->Merge & Center Cells.
2. Type "foo" into the merged cell.
3. Click the merged cell to select it (them).
4. Format->Print Ranges->Define (or Add)
5. File->Print, Print Preview, or Export as PDF
The result shows truncated text -- just 1½ letters ("f" followed by half of an "o").
Selecting merged cells and adding to Print Ranges should add both cells, and the content of the merged cells should print correctly.
User Profile Reset: No
Created attachment 145315 [details]
Behavior confirmed in
Build ID: 1:6.0.6-0ubuntu0.18.04.1
Threads CPU : 4; OS : Linux 4.15; UI Render : par défaut; VCL: x11;
Locale : nl-NL (fr_FR.UTF-8); Calc: group
(bug or feature, do we accept truncated merged cells when defining printing area ?)
this behaviour is inherited from OpenOffice.
opening attached *.ods file with excel 2016 has same result.
IMHO this is not a bug.
This is not a duplicate of this bug?