Forum

When unzipping the xlsx, a calcChain.xml exists in the xl folder. Although no more functions exist. Removing this and zipping the file again, leads to a working xlsx.
 

It seems that the calcChain.xml is not being replaced or edited.

Hello,

The setCellValue method replaces a cell value keeping all styles (this method works with text contents). Please note that this method calls addCell internally:

$this->addCell($contents, $position, array(), array('useCellStyles' => true));

Maybe you need to use addCell with specific options such as isFunction? Or use addFunction directly? Or the new content can't be added into that specific cell position due to external dependencies in the XLSX?
The current stable version of phpxlsx doesn't update the calcChain.xml file. If ithis file is removed, MS Excel regenerates it when opening the XLSX.

If you send to contact[at]phpdocx.com an XLSX sample and the code you are running that illlustrates your issue. We'll check it.

Regards.

I have sent an example file via mail.
I know that setCellValue uses addCell internally.

Using addCell with isFunction true and without the option to reuse the existing cellStyles leads to the same issue.

The function addFunction is no solution as i want to remove a function. Not add one.

Just as information for everyone else stumbling over this issue. 

Currently you can add functions to a cell, replace functions in a cell, but not remove functions from a cell.

This might be supported in upcoming versions.

Hello,

Thanks for your feedback. A new method will be developed for the stable release of phpxlsx to remove cell contents.

Regards.