Re: [libreoffice-users] Re: Libreoffice 5.2 not starting

2017-03-09 Thread Fiorenza Meini
Il 09/03/2017 16:10, Alexander Thurgood ha scritto: Le 09/03/2017 à 10:44, Fiorenza Meini a écrit : What is the output on the terminal if you try and launch LibreOffice for one of the troubled users from a terminal session when that user is logged in ? Alex Hi, it tells that libreoffice is

Re: [libreoffice-users] Re: sorting in calc

2017-03-09 Thread Brian Barker
At 18:59 08/03/2017 +, Gary Collins wrote: Is there a character i can enter into a cell that will come *before* numbers in the sort order? I mean, before other cells that actually contain numbers rather than numerical strings What about some value less than any of your real data are (or

Re: [libreoffice-users] vlookup case

2017-03-09 Thread Brian Barker
At 11:50 09/03/2017 +, Gary Collins wrote: Is it possible to make the search performed by vlookup to be case sensitive? Apparently not! I need to be able to distinguish between eg 'd' and 'D' but at the moment i cant work out how to do it (if it's possible) Suppose your array has the

[libreoffice-users] Re: Libreoffice 5.2 not starting

2017-03-09 Thread Alexander Thurgood
Le 09/03/2017 à 10:44, Fiorenza Meini a écrit : What is the output on the terminal if you try and launch LibreOffice for one of the troubled users from a terminal session when that user is logged in ? Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] vlookup case

2017-03-09 Thread Gary Collins
Hello, Is it possible to make the search performed by vlookup to be case sensitive? I need to be able to distinguish between eg 'd' and 'D' but at the moment i cant work out how to do it (if its possible) Thanks Gary -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

[libreoffice-users] named data ranges

2017-03-09 Thread Gary Collins
Hello again I appear to be experiencing a problem with named data ranges lo 5.2.2.2 x64 win 7. Q. Is it possible and permissible to define overlapping data ranges? I want a range named mdec which will be A1:B25 and another xlit B1:C25 (the col B values are common) to use in lookups. I have

Re: [libreoffice-users] sorting in calc

2017-03-09 Thread Gary Collins
Hello all, Ive managed to solve my problem in a roundabout way. To give the context, i have a column containing strings of length 1 to 3 which may contain nonstandard characters and which i must sort in a specific order (not the usual alphabetic order). To achieve this i have a table assigning

Re: [libreoffice-users] Libreoffice 5.2 not starting

2017-03-09 Thread Fiorenza Meini
Il 09/03/2017 10:06, leleu ha scritto: There should be some difference between the ~/.config/libreoffice/4 repertories of each user, shouldn't ? I tried to remove the .config/libreoffice directory and execute libreoffice again... the .config/libreoffice was created, but the program doesn't

Re: [libreoffice-users] sorting in calc

2017-03-09 Thread Gary Collins
Hello Dries Thank you for your reply. Yes i am aware of the ascii code but it doesnt seem to apply when some cells contain numbers rather than text. For example # comes before "1" in the table but it sorts after numbers. I want something i can put in a cell which will sort before any number. I

Re: [libreoffice-users] Libreoffice 5.2 not starting

2017-03-09 Thread leleu
There should be some difference between the ~/.config/libreoffice/4 repertories of each user, shouldn't ? Je la 09/03/2017 09:43, Fiorenza Meini skribis : Hi there, I installed Libreoffice 5.2 on a linux distribution (Edubuntu 14.04), where there are configured multiple users. For two of

[libreoffice-users] Libreoffice 5.2 not starting

2017-03-09 Thread Fiorenza Meini
Hi there, I installed Libreoffice 5.2 on a linux distribution (Edubuntu 14.04), where there are configured multiple users. For two of them, when Libreoffice is executed, the system advises that Libreoffice is not installed... Where could be the problem ? Libreoffice is installed and working

Re: [libreoffice-users] sorting in calc

2017-03-09 Thread Dries Feys
Gary, You could check http://www.asciitable.com/ to see the order. Met vriendelijke groeten, Salutations distinguées, Kind Regards, DRIES FEYS CORPORATE SERVICES • Specialist Software Developer TVH GROUP NV Brabantstraat 15 • BE-8790 WAREGEM T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com

[libreoffice-users] Re: sorting in calc

2017-03-09 Thread Pedro
Gary Collins wrote > Hello, > Is there a character i can enter into a cell that will come *before* > numbers in the sort order? > I mean, before other cells that actually contain numbers rather than > numerical strings Any character that shows up before zero in Character Map (if you are using