Is it possible to get cell formula using JSOM and EWA

Thanks

I think you might find your answer here:

http://msdn.microsoft.com/en-us/library/ee589012.aspx

Ewa.Range.getValuesAsync(Ewa.ValuesFormat.Unformatted, callback, userContext);

That might do it for you, but if not... you can call Excel Service public W/S APIs against the session id for the workbook that is open.  Shahar show something similar with SaveAs in:

http://blogs.msdn.com/b/cumgranosalis/archive/2009/12/09/something-interesting-sample-app-coding-part-2-coding-the-publish-functionality.aspx

If that doesn't help, let me know and we'll see about getting an example out there for the scenario you describe.  I can't believe you're the only one wanting to do this.  Note that there are certain restrictions to formula access, depending on the editing mode of the document and the user's access persmissions; our 'one version of the truth' mantra for Excel Services.

Hi Anthony,

I am trying to do the same thing and I don't believe your solution works. I am trying to get a formula from a cell, not the value returned from that formula.

Specifying values format as unformatted doesn't provide the formula, it just removes any formatting you may have attached to the object. What can I do to get access to the underlying formula?

Thanks.