[libreoffice-users] Re: Libreoffice 5.2 not starting

[Alexander Thurgood]

Le 10/03/2017 à 09:44, Fiorenza Meini a écrit :

Hi Fiorenza,


> The only difference we can see, is that if I give the command "type
> libreoffice5.2 on the working account, I see "hashing done on
> libreoffice5.2 (/usr/bin/libreoffice5.2)".
> If  I give the same commando the NON WORKING account, I see:
> libreoffice5.2 is /usr/bin/libreoffice5.2.
> 
> The behaviour isn't the same !
> What does mean "hashing done" ? Perhaps is this the problem ?

At a guess, the DEB package that points to /usr/bin/libreOffice5.2 is
hashed for installation security reasons (part of the signing of the
packages) and this hash is verified when a user attempts to execute a
program from that link.

In the non-functional user accounts, the hash isn't verified, so the
application isn't executed (I'm just speculating here, don't take my
word as gospel).

This kind of rings a bell as a Ubuntu bug I read about a while ago where
some user accounts when created did not have an appropiate set up of
executable links to libreoffice - some kind of problem with /etc/skel
not copying everything or setting correct permissions for the newly
created user.

Perhaps you might find something by searching in the Ubuntu launchpad
bug database ?


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

Re: [libreoffice-users] vlookup case

[Michael D. Setzer II]

I was doing some testing with single characters, but then saw it was three 
characters. Originally, just used the code of the character, changed code to 
ascii, but with 3 multiple each value to get a number that matched.
In both put the row number in next column.

Put the match field in C15 both the formulas work, both formulas give the 
row. 


abc
   1
97098099
   1



aBc
   2
97066099
   2



aBC
   3
97066067
   3



Abc
   4
65098099
   4



AbC
   5
65098067
   5



Abc
   6
65098099
   6



Ab
   7
65098000
   7



aCb
   8
97067098
   8



AcB
   9
65099066
   9



aBC
  10
97066067
  10



AAC
  11
65065067
  11



ss
  12
   115115000
  12

















aBC

97066067











   3
“=VLOOKUP($C$15,C1:D12,2,0)

   3
“{=INDEX(B1:B12,MATCH(1,EXACT($C$15,A1:A12),0))}








Formula in C






“=CODE(MID(A15,1,1))*100+CODE(MID(A15,2,1))*1000+CODE(MID(A15,3,1))


On 10 Mar 2017 at 9:46, Gary Collins wrote:

Date sent:  Fri, 10 Mar 2017 09:46:22 + (UTC)
From:   Gary Collins 
Send reply to:  Gary Collins 
To: , Brian Barker 

Copies to:  Gary Collins 
Subject:Re: [libreoffice-users] vlookup case

> Thanks for very helpful reply. It does seem to be a big drawback with these 
> functions. I'll certainly try it but ive found a workaround that im using at 
> the mo: ive defined two strings in adjacent cells and using string functions 
> to find the position of a character in one string then extract the 
> corresponding character from the other. Much less elegant and it was quite 
> tiresome to implement but ive at least got it to work, in the limited cases 
> that im using it so far. If i extend it to transliterate strings of arbitrary 
> length (for now the max length ive needed is 3 chars) then i guess i'll 
> probably have to get into macros.
> Thanks
> G.
> 
> On Thu, 9/3/17, Brian Barker  wrote:
> 
>  Subject: Re: [libreoffice-users] vlookup case
>  To: users@global.libreoffice.org
>  Cc: "Gary Collins" 
>  Date: Thursday, 9 March, 2017, 23:17
>  
>  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 

[libreoffice-users] Re: must press enter/return thrice to force new paragraph (sometimes)

[Piet van Oostrum]

