Hi Friedrich, perhaps it may help us, if you mail a copy of the function you want to use.
The value "#NAME?" that ist shown means, that you use a command in your function that is not known.
Greetings Max Kneubühler schrieb:
Hello Max Malycha, hello Guy VoetsI'm sorry that I caused people to get angry. Therefore, and since your answers don't show a solution for my problem, I translate to the best of my knowledge my original mail in german: I recently migrated from Microsoft Office 2000 with a considerable and rather complex package of EXCEL spreadsheets to OpenOffice. With this step I experienced great problems. On the one hand the user interface is quite different and on the other hand it is difficult and very time consuming to find certain functions in the menus. Also the help function is not very userfriendly. Entering a search argument relating to a problem a huge list of functions is produced, which cannot easily be assigned to the actual problem. After reading the stuff possibly containing the answer - without being successfully - a great frustration results. A help-function like "how can I ......" as it exists in EXCEL would be very useful. I'm using OpenOffice.org 2.1 on a Windows XP SP2 PC. Inspite of a huge effort I couldn't resolve the following problem: I want to copy a formula from one cell to an other. In the receiving cell the absolutely same calculation should be performed as in the delivering one, naturally with adapted addresses. The steps <edit - copy - paste> create in the receiving cell the error message "#NAME?" and I couldn't find an explanation and the resolution for this error. How can this very trivial function be resolved?Kind regards Friedrich Kneubühler Belvédèrestrasse 31 b, 5621 Zufikon Tel.: 056 / 633 27 79; e-Mail: [EMAIL PROTECTED] Max Malycha schrieb:german version below! Hi,found your message in the OO-forum just in time. There are two remarkable items.1. You sent your mail in the english forum in german, there are some people who don't like that. They will get angy ;-) Please post in english next time or use the german language forum. 2. Your problem: Using copy and paste the adresses in your function are also copied, but changed during insert. Example: you take a function from a1, e. g. =sum(a2:a5;a7) and insert it in b1. This will be like =sum(b2:b5;b7). But if there is text in b7 OO wil get angry and write #Wert!. I think #Name! ist a remark on a bad written function. Perhaps there is a writing error in your function? greetings Max
smime.p7s
Description: S/MIME Cryptographic Signature
