Macro-Calc-Count Printing Pages of a sheet

Jonjozz · August 30, 2021, 2:07pm

I need a macro that shows (in a Long or Integer variable) the amount of pages on spreadsheet to be printed

JohnSUN · August 30, 2021, 2:32pm

Jonjozz · August 30, 2021, 3:33pm

Sorry. I saw the solution in a forum (It´s a simple three line code), but I missed it.
I use Basic. (ThisComponent.CurrentController.ActiveSheet for example)

Jonjozz · August 30, 2021, 4:18pm

Unbelievable…I found the solution. I found it, but I can´t find it again…The solution is lost in some dark deep place on internet.

Jonjozz · August 30, 2021, 4:27pm

It is like the “executeexcel4macro( get.document(50) )” macro command on Excel

sokol92 · August 30, 2021, 5:50pm

The solution is above (from @JohnSUN ).
Try (for first sheet):

i=ThisComponent.getRendererCount(ThisComponent.Sheets(0), Array())

Jonjozz · August 30, 2021, 6:07pm

It´s worked…You´re GREAT. Thanks, thanks, thanks. I don´t know you, but I loved you…Thank you SOOOOO MUCH.