Re: [libreoffice-users] Macro's in Libre Calc

2014-06-10 Thread Tom Davies
Hi :) Ahh, i hadn't tried this either and this makes much more sense to me. So it looks like there are many ways of dodging the need for a macro and that helps keep the document flexible for the future. Regards from Tom :) On 10 June 2014 06:08, Andrew Douglas Pitonyak wrote: > > Be certain

Re: [libreoffice-users] Macro's in Libre Calc

2014-06-09 Thread Andrew Douglas Pitonyak
Be certain to only do what you really need to do using a macro, and then let things such as formulas do the rest of the work. It sounds like you want to have a Calc document with 366 sheets (so that it will work with leap years) with the same sheet on each page. Well, the sheet is the same e

Re: [libreoffice-users] Macro's in Libre Calc

2014-06-09 Thread Tom Davies
Hi :) It sounds more like a database would do the trick. https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook Regards from Tom :) On 9 June 2014 23:24, Philip Ward wrote: > Hi Tom/all > > sorry for delay in getting back, and cheers for the info, ill take a

Re: [libreoffice-users] Macro's in Libre Calc

2014-06-09 Thread Philip Ward
Hi Tom/all sorry for delay in getting back, and cheers for the info, ill take a look tomoz night and the link, that much on the go at the moment... basically what im after is... A cleaning/HSE Check sheet, that gets printed out, and the staff fill it out, ie tick the boxes, say whats gone of in

Re: [libreoffice-users] Macro's in Libre Calc

2014-06-08 Thread Tom Davies
Hi :) Andrew Pitonyak's guide is pretty good and might be helpful https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers Really it is best to just ask the question here and let this team build-up the best answer by trying out different things. Good luck and

[libreoffice-users] Macro's in Libre Calc

2014-06-08 Thread Philip Ward
Hi Guys, Who is the best person to speak to about macro's in calc? cheers Phil -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Neti