Re: Trouble!!!
Lieber Jochen, man schreibt deutsch hier. Gruß Michael signature.asc Description: OpenPGP digital signature
Strange behavior of 4.1.1. Math (file attached)
Dear OO team, Lately one of my superior got problems using the Calc part if your product. They are using the function LOOKUP in rows in which the text is not sorted in ascending or descending order the exact LOOKUP function is not working. There is attached file with the exact situation. However, if we try this in MS Office the problem is non existent and we could lineup all of the rows. Any help, or further information will be much appreciated BR~ 150126 TEST with NA error.ods Description: application/vnd.oasis.opendocument.spreadsheet - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: odt-file, ascii filter, series of pounds
You're using Thunderbird 31 and in this version the filters can't spot the 2nd delivered to field. This was discussed several months ago. You need to upgrade to a later version. Mine work fine (34). Hagar Le 18/02/2015 23:12, Martin Groenescheij a écrit : Hi Hagar, You're correct. I use a filter to mark all emails Delivered-To: moderator This one was not marked (no idea why not), I should have checked before I replied. Sorry, I will check next time. Martin On 19-Feb-15 07:47, Hagar Delest wrote: Le 18/02/2015 01:06, Martin Groenescheij a écrit : On 18-Feb-15 09:47, Hagar Delest wrote: Top posting. For the record, OP is not subscribed so he has missed almost all the replies. For the record, OP was subscribed at the moment he raised the question. Hmm, how do you see that? I checked his first message and there is: Delivered-To: mailing list users@openoffice.apache.org Delivered-To: moderator for users@openoffice.apache.org Same for his second post BTW. So I still think that he's still not subscribed. Hagar - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Strange behavior of 4.1.1. Math (file attached)
At 10:18 19/02/2015 +0200, Yavor Marinov wrote: Dear OO team, There is no team here, in fact: just other users, like you. Lately one of my superior got problems using the Calc part if your product. So it's not my product. They are using the function LOOKUP in rows in which the text is not sorted in ascending or descending order the exact LOOKUP function is not working. The help text makes very clear that this is not supported: ... the search vector for the LOOKUP must be sorted in ascending order, otherwise the search will not return any usable results. In addition, the Calc Guide says Use LOOKUP when: The search data is sorted in ascending order. There is attached file with the exact situation. To search unsorted lists, you need to use either HLOOKUP() or VLOOKUP() as appropriate. However, if we try this in MS Office the problem is non existent and we could lineup all of the rows. If you prefer Microsoft Office, I believe licences are available for purchase. But in any case, the Microsoft web site says about the Excel LOOKUP() function *Important* The values in _lookup_vector_ must be placed in ascending order. [...] If you do not do so, *LOOKUP* may not give the correct value. - which seems to contradict what you claim. Any help, or further information will be much appreciated Either: o Sort your Reference table by column D Or: o Replace your formula =LOOKUP($B$3;$D$5:$D$15;$E$5:$E$15) with =VLOOKUP($B$3;$D$5:$E$15;2;0) I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: problem with import of excel file, cells contain new lines
At 11:28 19/02/2015 +0100, Uwe Brauer wrote:
By the way, when I perform this operations for one cell say C2 and
then want to enhance it to the whole column, it seems that I can
only do it by dragging the boundary of the cells with the mouse. Is
this correct?
No. Dragging the fill handle (not the cell boundary) is indeed one,
often convenient way. But others are copying and pasting, as well as
using Edit | Fill | Down. For these, you will need to select the
target range, but you can easily do that using click at one end and
Shift+click at the other.
I am asking since the original file in question has a column of 300
rows and using the mouse proved to be very very slow, but
clean(C2:C300) did not work neither.
Actually, you can use formulae like that, where a function operates on a range:
o Select the first cell of the target range.
o Enter the formula.
o To complete the formula, don't press Enter or click the green
arrow. Instead, press Ctrl+Shift+Enter. The formula (visible in the
Input Line) has now grown enclosing braces, as
{=CLEAN(C2:C300)}
- but note that you cannot type the braces yourself. This is called
an array formula.
(By the way, I think I'd established that CLEAN() wouldn't work for
you: three applications would be necessary to remove all five tab
characters and you would still have the remaining space and
non-breaking space to deal with if you wanted to process the values
as numbers.)
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Trouble!!!
Hallo Jochen, snip Hy, I have many NEW problems with OO Calc these days - I work with and MacBook Pro 2013 and Yosemite Systemsoftware: Systemversion: OS X 10.10.2 (14C109) Kernel-Version: Darwin 14.1.0 Startvolume:SSD Startmodus: Normal Benutzername: Jochen Steinberg (jocsberg) Sicherer virtueller Speicher: Aktiviert Zeit seit dem Start:9 Tage 2:00 What can I do? Zunächst kannst Du Dein Problem mal in aller Ausführlichkeit darstellen. If I take some cells to another place on the same sheet Open Office breaks down without having stored the work I did. Du beschreibst hier einen alltäglichen Vorgang, der sonst überall klappt. Wie gesagt: in aller Ausführlichkeit bitte! Big Shit! Bei solch einem Problem kann ich nur ’nen Arzt oder ein Sanitärunternehmen empfehlen. Gruß Günter - To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-de-h...@openoffice.apache.org
Re: problem with import of excel file, cells contain new lines
Brian == Brian Barker b.m.bar...@btinternet.com writes: At 18:29 18/02/2015 +0100, Uwe Brauer wrote: I run for example clean(C2) and it returns Err:522. C is the column with the problems That means that your formula is circular. I'm guessing that you have tried putting =CLEAN(C2) into C2 itself. Apart from the fact that this Right! I did this because I thought: if I copy the cell in a new column, and then want to replace the old one with the new one, I will have a problem: the new one depends on the old one and then everything gets deleted. But as you explain below: that can be avoided, thanks for pointing it out. By the way, when I perform this operations for one cell say C2 and then want to enhance it to the whole column, it seems that I can only do it by dragging the boundary of the cells with the mouse. Is this correct? I am asking since the original file in question has a column of 300 rows and using the mouse proved to be very very slow, but clean(C2:C300) did not work neither. Any comments? deletes that value to are trying to recover, it suggests that you want the value in C2 to be a CLEANed version of the value in C2 - which is a CLEANed version of what is in C2! The formula refers back to itself repeatedly, and the calculation can never end. If you were to use a formula to achieve what you need, you would have to put it into a spare column. You could choose to copy the results back into the original cells, but you would need to use Paste Special instead of ordinary paste and to deselect Formulae in the Paste Special dialogue so as to freeze the results. I trust this helps. Thanks indeed it does. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: need help with a problem
Mary Ann Scholl wrote: Good morning, I don't really know the right place to send this question, but hopefully this is the place to get free help to solve my problem. I have IMac computer OSX 10.9.5, and I have OpenOffice on it. I have had this problem for a long time. It freezes up on me, and I have to force quit it. Do you have any suggestions? Also I would love to have telephone number to call someone at OpenOffice if that is possible for the future. Thank you so much in advance for any help you can give me!! Wishing you a beautiful day Sincerely, Mary Ann Scholl maryannsch...@gmail.com Mary Ann; Without more particulars as to what is happening it is difficult to offer definitive advise; however this sounds like a known problem. The following from the Release Notes for version 4.0.1 gives the solution to this issue. On recent versions of Mac OS X it might happen, especially after a Force quit, that the following error message appears: Restore Windows - The application OpenOffice.org was forced to quit while trying to restore its windows. Do you want to try to restore its windows again?. If you cannot get rid of it: Option-click the Go menu; choose Library from the menu to open the folder in the Finder; click on the folder Saved Application State; delete the file org.openoffice.script.savedState. This problem has been fixed for the latest version of AOO. If this does not solve your problem please reply back to the list with more details as to the problem you are experiencing. This reply has been cc'd to your e-mail address as a courtesy as you are not subscribed to the mailing list. Please reply ONLY to the list and not my personal e-mail. To subscribe to the list see the instructions at:http://openoffice.apache.org/mailing-lists.html#users-mailing-list-public. Regards Keith signature.asc Description: OpenPGP digital signature
Re: ABC Spelling does not work
Dennis, I think the Open Office spell check works. Why I think it does not is when I use F7 or high light the word the whole sentence appears - not just the word in question. When you move to the desired word all it says is word is not in the dictionary. This form of spell check is really useless/worthless. I use to highlight the word or use F7 and if misspelled it would recommend a correct spelling for the word - which it no longer does. I did our family tree a couple years ago and this was not only a time saver but also really appreciated. Simply put - How in the heck do I get this method of spell check back?? Yahoo mail highlights misspelled words, I cannot figure out why Open Office cannot. Unrelated question: What app do you down load to be able to email privately ?? Jon On Wednesday, February 11, 2015 7:45 PM, Jon Kurz westchic...@yahoo.com wrote: Dennis,Sorry for the delayed respond to your email.1) The ABC tool bar buttons were working up to about 1 1/2 years ago. I assume this problem started after an update. 2) I have a HP computer about 10 years old and I am using Windows XP. 3) As far as I know I have added no writing tools. I am using the English version - Open Office 4.1..1 (en-US) installation files, modified 1/30/15. 4) As far as I know/remember all the original options are still installed and no customizing done. Thanks for the respond. Any more question feel free to ask. Looking forward to working with you. Jon At one time I was advised to do the following to correct the problem - - I have no idea what a login name is or remember the name used 10+ years ago to log into windows. I guess, in honesty, I have no idea how to proceed to solve my problem with these instructions. I am a simple hands on person, not a computer guru.o Close OpenOffice. o If it is running, close the Quickstarter. Find its icon in the System Tray (bottom right of screen), right-click it, and select Exit or Quit or whatever. o (Outside OpenOffice) go to My Documents (Windows Explorer) and navigate to C:\Documents and Settings\login-name\Application Data\OpenOffice\4 - where login-name is the name you use to log in to Windows. Note that Application Data is a hidden folder, so you will either have to enable the display of hidden folders or else type the name in yourself. One simple way is to get as far as C:\Documents and Settings\login-name, then put the cursor into the Address bar above the list at the end of the current display, type \Application Data (no quotes) and press Enter. Then you can easily continue to browse to ...\OpenOffice\4. o Rename the user folder you find there (which contains the actual profile) in order to disable it. (Alternatively, you could just delete it.) o Restart OpenOffice, which should create a clean copy of the profile for you. On Friday, January 30, 2015 1:20 PM, Dennis E. Hamilton dennis.hamil...@acm.org wrote: My understanding of your report is that the ABC toolbar buttons and the F7 function key in OpenOffice Writer do not accomplish what you expect. 1. Is it correct that these operations were successful at one time in the past and that since you have been updating, they no longer work? Or has it never worked? 2. Apache OpenOffice works on many different products and operating systems. Please provide 1. What kind of computer you are using. 2. What the operating system and version are (e.g., Windows XP, Windows 8.1, Macintosh OSX, etc.) 3. Have you added any writing tools (grammar checker, spell checker) other than those that are installed with your version of Apache OpenOffice? Are you using the English version of Apache OpenOffice? 4. When you install Apache OpenOffice do you accept the options that are provided during installation and not change anything? Or do you customize the installation in some manner? There is a common technique that often works. It is called resetting the user profile. That will have Apache OpenOffice rediscover the dictionaries and other settings. It is sort of a power-user thing. If you provide the information requested above, we can give you specific steps for doing that on your particular setup. - Dennis PS: You have reached a public mailing list on which volunteers contribute to questions from other users like themselves. For any follow-up, please reply to users@openoffice.apache.org where expert users can offer further advice and others can learn the solutions to problems. Advisors on this list do not promise to respond to questions sent directly to their email addresses. To observe questions and solutions posted to the list, you are welcome to subscribe to users@openoffice.apache.org by sending an e-mail with any subject to users-subscr...@openoffice.apache.org from the mail account where you wish to receive posts made to the list. The OpenOffice Forums have an extensive knowledge
Re: problem with import of excel file, cells contain new lines
El 19/02/15 a las 05:28, Uwe Brauer escribió: deletes that value to are trying to recover, it suggests that you want the value in C2 to be a CLEANed version of the value in C2 - which is a CLEANed version of what is in C2! The formula refers back to itself repeatedly, and the calculation can never end. If you were to use a formula to achieve what you need, you would have to put it into a spare column. You could choose to copy the results back into the original cells, but you would need to use Paste Special instead of ordinary paste and to deselect Formulae in the Paste Special dialogue so as to freeze the results. I trust this helps. Thanks indeed it does. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org Maybe, as Andrew sugested in the list , the search and replace could be the solution. Try this. First, select the column C Call the search and replace option in the edit menu. In Search box fill with \n\t\t\t\t\t.. In Replace box left empty Click to open the more options mark option Only in current selection (I'm using a spanish versión, so I don't remember the correct words in english) mark oprtion Regular expression Click Replace all The pattern \n\t\t\t\t\t.. correspond to the weird caracters in cells of column C, if this pattern change, maybe this solution need a fix. Try it, and we'll see. SECOND VERSION.. Searching a little deep. I Found that you can use [:cntrl:] in search box, to erase all non printable characters. Doesn't matter if the pattern change. Maybe this is the easy way to solution Uwe's problem. Bye -- Manuel Andrés Ramírez P. Administrador Informático GNU/Linux Registered User:412887 Visite:www.getgnulinux.org/es/ Yo Tengo mi Office Legal y no pagué por su licencia El placer más noble es el júbilo de comprender (Leonardo Da Vinci) - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: need help with a problem
OpenOffice is not a company, no offices, no phone. Is a community and a project, you are free to use it, test it and distribute it. You can also hire support from companies that do professional support for it. They do have a phone number: http://www.openoffice.org/bizdev/consultants.html We would need more information in order to determine when and how does the Freeze happens. It could be a third party application interrupting on the closing process. Please give us the version of OpenOffice that you are using, the current one is 4.1.1. On Thu, Feb 19, 2015 at 10:27 AM, Mary Ann Scholl maryannsch...@gmail.com wrote: Good morning, I don't really know the right place to send this question, but hopefully this is the place to get free help to solve my problem. I have IMac computer OSX 10.9.5, and I have OpenOffice on it. I have had this problem for a long time. It freezes up on me, and I have to force quit it. Do you have any suggestions? Also I would love to have telephone number to call someone at OpenOffice if that is possible for the future. Thank you so much in advance for any help you can give me!! Wishing you a beautiful day Sincerely, Mary Ann Scholl maryannsch...@gmail.com -- Alexandro Colorado Apache OpenOffice Contributor 882C 4389 3C27 E8DF 41B9 5C4C 1DB7 9D1C 7F4C 2614
Re: problem with import of excel file, cells contain new lines
El 19/02/15 a las 11:18, Brian Barker escribió: At 10:53 19/02/2015 -0500, Manuel Andres Ramirez wrote: Searching a little deep. I Found that you can use [:cntrl:] in search box, to erase all non printable characters. Doesn't matter if the pattern change. Maybe this is the easy way to solution Uwe's problem. Nice idea. This removes the line break and the tab characters but sadly not the final space and non-breaking space. Brian Barker Brian, are you sure. I've tested and only remain de values inside the cells of column C. All nonprintable characters must be deleted. Are the regular expressión marked? in the search and replace dialog. -- Manuel Andrés Ramírez P. Administrador Informático GNU/Linux Registered User:412887 Visite:www.getgnulinux.org/es/ Yo Tengo mi Office Legal y no pagué por su licencia El placer más noble es el júbilo de comprender (Leonardo Da Vinci) - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Open Office 2015
Download is blocked What should one do? Regards thanks Walter Pachl - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Open Office 2015
Hello, on what site you do have to try to download? Download on www.openoffice.org, the official site. Regards photo *Sylvain DENIS* Conseiller Pédagogique TIC Pedago-tic, a.s.b.l | m: 32 499 219 802 | e: sylv...@pedago-tic.be | w: www.pedago-tic.be Facebook https://www.facebook.com/sylvain.denis Twitter https://twitter.com/sylvaindenisedu LinkedIn http://be.linkedin.com/in/sylvaindenis/ Designed with WiseStamp - http://r1.wisestamp.com/r/landing?u=66b8423e1ca4688dv=nullt=1424356199902promo=10dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_10Get yours http://r1.wisestamp.com/r/landing?u=66b8423e1ca4688dv=nullt=1424356199902promo=10dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_10 Le 19/02/15 15:22, Walter Pachl a écrit : Download is blocked What should one do? Regards thanks Walter Pachl - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
