Issue with merged cells touching the right side of the print area

[zhunter]

The first template, shows merged columns touching the right side of the print area. When this happens, the right border on the cell fails to render in the PDF.

Error Template
TEST TEMPLATE 1.XLSX
TEST TEMPLATE 1 - Results.pdf

As a quick fix, I added a small column inside the print area to put a buffer from the right side of the print area and the merged column. This fixes the issue and the border is able to print. Seems to be a rendering issue with merged cells touching the right side of the print area, as normal cells render correctly.

Workaround Template
TEST TEMPLATE 2.xlsx

Other observation, if you use repeating headers for each page (Page Layout => Print Titles => Rows to repeat at top) the repeated headers loose their cell borders and multi-line text render the carriage return as a square box.

Thanks again, great work!

[shps951023]

@zhunter could you please try new release version? I've fixed this issue.

[zhunter]

Outstanding, I can see the right cell border touching the print area has been fixed, the repeated headers are copying the cell borders as well. The only thing that was slightly different, was a shifting of text above the cell border.

Page 1 - Header (Yellow note line is within borders)

Page 2 - Header (Yellow note line has text floating above top border)

Here is Page 2, rendered with the default Excel Export to PDF feature.

I have just tried to make some changes to the template to see if I could make the issue go away and I've determined the cause is vertical align being set to "center" is causing the issue. This screenshot will show the condition that causes the text to overflow, if you change it to the default (top), it will print correctly and NOT overflow.

Again, cannot say it enough... great work!

[zhunter]

Here is another test sheet I put together to check alignment in different cell types, seems to be a few issues... With the current code, using vertical top

1. Vertical bottom with merged rows fail, but merged columns are ok.
2. Vertical center fails in all cell types (single, merged rows, merged columns)

Source Template
Merged Cell Alignment test Sheet.xlsx

Left (MiniPDF) and Right (Excel PDF Export)

[shps951023]

Here is another test sheet I put together to check alignment in different cell types, seems to be a few issues... With the current code, using vertical top

1. Vertical bottom with merged rows fail, but merged columns are ok.
2. Vertical center fails in all cell types (single, merged rows, merged columns)

Source Template Merged Cell Alignment test Sheet.xlsx

Left (MiniPDF) and Right (Excel PDF Export)

Next version :

MiniPDF	Office

[shps951023]

Outstanding, I can see the right cell border touching the print area has been fixed, the repeated headers are copying the cell borders as well. The only thing that was slightly different, was a shifting of text above the cell border.

Page 1 - Header (Yellow note line is within borders)

Page 2 - Header (Yellow note line has text floating above top border)

Here is Page 2, rendered with the default Excel Export to PDF feature.

I have just tried to make some changes to the template to see if I could make the issue go away and I've determined the cause is vertical align being set to "center" is causing the issue. This screenshot will show the condition that causes the text to overflow, if you change it to the default (top), it will print correctly and NOT overflow.

Again, cannot say it enough... great work!

MiniPDF

Office