[libreoffice-users] Invoice automation using macros

2011-04-04 Thread Dag Wieers
Hi, I have quite simple LibreOffice invoices, one file per invoice. There are 2 items in each invoice I would like to make dynamic. 1. Invoice number 2. Due date For the invoice number, I created a user field InvoiceNumber and a macro UpdateInvoiceNumber, which automatically extracts the

Re: [libreoffice-users] Invoice automation using macros

2011-04-04 Thread Dag Wieers
On Mon, 4 Apr 2011, Dag Wieers wrote: But the problem is that, contrary to user fields, date fields cannot be referenced in Basic (likely because they do not have a name). Or at least I cannot find it anywhere. With some help from the OpenOffice forums I solved this by not using fixed date