[libreoffice-users] Re: converting txt to dates

Am 25.03.2015 um 01:28 schrieb Kaj: > Am 2015-03-24 18:22, Andreas Säger schrieb: >> Am 24.03.2015 um 14:22 schrieb Kaj: >>> Hi ! >>> >>> Now you happened to use the wrong conversion function, VALUE instead of >>> DATEVALUE, so of course it did not work. But even with the correct >>> function there

Re: [libreoffice-users] Re: converting txt to dates

Am 2015-03-24 18:22, Andreas Säger schrieb: Am 24.03.2015 um 14:22 schrieb Kaj: Hi ! Now you happened to use the wrong conversion function, VALUE instead of DATEVALUE, so of course it did not work. But even with the correct function there seems to be some issues. According to the help text for

[libreoffice-users] Re: Calc, selecting from a list ? vlookup maybe ?

thanks Rob you obviously worked out the upload file routine - IGraham W764 LibreOffice 4.4.1.2 -- View this message in context: http://nabble.documentfoundation.org/Calc-selecting-from-a-list-vlookup-maybe-tp4144307p4144388.html Sent from the Users mailing list archive at Nabble.com. -

[libreoffice-users] Re: Calc, selecting from a list ? vlookup maybe ?

Hi & thanks for the replys Brian & Pedro yes both good and i'd looked at them, both are quite workable I wanted something that could be shared (dropbox) and worked on by people that have little knowledge of spreadsheets But i also wanted to know 'how to do it' the difficult way Rob You gave me t

[libreoffice-users] Re: Calc, selecting from a list ? vlookup maybe ?

OK, here is the file. test1-rj.ods Found one thing- The array defined in the vlookup should be one more then the last data row. Otherwise the last nae doesn't show. Didn't figure out why Amyway, hope this gives you someting

[libreoffice-users] Re: Calc, selecting from a list ? vlookup maybe ?

IGraham wrote > I want new lists based on the membership type > > Anyone know how i can do this You can simply add a column title to each column (e.g. on B13 Type and C13 Name) Click on B13 and then on menu Data, Filter, AutoFilter Click on the down arrow that shows up to the right of Type, u

Re: [libreoffice-users] Calc, selecting from a list ? vlookup maybe ?

Hi Graham, I experimented a little and found the following solution for you: In added 2 columns before the one with the heading C/M. In col G I put the following formula: =IFNA(VLOOKUP($G$13,INDIRECT("B"&(14+E13)&":C$40"), 2, 0),"") In col E I put: =MATCH(G14,INDIRECT("$C"&14+E13):$C$39,0)+E13

[libreoffice-users] Re: converting txt to dates

Am 24.03.2015 um 20:09 schrieb V Stuart Foote: > Andreas Säger wrote >> All this conversion from strings to numbers is unrelated to the date >> acceptance patterns that determines how Calc turns your keyboard input >> into day numbers. > > No, it is not just for keyboard entry! And, it is certain

[libreoffice-users] Re: converting txt to dates

Andreas Säger wrote > All this conversion from strings to numbers is unrelated to the date > acceptance patterns that determines how Calc turns your keyboard input > into day numbers. No, it is not just for keyboard entry! And, it is certainly applicable for format conversion of non-local date fo

Re: [libreoffice-users] Calc, selecting from a list ? vlookup maybe ?

At 07:37 24/03/2015 -0700, Graham Lovatt wrote: If i have a list over a number of columns how would i create a new list of only certain rows from that list If you want to do this dynamically, so that the sub-list updates automatically from the main list (as is suggested by your mentioning the

[libreoffice-users] Re: converting txt to dates

Am 20.03.2015 um 02:28 schrieb James: > Column A has text strings that are DD/MM/ format. > I want to make them real dates. > I tried these 2 datevalue formulas but I can't make it work. > > 14/03/2015Err:502 > 14/03/2015Err:502 > > > =DATEVALUE(TEXT(A1,"##/##/")) > =DATEVALUE(A2

[libreoffice-users] Re: converting txt to dates

Am 24.03.2015 um 14:22 schrieb Kaj: > Hi ! > > Now you happened to use the wrong conversion function, VALUE instead of > DATEVALUE, so of course it did not work. But even with the correct > function there seems to be some issues. According to the help text for > the date acceptance pattern: beside

Re: [libreoffice-users] Re: New 'tab' system in Calc

Hi :) Ahh, thanks :)) It's going to take me a while as i'm "rushed off my feet" right now. Maybe this evening? Err several hours time. Regards from Tom :) On 24 March 2015 at 15:39, Pedro wrote: > Hi Tom > > Long time no see :) > > > TomD wrote > > Those are really good links. It might be g

[libreoffice-users] Re: New 'tab' system in Calc

Hi Tom Long time no see :) TomD wrote > Those are really good links. It might be good to have those on a > wiki-page > so that other people can add others. Errr, if someone is willing to do > the > contents inside such a wiki-page i'd be happy to create one. I dunno how > to do the templates

[libreoffice-users] Calc, selecting from a list ? vlookup maybe ?

If i have a list over a number of columns how would i create a new list of only certain rows from that list Yes i know thats as clear as mud so i've attached a example spreadsheet The column starting at B14 has membership type with (C14) a name next to it - the actual sheet has more data. Each row

Re: [libreoffice-users] Re: New 'tab' system in Calc

Hi :) Those are really good links. It might be good to have those on a wiki-page so that other people can add others. Errr, if someone is willing to do the contents inside such a wiki-page i'd be happy to create one. I dunno how to do the templates but i can get the menus set-up. Regards from To

Re: [libreoffice-users] Re: converting txt to dates

Hi ! Now you happened to use the wrong conversion function, VALUE instead of DATEVALUE, so of course it did not work. But even with the correct function there seems to be some issues. According to the help text for the date acceptance pattern: besides local ways to write date, also the ISO st

[libreoffice-users] Re: Font versus Character Substitution

If it's really not possible to mix languages in the same paragraph, then it's strange that Character Styles have the option to select font languages for Asian and CTL. Sorry if this have no sense, I have never used Asian or CTL languages. Miguel Ángel -- View this message in context: http:/