[libreoffice-users] Re: How to display text using a research function
Hello Thanks a lot it's perfect :) -- View this message in context: http://nabble.documentfoundation.org/How-to-display-text-using-a-research-function-tp4186030p4186087.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
[libreoffice-users] Re: Calc will not save files on a Windows 10 machine
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 require java and for portable programs is preferable portable java. That is true for the assistants (letter, fax, agenda, presentation ...) and for the options on the start up panel "Writer Document", "Calc book", etc for new documents. But the menus (file - new - type of document) works well without needing java. Also, LibreOffice web page warns about the compatibility of 32/64 bits versions with processors of 64 bits. Is your version compatible? Windows 10 has also preference to MS software and probably and have been mentioned that alternative software rutinously are having problems with Windows 10. --- El software de antivirus Avast ha analizado este correo electrónico en busca de virus. https://www.avast.com/antivirus -- 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] How to display text using a research function
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 Logistics'.
>
> I don't know which function to use
>
> Thanks in advance for your help
>
> Regards
Something like this (in B1 and copying down):
=IF(OR(ISNUMBER(SEARCH("trans";A1));ISNUMBER(SEARCH("sped";A1)));"Transportation
and Logistics";"")
--
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] How to display text using a research function
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 directly displayed in column B on the
same line the word 'transportation and Logistics'. I don't know which
function to use Thanks in advance for your help Regards -- View this
message in context:
http://nabble.documentfoundation.org/How-to-display-text-using-a-research-function-tp4186030.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
Re: [libreoffice-users] Re: Calc will not save files on a Windows 10 machine
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 create an entirely new spreadsheet file (just a few cells, filled with arbitrary integers) on the Windows 10 machine, and the Calc program wouldn't save that, regardless of whether I tried "Save" or "Save as". So it seems unlikely the the original file was the source of the problem. I believe that she has tried several files, with the same result. One thing I will have to check back on is a few settings changes I made to set up default file paths, and Windows file type associations so that the user wouldn't be confused needlessly by a slightly different working environment. But, it still seems to me that a newly created file should be saved without protest. If I made some errors in the configuration changes I made, I might expect to have a little trouble finding where the file got saved. But I get the error report pop-up immediately, as soon as I select any of the available save options from the "File" menu. -- View this message in context: http://nabble.documentfoundation.org/Calc-will-not-save-files-on-a-Windows-10-machine-tp4185894p4185969.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
[libreoffice-users] How to display text using a research function
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 use Thanks in advance for your help Regards -- View this message in context: http://nabble.documentfoundation.org/How-to-display-text-using-a-research-function-tp4186030.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
