Writing to cell a third party formula

Topics: Developer Forum
Jun 8, 2015 at 9:26 PM

I'm trying to write into a cell a third party formula, i.e., not a native Excel formula. We use Office Connector Excel plug-in to connect to an ERP called Sage. This plug-in enables a new set of formulas, including one called TSIMPORT.

When I write with the library "=TSIMPORT(...)" with all the correct parameters and values, Excel treats it as a string unless I manually click on the cell to edit the content, make no changes and hit Enter. Only then, Excel will consider it a formula. Of course this does not happen if I manually type the formula in Excel.

Not sure if there's something that I'm setting wrong or there's another approach.

Thanks for your help.
Jun 8, 2015 at 9:42 PM
PHPExcel does not support any functions that are not native Excel functions