Formula compatibility

Team

Have an issue, Use both Libreoffice 6.1.0 and MS Office 2013 for testing purpose.

Some formulae of Libreoffice (example: minifs()) don’t work if the file is opened in MS Office. They get replaced with .xlfn_ kind of coding.

Also, chart functionality is not showing properly. Charts are not as seamless as they were in MS Office 2013

How to address this?

By asking good questions. i.e. which function names are affected to show up with a _xlfn. prefix, which MS-Office version, which LibreOffice version.There are some functions that are not supported by all MS-Excel versions.

Sir

Question has been updated

MINIFS() was introduced with Excel 2016, so it’s natural that it doesn’t work in Excel 2013. The _xlfn. function name prefix is displayed in earlier versions because that’s the way how additional/new (not defined in OOXML) functions are stored in Excel files.

The following functions supported by LibreOffice are new in Excel 2016:

  • FORECAST.ETS
  • FORECAST.ETS.CONFINT
  • FORECAST.ETS.SEASONALITY
  • FORECAST.ETS.STAT
  • FORECAST.LINEAR
  • CONCAT
  • TEXTJOIN
  • IFS
  • SWITCH
  • MINIFS
  • MAXIFS