Planmaker is NOT fully compatible with Excel

Post Reply
Mikael63
Posts: 4
Joined: Sun Oct 24, 2021 10:29 pm

Planmaker is NOT fully compatible with Excel

Post by 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
SoftMaker Team
SoftMaker Team
Posts: 2933
Joined: Wed Mar 11, 2020 5:31 pm

Re: Planmaker is NOT fully compatible with Excel

Post by 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
Posts: 4
Joined: Sun Oct 24, 2021 10:29 pm

Re: Planmaker is NOT fully compatible with Excel

Post by 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.
Attachments
Magarna.xlsx
(18.86 KiB) Downloaded 149 times
Mikael63
Posts: 4
Joined: Sun Oct 24, 2021 10:29 pm

Re: Planmaker is NOT fully compatible with Excel

Post by Mikael63 »

Also, this is not working in Planmaker:
https://trumpexcel.com/highlight-active ... umn-excel/
Mikael63
Posts: 4
Joined: Sun Oct 24, 2021 10:29 pm

Re: Planmaker is NOT fully compatible with Excel

Post by 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)
Post Reply

Return to “FreeOffice PlanMaker 2021 for Linux”