Re: [libreoffice-users] Re: Libreoffice 5.2 not starting
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 non installed. No error is given. Regards Fiorenza -- 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] Re: sorting in calc
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 can be)? What is the range of your numerical values? In practice, this is unlikely to span the entire range that Calc can handle. If your values are all positive and non-zero, for example, then zero will do. Otherwise a sentinel value such as -999 might suffice. If you don't want this number to appear in your list, you can hide it using Conditional Formatting with a cell style having its font colour set to white (or whatever is your cell background colour). Alternatively, you can set the cell format of your range itself to something like [WHITE][<=0]0;0 . But the number would still be there, of course, so you'd have to take care if you did any calculations on the range such as AVERAGE(). At 09:12 09/03/2017 +, Gary Collins wrote: Maybe it might work if i can convert all the relevant numbers i have entered to text but im still looking for a way to do that. Format>cells>numbers and selecting text doesn't do it, ... No: changing format of cells already containing values never changes the stored values themselves. But there are two alternative easy ways to do this: o In another column, enter =TEXT(Xn;"0") (or whatever is a suitable format string). o Fill down the column. o Select the new values and cut. o Paste them over the originals, but using Edit | Paste Special... (or Ctrl+Shift+V), selecting Numbers but not Formulae in the Paste Special dialogue. o Select the range of values. o Go to Data | Text to Columns... . o In the Text to Columns dialogue, under Fields, click on the column header (probably currently Standard). o In the "Column type" drop-down, select Text. o OK. Voilà! At 10:15 09/03/2017 +, Gary Collins wrote: 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 a number (col B) to each char (col A) in sheet 2, defined as a range 'xlit'. So this table must indeed have a small, finite range of values (presumably integers) in column B. Surely your lookup formula just needs to ascribe some numeric value outside and below this range instead of the blank character or empty cell that you may have at present? 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
Re: [libreoffice-users] vlookup case
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 values to be searched in column A and the
values to be returned in column B. Then try:
=INDEX(B1:Bn;MATCH(1;EXACT("text";A1:An);0))
Note that this is an array formula, so when you have entered it you
must complete the process by pressing Ctrl+Shift+Enter. If you do
this successfully, the entire formula will appear in the Input line
surrounded by braces, but you cannot simply type these braces yourself.
This relies on EXACT() being the one function that *is* case-sensitive.
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] Re: Libreoffice 5.2 not starting
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? 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] vlookup case
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 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] named data ranges
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 set them up and they appear ok in the Define Database Range dialog. However, when i try to enter xlit as the range in a formula i find that it automatically gets changed to mdec. Im going now to try with the ranges defined explicitly instead of using the names, but i wonder if this problem sounds at all familiar to anyone, and if theres anything i can do about it? Thanks Gary -- 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] sorting in calc
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 a number (col B) to each char (col A) in sheet 2, defined as a range 'xlit'. On sheet 1 column A has strings to be sorted, columns B-D contain number to represent char 1,2,3 of the string. I obtain these numbers as text, using a formula of the form =IFERROR(TEXT(VLOOKUP(MID (Ax,y,1),xlit,2,0),"General"")," ") where x is the row containing the string and y is 1,2 or 3 for the appropriate char of the string, returning the number as a string or " "if the character doesnt exist (string is of shorter length). I can now order my strings by sorting on columns B,C,D in that order. Perhaps there might have been an easier way to do it, but it works and thats what counts Gary On Thu, 9/3/17, Gary Collins wrote: Subject: Re: [libreoffice-users] sorting in calc To: "Gary Collins" , "Dries Feys" Cc: "users@global.libreoffice.org" Date: Thursday, 9 March, 2017, 9:12 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 suspect there isnt anything. Maybe it might work if i can convert all the relevant numbers i have entered to text but im still looking for a way to do that. Format>cells>numbers and selecting text doesnt do it, at least not in 5.2.2.2 under windows7. The format *appears* to change in that the numbers become left justified like strings but istext (cell) still returns false /G. On Thu, 9/3/17, Dries Feys wrote: Subject: Re: [libreoffice-users] sorting in calc To: "Gary Collins" Cc: "users@global.libreoffice.org" Date: Thursday, 9 March, 2017, 8:32 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 View our company movies via downloads on our website. On 8 March 2017 at 19:59, 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 > > Thanks > Gary > > -- > 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 -- DISCLAIMER http://www.tvh.com/glob/en/email-disclaimer "This message is delivered to all addressees subject to the conditions set forth in the attached disclaimer, which is an integral part of this message." -- 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] Libreoffice 5.2 not starting
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 run ! I don't understand why the system tells me libreoffice is not installedeven if it is Regards Fiorenza -- 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] sorting in calc
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 suspect there isnt anything. Maybe it might work if i can convert all the relevant numbers i have entered to text but im still looking for a way to do that. Format>cells>numbers and selecting text doesnt do it, at least not in 5.2.2.2 under windows7. The format *appears* to change in that the numbers become left justified like strings but istext (cell) still returns false /G. On Thu, 9/3/17, Dries Feys wrote: Subject: Re: [libreoffice-users] sorting in calc To: "Gary Collins" Cc: "users@global.libreoffice.org" Date: Thursday, 9 March, 2017, 8:32 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 View our company movies via downloads on our website. On 8 March 2017 at 19:59, 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 > > Thanks > Gary > > -- > 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 -- DISCLAIMER http://www.tvh.com/glob/en/email-disclaimer "This message is delivered to all addressees subject to the conditions set forth in the attached disclaimer, which is an integral part of this message." -- 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] Libreoffice 5.2 not starting
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 them, when Libreoffice is executed, the system advises that Libreoffice is not installed... Where could be the problem ? Libreoffice is installed and working for other users... Thank and regards Fiorenza Meini -- 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] Libreoffice 5.2 not starting
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 for other users... Thank and regards Fiorenza Meini -- 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] sorting in calc
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 View our company movies via downloads on our website. On 8 March 2017 at 19:59, 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 > > Thanks > Gary > > -- > 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 -- DISCLAIMER http://www.tvh.com/glob/en/email-disclaimer "This message is delivered to all addressees subject to the conditions set forth in the attached disclaimer, which is an integral part of this message." -- 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] Re: sorting in calc
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 Windows OS). The very first character is ! but there are 14 others (e.g. #) Hope this helps Pedro -- View this message in context: http://nabble.documentfoundation.org/sorting-in-calc-tp4209735p4209757.html Sent from the Users mailing list archive at Nabble.com. -- 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
