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
