Re: [libreoffice-users] Referencing automatically cell data from a dynamic list of files

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
jslozier@gmail.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