BasicMacro to print Calc cells at specific widths / page width

Hello All -

I found a great macro that prints a range of cells to PDF. By Arindam at DebugPoint. Thanks Arindam. I reached out to him as well.

However, there is no control to the width of page to be use (border widths on the page) or the width of each column in the 5 columns I am PDFing/printing.


If someone could please provide a link in how to access / affect that would be very helpful. Or perhaps provide some code pointers in how to affect that, such as what internal structures in 5 columns in Calc to address - would be very helpful.

I can do the above code link by selecting / printing a range and do not really need the macro for that but need to enhance the macro so as to be able to set page borders and width of each of the 5 columns.

Also I can DDE link it to Writer doc and adjust things there to print - which I have done also.

But would like to see if I could code it to print directly from the Calc via BasicMacro.

Thank you for your help / pointers.

Mono