Printing a range of selected cells with macro

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
mijo
Posts: 1
Joined: Fri Jun 28, 2019 2:39 am

Printing a range of selected cells with macro

Post by mijo »

hi
i want to print a range of selected cells using marco. i used record macro but when the recorded macro runs, it displays print dialog and i have to click "ok" button to continue printing. what i need is printing a range of selected cells only, directly without print dialog appears. can anyone help me with a simple macro example or a link which i can learn.
i am very very new in programming.
thanks for all helps

regards
open office 4 on win7
User avatar
robleyd
Moderator
Posts: 5056
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: printing a range of selected cells with macro

Post by robleyd »

A search of the forum returns a number of topics that may be helpful to you.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: printing a range of selected cells with macro

Post by Zizi64 »

i used record macro
You must wrirte your macros, but not record them. The recorder has a limited capability: In most of cases you need use the API functions (and sometimes the Dispatcher too) in your macros.
API: Application Programming Interface
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Post Reply