Planmaker is NOT fully compatible with Excel

[Mikael63]

.. since Planmaker does not handles formula like this:

Code: Select all

=_xlfn._xlws.SORT(CONCATENATE(_xlfn.ANCHORARRAY(tecken!A4),_xlfn.ANCHORARRAY(tecken!B4),_xlfn.ANCHORARRAY(tecken!C4),_xlfn.ANCHORARRAY(tecken!D4),_xlfn.ANCHORARRAY(tecken!E4),_xlfn.ANCHORARRAY(tecken!F4),_xlfn.ANCHORARRAY(tecken!G4),_xlfn.ANCHORARRAY(tecken!H4),_xlfn.ANCHORARRAY(tecken!I4)))

Edit:
Or just more simple:

Code: Select all

=COUNTA(_xlfn.ANCHORARRAY(A6))

[SuperTech]

Please share some more details about these functions, like in which version of Excel you used these function, and please share the associated file also where you used these functions.

If you want to send it to us privately, please e-mail us at the forum[at]softmaker.de

Please also include the forum URL of this topic so that we can trace your e-mail.
viewtopic.php?f=419&t=22259&p=71934#p71934

[Mikael63]

See attached as an example. It is a anagram generator.
Works in Office 365, like the free one that comes with an Microsoft account like hotmail.com and so on.

[Mikael63]

Also, this is not working in Planmaker:
https://trumpexcel.com/highlight-active ... umn-excel/

[Mikael63]

Ah!

PlanMaker is not able to execute macros and VBA scripts stored in Excel documents. When an Excel file is opened that contains macros or scripts, they will be ignored.

Case closed
(=uninstall)