Re: [libreoffice-users] How to grab web data into libre office calc ? Or Addons to grab specific web data into libre calc

Hi :)
I liked the questions you asked in the Smf mailing list.  It might be worth asking them what 
language it's written in or if it just uses Excel macros or internal  commands somehow.  
LibreOffice Calc has both of course.  

Also it'd be good to know if they have already licensed it or if they could consider making it 
OpenSource using a GPL or similar "copyleft" (a type of copyright) license.  Creative Commons 
explains it quite well for creative or artistic works or for documentation 
http://creativecommons.org/
but they might understand the full proper GPL more easily because it's made for software
http://www.gnu.org/licenses/gpl.html
There are variants such as the LGPL, MPL and others that have slightly different nuances but i 
think the GPL is the best and most famous.  

As OpenSource there are all sorts of opportunities for translating it between programs and maybe 
into different languages too, maybe getting a bit of a community together through their own site 
and/or the Extensions sites.  

Regards from 
Tom :)  





> ________________________________
> From: Tom Davies <tomdavies04@yahoo.co.uk>
> To: Supiramani Supiramani <hisupiramani@hotmail.com>; "users@global.libreoffice.org" 
> <users@global.libreoffice.org> 
> Sent: Friday, 19 April 2013, 21:58
> Subject: Re: [libreoffice-users] How to grab web data into libre office calc ? Or Addons to grab 
> specific web data into libre calc
>
>
>
> Hi :)
> You are asking in the right place and hopefully someone might have a good 
answer for you or be able to point to places that might have more 
detailed knowledge of what you are looking for.  Most of us started with Windows and many of us 
still use it a lot.  
> I tried a search for "smb" and then for "web" on our Extensions / Add-ons / Plug-ins site 
>
> http://extensions.libreoffice.org/extension-center?getCategories=&getCompatibility=any&sort_on=positive_ratings&path=%2FLibreOffice-Extensions-and-Templates%2Fextension-center&portal_type=PSCProject&SearchableText=web
> but didn't find much.  It might be better to search in OpenOffice's 
Extensions as many of them probably still work well or have maintainers 
that might be interested in updating it in order to make it work in 
LibreOffice.  Also the OpenOffice forums might be a good place to post 
questions but if you do and post here as well then it's polite to let 
both places know when you have found an answer and what the answer was.  
> Also most versions of Gnu&Linux (=distros) have their own forums and 
mailing lists so it might similarly be good to post questions there in a similar way.  Which distro 
do you use at the moment?  Ubuntu/Mint, 
Mageia, Fedora , openSUSE or which?  DistroWatch is a good place to 
look-up the official forum/mailing-list for your distro
> http://distrowatch.com
> for example to find the Ubuntu ones try here (it redirects)
>
> http://distrowatch.com/ubuntu
> for Fedora find some good links here
> http://distrowatch.com/fedora
>
>
> There is also a general-purpose forum at 
>
> http://www.linuxquestions/org
> that covers many, maybe all different distros but often you get answers from people using 
> completely different distros, possibly even from different families so you sometimes have to 
> figure out how to apply it to yours.  Most programs are either the same in each;  
> LibreOffice/OpenOffice, 
Firefox, Thunderbird and many others.  Sometimes they choose slightly 
different choices such as Chrome, Seamonkey, Opera instead of Firefox, similarly with utilities 
such as your  "package manager" so it doesn't take much to work out how to apply their advice and 
people at LinuxQuestions might even help with that.  
> Also there are other LibreOffice places such as AskLibO
>
> http://ask.libreoffice.org/en/questions/
>
> and other places you can find at 
>
> http://www.libreoffice.org/get-help/
> but i still prefer this mailing-list.  
>
>
>
> Good luck and regards from 
>
> Tom :)  
>
>
>
>
> > ________________________________
> > From: Supiramani Supiramani <hisupiramani@hotmail.com>
> > To: "users@global.libreoffice.org" <users@global.libreoffice.org> 
> > Sent: Friday, 19 April 2013, 20:12
> > Subject: RE: [libreoffice-users] How to grab web data into libre office calc ? Or Addons to grab 
> > specific web data into libre calc
> >
> >
> > please take a
 look at the image at 
> > http://finance.groups.yahoo.com/group/smf_addin/
> >
> > you will see it has 100s of data
> >
> > copy paste would take ages
> >
> >
> >
> > --------
> > regards
> >
> >
> > Date: Fri, 19 Apr 2013 13:02:08 -0500
> > Subject: Re: [libreoffice-users] How to grab web data into libre office calc ? Or Addons to grab 
> > specific web data into libre calc
> > From: laginnis@gmail.com
> > To: Hisupiramani@hotmail.com
> > CC: users@global.libreoffice.org
> >
> >        Could you highlight the area(s) you desire then copy then paste to wherever you wish the 
> > data?
> >          
   that's my system;
> >        [but I may not be understanding to what you're referring since I have no clue as what smf 
> > is  ;-)  ]
> >
> >
> >
> >
> > On Fri, Apr 19, 2013 at 12:16 PM, Happylibre wrote:
> >
> >
> > Hi
> >
> >
> >
> > Preamble ...skip if in a hurry
> >
> > --------------------------------------------
> >
> > *I've been on the m$ office treadmill for 15 + years
> >
> > *I've always been scared of Linux and thought it was all command line
> >
> > *Recently stumbled on Linux and libre office ...so I am  completely new to
> >
> > libre office
> >
> > *Used it for a few days ... Truly it's a great piece of software and
> >
> > dispelled most of my doubts on Linux, using Linux, libre office etc etc
> >
> >
> >
> > Question / request reading
> >
> > ------------------------------------------
> >
> > *However some specific doubts remain on libre office
> >
> > *I've been using M$ XL's add on for grabbing web data , called
 smf add in
> > *When activated, once could easily grab specific pages, specific cells of
> >
> > web pages directly into xl ( without opening a web browser)
> >
> > *This is a great time saver
> >
> > *The only and only /  excellent  group for using smf add in  can be found at
> >
> > http://finance.groups.yahoo.com/group/smf_addin/
> >
> > *Some  basic write up on using smf add in can be found here
> >
> > http://seekingalpha.com/instablog/326478-derek-a-barrett/1414481-automating-alpha-getting-started-with-stock-market-functions-smf-add-in-for-excel
> >
> >
> >
> >
> > Now, my question is , is there a similar add in for libre office, when
> >
> > invoked , could help the user  get
 specific cells ( not the whole web page )
> > from a URL  into libre xl sheets ? Of course the user supplies the URL
> >
> >
> >
> > Or is there some app in Linux that can do the same ?
> >
> >
> >
> > How do people grab specific web data ( not entire pages ) but specific data
> >
> > for web pages into libre calc ?
> >
> >
> >
> > Request to Moderators ; if I am posting on the wrong area or group please
> >
> > most this post accordingly
> >
> >
> >
> >
> >
> > Thanks in advance
> >
> > Regards
> >
> >
> >
> >                           
> > -- 
> > For unsubscribe instructions e-mail to: users+help@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
-- 
For unsubscribe instructions e-mail to: users+help@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