Re: [libreoffice-users] Multiple selection in a validity range (Calc)

Hi :)
We can't see inside the zip file unless we register at the Excel forum.  You 
could have a text cell list various chosen cells such as
'=A1, B3, A2, C6, A4, B1
as randomly or ordered as you like.

You can also have nested IF statements so that if A1=3 it would go on to check 
to see if B3=4 or whatever.  But i think you are asking something slightly 
different?
Regards from
Tom :)




________________________________
From: alesarrett <alessandro.sarretta@inwind.it>
To: users@libreoffice.org
Sent: Tue, 31 May, 2011 8:06:02
Subject: [libreoffice-users] Multiple selection in a validity range (Calc)

Dear users,
I'd like to have a validation cell accepting multiple items from a cell
range, to have as a result, a list of item separated by a comma.
Having as cell range
1
2
3
4

I'd like to be able to select from the validation cell, e.g. 2 and 3 and to
have as a result
2,3

Is there a way to do this?
Are there plans to include multiple selection in the validity tool?
Are there any macro around that I could use to start from?
Trying to find inspiration, I found this similar example in excel:
http://www.excelforum.com/excel-general/646619-select-multiple-criteria-via-data-validation.html

Is it easy to reproduce and customize in calc?
Thank you for any hint.
Ale

--
View this message in context: 
http://nabble.documentfoundation.org/Multiple-selection-in-a-validity-range-Calc-tp3004869p3004869.html

Sent from the Users mailing list archive at Nabble.com.

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted
-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted