Attempted to get round lack of protection of spreadsheets by printing as pdf
The attached shows a snip of the spreadsheet as viewed in the delphi program that generated it, and a snip of the print preview.
The text is corrupt.
All of the corruption is on merged sections with centered text - the text is printed in the nominal position (ie the first cell in the merge) and also in the intended position. it also lost the embedded image
I have also attached the fill pdf and the spreadsheet saved as an xlsx file
I have marked this as private because of the detail in the attachments, I have no objection if you want to remove the attachments and then make if public.
dr john
Hello John,
This functionality is not supported. The current version of the SpreadSheet report link cannot print graphic. However, I have converted this ticket to a suggestion for implementing this functionality in a future version of our controls.
As for printing merged cells, I've created a separate thread and forwarding it to our developers for further research - T127900: Printing merged cells of tdxspreadsheet.
seems a bit pointless introducing the ability to include images if you then have to open it in Excel to print it.
I assume as an interim I can put the image (and preferably the heading text) into a panel/alternate component and use printlayouts to print it at the top of a page with the spreadsheet below.