TomW wrote:
Johnny Rosenberg wrote:
2008/2/6, Jonathan Kaye <[EMAIL PROTECTED]>:
Johnny Rosenberg wrote:
<snip>
I tried your macro and I didn't get the problems you described. It
seemed
to work perfectly. Maybe I need your whole document to evaluate what's
going on.
Sorry for the delay. I needed a place to upload the file. Note it's
1.7MB.
You can get it here:
http://homepage.univie.ac.at/jonathan.kaye/docs/ndp11testsort.ods
By the way, I think it is a better idea to ask this kind of
questions at
the [EMAIL PROTECTED] mailing list. There are usually more macro
programmers on that list that can help you better.
Thanks for the advice. I'll do that.
Cheers,
Jonathan
Johnny Rosenberg
I have done some tests:
I got the Error 509 just like you. In T1 I typed =map(B1), which failed.
However, I created a new spreadsheet and copied the function to it.
In A1 I
entered some nonsense and in B1 I entered =map(A1) and I got a result!
Next, I renamed your function to MyFunction. That worked too, so it
seems
like SOMETHING in your document is somehow named "map" or something
in that
document makes it impossible to use the "map" as a name of a
function. Calc
seems to think that you mean something else than the function and it
puts
the character ' around the word "map", so that T1 looks like ='map'(B1).
Hope someone can explain what's going on here, because I didn't find the
reason for this behaviour, however I found a solution (change the
name of
the function). I hope that helps.
☺
Johnny Rosenberg
Jonathan
With a little experimentation on what Johnny found, I discovered that
the name of your function corresponds to an entry in cell Q16640. This
seems to be where the conflict comes from.
When the error message appeared, I selected no, which gave the 509
error in the cell. If you then select the same cell in the T column,
then drag it to the cell below (to copy it), you get the entry in cell
Q16641, ='bush fire,veld fire'(B5), replacing ='map'(B5) in the
function. Drag down to the next cell changes the function to the next
cell in column Q. If you change the entry in cell Q16640 by adding
another character(period., trailing space), the function will behave
when entering it in a cell in column T.
An item of note, is that when you enter in the cell your function, the
capitalization is changed to match what is in cell Q16640, after
selecting No in the error dialog. Change the capitalization of cell
Q16640 and the entry in your function will match.
Another oddity is that if you change the data in Q16440 slightly, so
that your function works in a cell in column T. Enter in your function
in a cell in column T. Works of course. Then change Q16640 back to its
original form. I could then copy/paste the cell with the working
function into another cell and it would still work. But if you try to
type the function in, it will fail as usual.
A Bug?
TomW
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
As a follow up. This problem occurs in
OOo-Dev_OOH680_m2_Win32Intel_install_en-US.
I could get an error in a new workbook,too, but a slightly different
problem.
I copied your function into a new workbook. I entered the function in a
cell in column F, referencing a cell in column B. (i.e. =map(b2)) This
worked fine. I could copy the formula down the column with no problems.
I then typed "map" (no quotes) in a cell C18. I then get an #ref! in the
cell b16 when I entered the function in that cell, but no error message
dialog. The input box would show ='map'(b16). Same as in your workbook.
TomW
winXp SP2 OOo2.3.1 and OOo2.4dev
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
