Re: Formula of selection:Formula too big for applescript
Re: Formula of selection:Formula too big for applescript
- Subject: Re: Formula of selection:Formula too big for applescript
- From: "Gary (Lists)" <email@hidden>
- Date: Thu, 17 Nov 2005 10:15:17 -0500
"Bastiaan Boertien" wrote:
> I made a script to convert excell into MySQL. The problem is that the contents
> of some cells are too big. When I have 1024 characters in a cell, the script
> can get the formula of the selected cell. When I have 1025 characters an error
> wil return with the message 'microsoft excel cannot "get formula of
> selection"' or something. Does anyone know how to solve this problem. I tried
> to do an character count, so I can get the text in pieces, but it will return
> no value
Do you mean 'formula' or cell contents? They are different.
The display limit per cell is 1024, but that is not the actual length limit.
Excel will only display 1024 characters in a cell. The formula bar will
display, when the cell is selected, the maximum of 32,767 characters.
--
Gary
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden