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

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 <skeggy78@gmail.com> wrote:

> 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 that day etc.
>
> i have laid out a sheet, over 2 pages, and the only thing that i want to
> basically do is print out 365 (or obviously a leap year 366) page document,
> and automatically add a new date to the printed sheet for that.
>
> i didnt want to copy and paste the same thing 365 times, for 4 or 5 times,
> as there are different parts of the business, ie Cafe/Bar/Icecream kiosk
> etc, which all need their individual style/setup.
>
> i was looking for a quick way to copy the sheet, add a new sheet, paste
> it, then do the same thing over and over again. On the second sheet i know
> i can make a date = Previous sheet/Cell and +1 to it, and this would be the
> one thats copied all the rest of the year, but thats about where my
> knowledge on libre finishes (having brought most of what i knew from
> excel), but have never done any macro's of this sorts before, well part
> from gimp to re-size/touch up pictures, and even then found that i could
> have done it quicker manually!
>
> i just would prefer not to copy and paste something a potential 1825
> times!! my control and V key probably woudlnt like me very much
>
> Cheers
> Phil
>
>
> On 8 June 2014 22:00, Tom Davies <tomcecf@gmail.com> wrote:
>
> > 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 regards fro m
> > Tom :)
> >
> >
> >
> >
> > On 8 June 2014 19:23, Philip Ward <skeggy78@gmail.com> wrote:
> >
> > >  Hi Guys,
> > >
> > > Who is the best person to speak to about macro's in calc?
> > >
> > > cheers
> > > Phil
> > >
> > > --
> > > 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