Package io.keikai.range.impl.imexp

Class XlfnFunctions

java.lang.Object

io.keikai.range.impl.imexp.XlfnFunctions

public final class XlfnFunctions
extends Object

Manages the set of Excel future functions that require the _xlfn. prefix when exported to OOXML format.

The list is based on the [MS-XLSX] specification, Section 2.2.3 (Functions).

Since:

6.3.0

See Also:

• MS-XLSX

Method Summary

Modifier and Type	Method	Description
static String	addPrefixes(String formula)	Scan a formula string and prepend _xlfn. to every future- function call that does not already have the prefix.
static boolean	isFutureFunction(String name)	Returns true if the given function name (case-insensitive) is an Excel future function that requires the _xlfn. prefix.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Details

isFutureFunction

public static boolean isFutureFunction(String name)

Returns true if the given function name (case-insensitive) is an Excel future function that requires the _xlfn. prefix.

addPrefixes

public static String addPrefixes(String formula)

Scan a formula string and prepend _xlfn. to every future- function call that does not already have the prefix.

Parameters:

formula - the formula string (without leading '=')

Returns:

the formula with _xlfn. prefixes added where needed