Re: AppleWorks Spreadsheet
Re: AppleWorks Spreadsheet
- Subject: Re: AppleWorks Spreadsheet
- From: Axel Luttgens <email@hidden>
- Date: Wed, 21 Jan 2004 15:59:49 +0100
Jay Rimalrick wrote:
I wrote an applescript function to do some calculations in a spreadsheet. I
had a script file that worked and now I am trying to update it. Before I
updated to panther it worked fine but now when I take the same code and
make a new script file it is not working
If the above may be summarized as "it used to work, and now it doesn't
work anymore", you could be the victim of a long-standing bug in AW
speadsheets.
I don't remember the details, as it happened to me some times ago, but
the idea is that a spreadsheet suddenly looses all of its information
about its structure when driven through AppleScript.
My searches about that bug all lead to the idea that this will happen
soon or later.
In my case, it was rather sooner than later and quite systematic, so
that I finally did the job in FMP...
So, before going further, have you tried with a newly created
spreadsheet (not just by duplicating the file, nor by selecting all and
copying/pasting in a new spreadsheet), even if that means redefining
lots of things?
If it works, then it could well be that damn bug.
A new version of EN-AW has just been released. It could be worth to have
a look at the release notes (if any).
HTH,
Axel
I get the error: "An unexpected error occurred #19332" or when I don't get
that error the value of the cell is "#VALUE"
I use the function =MACRO("myFile",2,"functionname",E3,0) in my spread
sheet and I placed the script file in the appleworks essentials script folder.
does anyone have any idea why I am getting these weird errors?
Thanks,
jay
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.