Re: [libreoffice-users] Identifying the correct row in Spreadsheet formulas

Hi :)
The signatures advice sounds mad to me.  You are right it does need changing but i doubt we could 
agree on something sensible.  The list is available to the general public around the world so 
posting phone numbers is very much NOT a good idea and definitely not a home address!  Personally i 
am usually wary about even letting people know which country i am in!  

On a different mailing list (nothing to do with LibreOffice) one girl wrote in that she was 16 and 
lived such and such place and would happily meet up with anyone on that list!  Someone did get in 
touch, but with her parents (not the girl) to warn them of the dangers and to let them know what 
their daughter had been doing online!  

I think the note must be for people thinking about taking a key position in TDF and 'must surely' 
be referring to non-private phone numbers and not the persons home address.  
Regards from
Tom :)

--- On Sat, 10/12/11, MiguelAngel <mariosv@miguelangel.mobi> wrote:

From: MiguelAngel <mariosv@miguelangel.mobi>
Subject: Re: [libreoffice-users] Identifying the correct row in  Spreadsheet formulas
To: users@global.libreoffice.org
Date: Saturday, 10 December, 2011, 16:11

El 10/12/11 10:28, Ian Whitfield escribió:
> Thanks to Brian and the others who have now "put me right" and shown me
> the right way to start a new Thread!!!
>
> Regarding the 'Signature' I was going along with what I found in the
> 'TDF/LibreOffice Mailing List Netiquette'...
>
>
> /"Signature/
>
> /Always 'sign' your message with your name and your preferred e-mail
> address. This is especially important because some e-mail and newsreader
> software do not always convey the originator's full e-mail address.
> While you may certainly include your regular mail address in your
> postings, you may wish to give this out only in personal replies, when
> necessary. /
>
> /Use a short signature, including only the essential information. Four
> lines are usually enough to include name, email, telephone number and
> other nicknames, and - if necessary - corporate affiliation. Please
> avoid lengthy legal disclaimers, which are useless in principle and even
> more useless - and disturbing - when posting to a mailing list."
>
> /
>
> If this is in fact wrong I would suggest that it be changed on the
> WebSite!!
>
> So - OK - I will go back to just signing my name and occasionally adding
> my City!!
>
> Thanks all - On the main question I'm still looking for a positive
> answer. So far VLOOKUP is NOT what I want am about to look at HLOOKUP
> and MATCH.
>
> Just thinking........ I wonder if "=A+'Z4' " would work to give me 'A12"
> if I put the value 12 into Z4. Will try.......
>
> NO - That doesn't work!! I tried various combinations.
> The one I thought would work was 'A+(VALUE(Z4))' but no luck.
> Is my syntax out??
>
> Ian Whitfield
> Pretoria./
> /

Maybe

=INDIRECT("A"&VALUE(Z4))

Miguel Ángel.

  * Español - detectado
  * Inglés
  * Español

  * Inglés
  * Español

  <javascript:void(0);> <#>

-- 
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