Re: [libreoffice-users] Calc - Button clic saves and sends email

Hi :)
Please use "Reply to all" when replying to mails from this mailing
list.  That way everyone gets to see what is going on so far and might
be able to add the next bit to build up the complete answer or provide
a different approach.

Does anyone know how to make a button and give it the functionality
that exists within the menus?  Does anyone know how to take that
further and modify the button's functionality?


Is this something to do with macros?  If so then these guides might be
useful.  Ch12 of the "Getting Started" guide"
https://wiki.documentfoundation.org/Documentation/Publications
and Andrew Pitonyak's book
https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers

Regards from
Tom :)





On 2 March 2014 00:22, Jérémie Jacquand <jeremie.jacquand@gmail.com> wrote:
> Thank you for your answer.
> The filename changes dynamically according to the user and date and needs to
> be in a very specific format.
> The users of this spreadsheet are not going to follow these simple steps and
> need a one click button solution.
>
> Le 2 mars 2014 01:17, "Tom Davies" <tomcecf@gmail.com> a écrit :
> > Hi :)
> > There is a single button in the default tool-bar that converts to Pdf.
> >  it's beside the printer cons.  It doesn't put it straight into an
> > email though.
> >
> > Alternatively there is a menu option;
> > File - Send - As Pdf
> > but that is 3 clicks.
> >
> > Regards from
> > Tom :)
> >
> >
> >
> > On 1 March 2014 13:45, Jay <jeremie.jacquand@gmail.com> wrote:
> > > Hello !
> > >
> > > I have a calc document and wish to create a button which does the
> > > following:
> > >
> > > - Saves the spreadsheet in PDF in a predetermined path using a cell
> > > content
> > > as filename
> > > - Sends an email containing the PDF
> > >
> > > I don't care if the program uses python code, libroffice basic, java...
> > > as
> > > long as the code is inside the spreadsheet and that anyone who has the
> > > file
> > > can execute the button click without installing additional software
> > > except
> > > libreoffice.
> > >
> > > I don't have enough knowledge to program this :-/ hope you can help me
> > > on
> > > this.
> > >
> > > Thanks for your help :)
> > >
> > >
> > >
> > > --
> > > View this message in context:
> > > http://nabble.documentfoundation.org/Calc-Button-clic-saves-and-sends-email-tp4099645.html
> > > Sent from the Users mailing list archive at Nabble.com.
> > >
> > > --
> > > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > > Problems?
> > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > > List archive: http://listarchives.libreoffice.org/global/users/
> > > All messages sent to this list will be publicly archived and cannot be
> > > deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted