Re: [libreoffice-users] How to display text using a research function

2016-06-13 Thread Robert Leleu
in french : CHERCHE("trans";A2) give the position of "trans" in cell A2 Je la 13/06/2016 13:07, valcoteau skribis : Hello, I have two columns A and B Column A contains emails and column B is empty I wish that each time in column A is detected certain words like 'trans', 'sped' ... can be

Re: [libreoffice-users] How to display text using a research function

2016-06-13 Thread Piet van Oostrum
valcoteau wrote: > Hello, > > I have two columns A and B > > Column A contains emails and column B is empty > > I wish that each time in column A is detected certain words like 'trans', > 'sped' ... can be directly displayed in column B on the same line the word > 'transportation and

Re: [libreoffice-users] Re: Calc will not save files on a Windows 10 machine

2016-06-13 Thread Paul D. Mirowsky
Have you tried creating a Calc sheet as Admin? On 6/12/2016 11:44 AM, Riverglen wrote: Thanks for your interest. I don't have hands-on access to the Windows 10 machine at the moment. I could probably get a copy of the file that originally had the problem. BUT, my last experiment was to

[libreoffice-users] How to display text using a research function

2016-06-13 Thread valcoteau
Hello, I have two columns A and B Column A contains emails and column B is empty I wish that each time in column A is detected certain words like 'trans', 'sped' ... can be directly displayed in column B on the same line the word 'transportation and Logistics'. I don't know which function to

[libreoffice-users] Re: Calc will not save files on a Windows 10 machine

2016-06-13 Thread Denis Navas Vega
Several ideas that might help. A downloaded file receive a "blocked" attribute. I ignore if that propagates to files that the instaler expand and copy. The second thought I had is that you are using a portable installation, that you can test it on Windows 7. I remember that some operations