SetCellFormula produces a bad formula if you use quotes

[af-engineering]

Formula: =TEXTJOIN(", ", TRUE, UNIQUE(SORT(C11:C88)))

If I set this formula in Excel, unzip the xlsx file and look at the sheet XML, I see

<f>_xlfn.TEXTJOIN(", ", TRUE, _xlfn.UNIQUE(_xlfn._xlws.SORT(C11:C88)))</f>

If I set the same formula using Excelize, I see

<f>=TEXTJOIN(&#34;, &#34;, TRUE, UNIQUE(SORT(C11:C88)))</f>

There may be other differences elsewhere that also effects this.

[xuri]

Hi @af-engineering, thanks for your feedback, which version of the Excelize are you using? Please try to use the master branch code. The SORT function is one of several beta features, and currently only available to a portion of Office Insiders at this time.

[af-engineering]

We were using v2.0.2, but I just switched to master and it results in the same error. Here's what happens when you try to open the file:

[xuri]

Hi @af-engineering, try to using =_xlfn.TEXTJOIN(", ", TRUE, _xlfn.UNIQUE(_xlfn._xlws.SORT(C11:C88))) in the SetCellFormula function, I have tested and it works well. If not, please provide file attachments without sensitive info, and version of your Excel application.

[af-engineering]

That does work. Thanks for the workaround.