Dwain Alford wrote:

 > hello,
 > 
 > i had this same problem with open office. i don't understand. i set style 
 > prefs and added some new
 > ones. there is a problem with the new one i call block 0.5. i also created a 
 > new default document.
 > i set line spacing to single and no bottom paragraph spacing. seems this is 
 > where the problem
 > begins.
 > 
 > the new default document:
 > 
 > i type a line. press enter/return twice and the cursor stays under the line 
 > until i press enter/
 > return again. then the problem goes away, until later in the document or not 
 > again. hit or miss.
 > 
 > the block 0.5 settings are based on the text body indent settings. the 
 > before and after text is
 > set at 0.5. i highlight all of the text to be blocked and double click the 
 > style setting. the
 > second and third paragraphs change, and the first one does not change.
 > 
 > i have attached a test document to see if anyone else gets the same result. 
 > i typed a two line
 > paragraph and the same press three times to force a paragraph is still a 
 > problem. i have
 > duplicated this on the windows os as well. i can't remember if i had the 
 > same problem when i was
 > using linux or not.
 > 
 > sure would like to resolve this problem.
 [...]
 > cheers,
 > dwain

 > x[DELETED ATTACHMENT force paragraph test.odt, Open Doc]

I set the reply to the libreoffice users list, as the developers list wasn't 
the proper one.

I looked inside your document, and it appears that the first paragraph is 
inside a list, with the paragraph as its only list item. And it is a list with 
no bullet and no number. I have no idea how you got this. But that's why it 
behaves differently. 

So I clicked in that paragraph, and then clicked on the "Toggle Bulleted List" 
Icon. Then a bullet appears, which you obviously don't want. So click on this 
icon again to remove the bullet. After this the paragraph behaves normally.

By the way, I didn't see any "block 0.5" style in the document. All the 
paragraphs had "Default Style".
-- 
Piet van Oostrum 
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]


-- 
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: Libreoffice 5.2 not starting

[Fiorenza Meini]

Il 10/03/2017 10:18, Michael D. Setzer II ha scritto:

Not sure what the hashing done means??

On the non-working users what happens if you run
/usr/bin/libreoffice5.2


I does not start.


you might also want to try running it with strace
strace /usr/bin/libreoffice5.2  It might show some info.

Might need to install strace.



Ok, I'll do it as soon as possible.
Now I don't have the PC where I have the problem with me.

I'll give you a reply soon.

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

[Gary Collins]

Thanks, yes, theres some really helpful info in this reply. I had thought of 
using a lower value but it hadnt occurred to me to hide it using formatting 
(and of course i didnt want it to show). The methods of converting to text are 
very useful to know. In the end i did indeed use the TEXT function in a 
formula, and conditionally substituted a blank where the string was shorter. 
Again not exactly elegant but it works and thats the main thing. It would be 
helpful to be able to define a nonstandard sort order but i dont think thats 
easily possible in a case like this (?: but im very willing to be proved wrong 
on that ) Again i think i'd be into the realm of macros!

Thanks
G.

On Thu, 9/3/17, Brian Barker  wrote:

 Subject: Re: [libreoffice-users] Re: sorting in calc
 To: users@global.libreoffice.org
 Cc: "Gary Collins" 
 Date: Thursday, 9 March, 2017, 23:17
 
 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
 

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

[Gary Collins]

Thanks for very helpful reply. It does seem to be a big drawback with these 
functions. I'll certainly try it but ive found a workaround that im using at 
the mo: ive defined two strings in adjacent cells and using string functions to 
find the position of a character in one string then extract the corresponding 
character from the other. Much less elegant and it was quite tiresome to 
implement but ive at least got it to work, in the limited cases that im using 
it so far. If i extend it to transliterate strings of arbitrary length (for now 
the max length ive needed is 3 chars) then i guess i'll probably have to get 
into macros.
Thanks
G.

On Thu, 9/3/17, Brian Barker  wrote:

 Subject: Re: [libreoffice-users] vlookup case
 To: users@global.libreoffice.org
 Cc: "Gary Collins" 
 Date: Thursday, 9 March, 2017, 23:17
 
 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
 
 

-- 
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: Libreoffice 5.2 not starting

[Fiorenza Meini]

Il 10/03/2017 09:34, Alexander Thurgood ha scritto:

Le 10/03/2017 à 08:51, Fiorenza Meini a écrit :

Hi,


it tells that libreoffice is non installed.
No error is given.



