Ask Your Question
1

Formula compatibility

asked 2018-08-25 09:06:51 +0100

VVHH gravatar image

updated 2018-08-27 12:42:14 +0100

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?

edit retag flag offensive close merge delete

Comments

1

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.

erAck gravatar imageerAck ( 2018-08-25 18:40:26 +0100 )edit

Sir

Question has been updated

VVHH gravatar imageVVHH ( 2018-08-27 12:42:39 +0100 )edit

1 Answer

Sort by » oldest newest most voted
2

answered 2018-08-27 14:01:54 +0100

erAck gravatar image

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
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-08-25 09:06:51 +0100

Seen: 93 times

Last updated: Aug 27 '18