[libreoffice-users] calc give a value a name?

2016-04-21 Thread Beau Thompson
Hi All, I have a project in calc that uses 2 sheets 1 data 2 ladder here is what one entry looks like on data A5 1. B5 J Beckman C5 3.916 here is a enrty for the latter sheet where it is displayed =CONCATENATE(data.A5, " ", data.B5," ",data.C5) here is my question in place of A B and C can

[libreoffice-users] installing 5.1.2 error 1303

2016-04-12 Thread Beau Thompson
Hi All i am have trouble installing 5.1.2 I am on win 10 get a error 1303 C:\Program Files (x86)\LibreOffice 5\program it say installer does not have admin i have tried all i known and no luck Thanks Beau -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] how do i Link to External Data?

2016-03-11 Thread Beau Thompson
will a url like http://nhra.com/events/2016race02.aspx not work as ok is grayed out On 3/11/2016 11:44 AM, Alan B wrote: On Fri, Mar 11, 2016 at 12:07 PM, Beau Thompson <n9m...@gmail.com> wrote: Hi All, I like to use calc to pull data from a web page using Link to External Data all

Re: [libreoffice-users] how do i Link to External Data?

2016-03-11 Thread Beau Thompson
here What i See https://www.dropbox.com/s/csfqzwp2zyvwoaj/screenshotmenu.png?dl=0 On 3/11/2016 11:44 AM, Alan B wrote: On Fri, Mar 11, 2016 at 12:07 PM, Beau Thompson <n9m...@gmail.com> wrote: Hi All, I like to use calc to pull data from a web page using Link to External Data all

[libreoffice-users] how do i Link to External Data?

2016-03-11 Thread Beau Thompson
Hi All, I like to use calc to pull data from a web page using Link to External Data all videos are old thanks for any help -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines +

[libreoffice-users] how to do a if in calc?

2016-03-10 Thread Beau Thompson
Hi All, I have a question about a drop don box and a if k2 an k3 have names in it k2 Beau k3 john m2 is drop down $data.$K$2:$K$3 I like to do a if in o2 that would be what ever name is not selected in m2 thanks Beau -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

[libreoffice-users] drop down box set value ?

2016-03-08 Thread Beau Thompson
Hi I have a dropdownbox using a cell range $data.$E$2:$E$3 how can i set a default value or can i put the same data in a list thanks Beau -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/

[libreoffice-users] calc filter?

2016-02-29 Thread Beau Thompson
HI all, im working on a calc sheet where i have a list of 16 names 1 to 16 B2 TO B17 I lie to filter the list in this order 1 16 8 9 4 13 5 12 2 15 7 10 3 14 6 11 thanks beau -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] how to put only two options in a dropdown

2016-02-28 Thread Beau Thompson
Hi, I have a project that needs a dropdown box on the data sheet E1 I like the data from B1 and B16 with this i get all $data.$B$1:$B$16 Thanks Beau -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?