It sounds like there is a permissions problem with those particular
user's setups, especially if other users on the same machine can start
LibreOffice without a problem.

See for example :

https://ask.libreoffice.org/en/question/19549/office-permission/

and

http://askubuntu.com/questions/678094/libreoffice-5-refuses-to-start

which appear to relate to similar problems.


From these links, it appears you would need to check whether or not the

user's libreoffice configuration folders are owned by the correct user
(i.e. not root) and have the correct corresponding user permissions.


Alex




Thank for your response.
I'll check and I'll let you know if the problem is solved.

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: Libreoffice 5.2 not starting

[Fiorenza Meini]

Il 10/03/2017 09:10, Michael D. Setzer II ha scritto:

For a user that it works, open a terminal and type which libreoffice and see
where it finds the program. On an older ubuntu machine  it found
/usr/bin/libreoffice  for my home machine it is /usr/bin/libreoffice5.3 on my
machine. There might also be a symbolic link to it.

Mine had an older link with libreoffice pointing to the old 5.2, which I 
recently
removed after installing 5.3, so I removed and recreated link.

Is there a difference in paths between users?

If you run it from the terminal does it work?
libreoffice
libreoffice5.2
/usr/bin/libreoffice
/usr/bin/libreoffice5.2




Hi,
path on both account are the same :(

The only difference we can see, is that if I give the command "type 
libreoffice5.2 on the working account, I see "hashing done on 
libreoffice5.2 (/usr/bin/libreoffice5.2)".
If  I give the same commando the NON WORKING account, I see: 
libreoffice5.2 is /usr/bin/libreoffice5.2.


The behaviour isn't the same !
What does mean "hashing done" ? Perhaps is this the problem ?

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

[libreoffice-users] Re: Libreoffice 5.2 not starting

[Alexander Thurgood]

Le 10/03/2017 à 08:51, Fiorenza Meini a écrit :

Hi,

> it tells that libreoffice is non installed.
> No error is given.
> 

It sounds like there is a permissions problem with those particular
user's setups, especially if other users on the same machine can start
LibreOffice without a problem.

See for example :

https://ask.libreoffice.org/en/question/19549/office-permission/

and

http://askubuntu.com/questions/678094/libreoffice-5-refuses-to-start

which appear to relate to similar problems.

>From these links, it appears you would need to check whether or not the
user's libreoffice configuration folders are owned by the correct user
(i.e. not root) and have the correct corresponding user permissions.


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

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

[Michael D. Setzer II]

For a user that it works, open a terminal and type which libreoffice and see 
where it finds the program. On an older ubuntu machine  it found 
/usr/bin/libreoffice  for my home machine it is /usr/bin/libreoffice5.3 on my 
machine. There might also be a symbolic link to it.

Mine had an older link with libreoffice pointing to the old 5.2, which I 
recently 
removed after installing 5.3, so I removed and recreated link.

Is there a difference in paths between users?

If you run it from the terminal does it work?
libreoffice
libreoffice5.2
/usr/bin/libreoffice
/usr/bin/libreoffice5.2



On 10 Mar 2017 at 8:51, Fiorenza Meini wrote:

Subject:Re: [libreoffice-users] Re: Libreoffice 5.2 not starting
To: users@global.libreoffice.org
From:   Fiorenza Meini 
Date sent:  Fri, 10 Mar 2017 08:51:44 +0100

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


+--+
  Michael D. Setzer II -  Computer Science Instructor  
  Guam Community College  Computer Center  
  mailto:mi...@kuentos.guam.net
  mailto:msetze...@gmail.com
  Guam - Where America's Day Begins
  G4L Disk Imaging Project maintainer 
  http://sourceforge.net/projects/g4l/
+--+

http://setiathome.berkeley.edu (Original)
Number of Seti Units Returned:  19,471
Processing time:  32 years, 290 days, 12 hours, 58 minutes
(Total Hours: 287,489)

BOINC@HOME CREDITS
ABC 16613838.513356 | EINSTEIN   130284596.788695
ROSETTA 58337511.693666 | SETI   101886081.520316


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