[libreoffice-users] Selection list

2016-01-28 Thread RB 

Hi!

How to edit selection list in the LibreOffice Calc cell
which contains previously entered values by the right mouse button.


Mic


--
To unsubscribe e-mail to: users+unsubscr...@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

[libreoffice-users] Selection list

2016-01-28 Thread RB 

Hi!

How to edit selection list in the LibreOffice Calc cell
which contains previously entered values by the right mouse button.


Mic

--
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] Selection list

2016-01-28 Thread Gabriele Ponzo 
What's the question?

---
Gabriele Ponzo

2016-01-28 10:23 GMT+01:00 RB :

> Hi!
>
> How to edit selection list in the LibreOffice Calc cell
> which contains previously entered values by the right mouse button.
>
>
> Mic
>
> --
> To unsubscribe e-mail to: users+unsubscr...@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
>

-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] Selection list

2016-01-28 Thread Brian Barker 

At 12:23 28/01/2016 +0300, Mic Noname wrote:
How to edit selection list in the LibreOffice Calc cell which 
contains previously entered values by the right mouse button.


o Go to Data | Validity | Criteria.
o If Allow is set to List, edit the values in the Entries box.
o If Allow is set to "Cell range", observe the range specified at 
Source. Either change the range or visit it and modify the values there.
o If Allow is set to "All values", the selection list is being 
automatically populated from the current column and cannot be 
changed, I think - except by removing values from elsewhere in the column.


I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@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

[libreoffice-users] Selection List editing

2013-01-16 Thread JeepNut 
Have looked for an hour online and in the help texts trying to figure 
out how to edit what I see in the Selection List when I right click on a 
cell in Calc and get the pulldown list.
I've been through the data validity drill but see nothing in the list 
there.
And I've gone through the autocorrect options with no help.  I don't see 
any of the text that is in my selection list displayed in the 
Autocorrect options at all.
I found the files in the users .config directory but they don't appear 
to be editable via text tools.


LibreOffice 3.5:build-413  on openSuSE 12.2 in KDE 4.8.5

Thanks to those who know for your help!

--
None are more hopelessly enslaved than those who falsely believe they are 
free.
~Johann Wolfgang von Goethe
---
Registered Linux user #287453



--
For unsubscribe instructions e-mail to: users+h...@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

Re: [libreoffice-users] Selection List editing

2013-01-16 Thread Brian Barker 

At 10:07 16/01/2013 -0500, Nobody Noname wrote:
Have looked for an hour online and in the help texts trying to 
figure out how to edit what I see in the Selection List when I right 
click on a cell in Calc and get the pulldown list.

I've been through the data validity drill but see nothing in the list there.
And I've gone through the autocorrect options with no help.  I don't 
see any of the text that is in my selection list displayed in the 
Autocorrect options at all.
I found the files in the users .config directory but they don't 
appear to be editable via text tools.


I hesitate to suggest this, but I believe you may be conflating two 
different facilities here.


o If you right-click a cell and choose Selection List..., the list 
you are presented with is simply the collection of different entries 
already present in the same column.  There is no way of editing this 
list, I think, except by adding values to or removing existing values 
from elsewhere in the same column - which you would probably not want 
to do.  This facility is presumably intended to obviate repetitive 
typing, not to control the contents of cells.


o To control the values in the list, select the required range of 
cells (quite possibly a column) and go to Data | Validity... | 
Criteria.  Against Allow, select an appropriate choice from the 
drop-down menu - probably List.  Ensure Show selection list is 
ticked and type your required entries, one per line, in the Entries 
box.  (The other tabs provide facilities for restricting possible 
entries as well as setting an error message.)  Now you will see your 
desired entries if you either use right-click | Selection List... or 
click the down arrow next to the current cell.


I trust this helps.

Brian Barker



--
For unsubscribe instructions e-mail to: users+h...@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