On Thu, 2013-11-14 at 11:29 +0100, Javier Garcia wrote: > Hi, > > I have a a list of invoices created with LibreOffice Calc inside a > folder. Now I would like to retrieve the data inside of those invoices > to create another spreadsheet called "All" that contains a row for each > invoice. > > | > Name Phone Street > John 677 Main > Mary 897 Niceday > | > > Is there any way to do that automatically? > > One more: imagine, I add a new invoice file, I would like that after > addding it, the Name, Phone and Street inside it, were added > automatically to the "All" file. > > Is possible? Should I create an script? What language shoould I use > (LibreOffice Basic, Javascript, Python..)? I would like to use > Javascript if possible. > > Im on Ubuntu, but the script should work in the computer of my customer > (Windows 8 ), where I also installed LibreOffice. > > Javier > > Javier
If you define ranges in ranges in the original files you could use INSERT>>LINK TO EXTERNAL DATA. I have not do this in a long time so I am fuzzy on the details. You can write a script/macro to do this. LO supports LO Basic, Python, and Javascript for scripts/macros. -- Jay Lozier [email protected] -- To unsubscribe e-mail to: [email protected] 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
