
Hi,
I'm trying to write into a cell a third party formula, i.e., not a native Excel formula. We use Office Connector Excel plugin to connect to an ERP called Sage. This plugin 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.


Coordinator
Jun 8, 2015 at 9:42 PM

PHPExcel does not support any functions that are not native Excel functions

