Notes Formula and OpenFormula function implementations as Rosetta APIs as of Volt MX Go v2.0.3 release.
Notes:
1 - Implemented at the VoltMX data framework layer.
Notes @Formula Language OpenFormula (Excel)
FunctionsCommands
160 Implemented38 To Be Implemented83 No Plans To Implement 5 Implemented24 To Be Implemented360 No Plans To Implement 391 Implemented28 To Be Implemented6 No Plans To Implement
@Abs@AddToFolder@Abstract[Compose]1[AgentEnableDisable][AddBookmark]=ABS=ACCRINTM=CELL
@AbstractSimple@AdminECLIsLocked@Accessed[FileOpenDatabase]1[AgentRun][AddDatabase]=ACCRINT=AMORDEGRC=INFO
@ACos@AttachmentLengths@Certificate[FileSave]1[AttachmentDetachAll][AddDatabaseRepID]=ACOS=AMORLINC=ISFORMULA
@Adjust@AttachmentModifiedTimes@CheckAlarms[OpenDocument]1[AttachmentLaunch][AddToIMContactList]=ACOSH=ASC=ISREF
@All1@BrowserInfo@CheckCalendar[OpenView]1[CloseWindow][AdminCertify]=ACOT=BAHTTEXT=SHEET
@AllChildren1@CheckFormulaSyntax@ConfigFile[EmptyTrash][AdminCreateGroup]=ACOTH=COUPDAYBS=SHEETS
@AllDescendants1@ClientType@DB2Schema[FileCloseWindow][AdminCrossCertifyIDFile]=ADD=COUPDAYSNC
@Ascii@DeleteDocument@DbCommand[FilePrint][AdminCrossCertifyKey]=AGGREGATE=COUPNCD
@ASin@DialogBox@DbExists[FindFreeTimeDialog][AdminDatabaseAnalysis]=AND=COUPNUM
@ATan@DocFields@DbManager[MailSend][AdminDatabaseQuotas]=ARABIC=COUPPCD
@ATan2@Domain@DbName[MoveToTrash][AdminIDFileClearPassword]=ASIN=DBCS
@AttachmentNames1@GetHTTPHeader@DbTitle[OpenInNewWindow][AdminIDFileExamine]=ASINH=DURATION
@Attachments1@HardDeleteDocument@DDEExecute[RefreshWindow][AdminIDFileSetPassword]=ATAN=ERFCPRECISE
@Author1@HashPassword@DDEInitiate[ReloadWindow][Administration]=ATAN2=ERFPRECISE
@Begins@IsAgentEnabled@DDEPoke[RemoveFromFolder][AdminNewOrganization]=ATANH=INTRATE
@BusinessDays@IsCategory@DDETerminate[RunAgent][AdminNewOrgUnit]=AVEDEV=MDURATION
@Char@IsResponseDoc@Do[RunScheduledAgents][AdminOpenAddressBook]=AVERAGE=ODDFPRICE
@clearCache1@IsValid@DocLength[SendInstantMessage][AdminOpenCatalog]=AVERAGEA=ODDFYIELD
@Command1@LDAPServer@DocLock[ToolsRunBackgroundMacros][AdminOpenCertLog]=AVERAGEIF=ODDLPRICE
@Compare@NameLookup@DocMark[ToolsRunMacro][AdminOpenGroupsView]=AVERAGEIFS=ODDLYIELD
@Contains@Password@DocOmmittedLength[ViewRefreshFields][AdminOpenServerLog]=BASE=PRICE
@Context@PickList@DoWhile[WindowMaximize][AdminOpenServersView]=BESSELI=PRICEMAT
@Cos@Platform@EditECL[WindowMinimize][AdminOpenStatistics]=BESSELJ=PRONETIC
@Count@SetHTTPHeader@EditUserECL[WindowTile][AdminOpenUsersView]=BESSELK=RECEIVED
@Created1@Soundex@EnableAlarms[AdminOutgoingMail]=BESSELY=VDB
@date@StatusBar@FontList[AdminRegisterFromFile]=BETADIST=YIELD
@Day@UndeleteDocument@For[AdminRegisterServer]=BETAINV=YIELDDISC
@DbColumn1@UpdateFormulaContext@FormLanguage[AdminRegisterUser]=BIN2DEC=YIELDMAT
@DbLookup1@URLDecode@GetAddressBooks[AdminRemoteConsole]=BIN2HEX
@Debug@URLEncode@GetFocusTable[AdminSendMailTrace]=BIN2OCT
@DeleteField1@URLGetHeader@GetIMContactListGroupNames[AdminStatisticsConfig]=BINOMDIST
@DocChildren1@URLHistory@GetPortsList[AdminTraceConnection]=BITAND
@DocDescendants1@URLOpen@GetProfileField[AgentEdit]=BITLSHIFT
@DocLevel1@UrlQueryString@GetViewInfo[AgentLog]=BITOR
@DocNumber1@UserAccess@InheritedDocumentUniqueID[AgentSetServerName]=BITRSHIFT
@DocParentNumber1@UserNamesList@IsAppInstalled[AgentTestRun]=BITXOR
@DocSiblings1@UserPrivileges@IsDB2[AttachmentProperties]=CEILING
@documentSave1@UserRoles@IsDocBeingEdited[AttachmentView]=CEILINGMATH
@DocumentUniqueID1@IsDocBeingLoaded[CalendarFormat]=CEILINGPRECISE
@Elements@IsDocBeingMailed[CalendarGoTo]=CHAR
@Ends@IsDocBeingRecalculated[ChooseFolders]=CHIDIST
@Environment@IsDocBeingSaved[Clear]=CHIDISTRT
@Eval1@IsDocTruncated[ComposeWithReference]=CHIINV
@Exp@IsEmbeddedInsideWCT[CopySelectedAsTable]=CHIINVRT
@Explode@IsExpandable[CreateAction]=CHITEST
@Failure@IsInCompositeApp[CreateAgent]=CHOOSE
@False@IsModalHelp[CreateControlledAccessSection]=CLEAN
@fetchAllViewDocuments1@IsUsingJavaElement[CreateEllipse]=CODE
@FileDir@IsVirtualizedDirectory[CreateFolder]=COLUMN
@FloatEq@LaunchApp[CreateForm]=COLUMNS
@getCurrentDocument1@MailDbName[CreateLayoutRegion]=COMBIN
@GetCurrentTimeZone@MailEncryptSavedPreference[CreateNavigator]=COMBINA
@getCurrentViewDocument1@MailEncryptSentPreference[CreatePolygon]=COMPLEX
@GetDocField1@MailSavePreference[CreatePolyline]=CONCAT
@getDocument1@MailSignPreference[CreateRectangle]=CONCATENATE
@GetField1@NoteID[CreateRectangularHotspot]=CONFIDENCE
@GetFieldType1@OptimizeMailAddress[CreateSection]=CONVERT
@getFormFromUNID1@OrgDir[CreateSubform]=CORREL
@getLastError1@PasswordQuality[CreateTextbox]=COS
@getObjectMetadata1@PolicyIsFieldLocked[CreateView]=COSH
@getServiceEntry1@PostedCommand[DatabaseDelete]=COT
@getServiceName1@RefreshECL[DatabaseReplSettings]=COTH
@getServiceObject1@RegQueryValue[DebugLotusScript]=COUNT
@Hour@ReplicaID[DesignDocumentInfo]=COUNTA
@If@ServerAccess[DesignFormAttributes]=COUNTBLANK
@IfError@ServerName[DesignFormFieldDef]=COUNTIF
@Implode@SetProfileField[DesignFormNewField]=COUNTIFS
@Integer@SetTargetFrame[DesignForms]=COUNTIN
@IsAvailable1@SetViewInfo[DesignFormShareField]=COUNTUNIQUE
@IsError@ShowParentPreview[DesignFormUseField]=COUPDAYS
@IsMember@TemplateVersion[DesignFormWindowTitle]=COVAR
@IsNewDoc1@Unavailable[DesignHelpAboutDocument]=COVARIANCEP
@IsNotMember@UserNameLanguage[DesignHelpUsingDocument]=COVARIANCES
@IsNull@V2If[DesignIcon]=CRITBINOM
@IsNumber@V4UserAccess[DesignMacros]=CSC
@IsText@ValidateInternetAddress[DesignRefresh]=CSCH
@IsTime@VerifyPassword[DesignReplace]=CUMIPMT
@IsUnavailable1@Version[DesignSharedFields]=CUMPRINC
@Keywords@ViewShowThisUnread[DesignSynopsis]=DATE
@LanguagePreference1@ViewTitle[DesignViewAppendColumn]=DATEDIF
@Left@WebDbName[DesignViewAttributes]=DATEVALUE
@LeftBack@WhichFolders[DesignViewColumnDef]=DAVERAGE
@Length@While[DesignViewEditActions]=DAY
@Like[DesignViewFormFormula]=DAYS
@Ln[DesignViewNewColumn]=DAYS360
@Locale[DesignViews]=DB
@Log[DesignViewSelectFormula]=DCOUNT
@LowerCase[DialingRules]=DCOUNTA
@Matches[Directories]=DDB
@Max[DiscoverFolders]=DEC2BIN
@Member[EditBottom]=DEC2HEX
@Middle[EditButton]=DEC2OCT
@MiddleBack[EditClear]=DECIMAL
@Min[EditCopy]=DEGREES
@Minute[EditCut]=DELTA
@Modified1[EditDeselectAll]=DEVSQ
@Modulo[EditDetach]=DGET
@Month[EditDocument]=DISC
@Name1[EditDown]=DIVIDE
@Narrow[EditEncryptionKeys]=DMAX
@NewLine[EditFind]=DMIN
@No[EditFindInPreview]=DOLLAR
@NotesError[EditFindNext]=DOLLARDE
@Nothing[EditGotoField]=DOLLARFR
@Now[EditHeaderFooter]=DPRODUCT
@Pi[EditHorizScrollbar]=DSTDEV
@Power[EditIndent]=DSTDEVP
@Prompt[EditIndentFirstLine]=DSUM
@ProperCase[EditInsertButton]=DVAR
@Random[EditInsertFileAttachment]=DVARP
@Repeat[EditInsertObject]=E
@Replace[EditInsertPageBreak]=EDATE
@ReplaceSubstring[EditInsertPopup]=EFFECT
@Responses1[EditInsertSignature]=EOMONTH
@Return[EditInsertTable]=EQ
@Right[EditInsertText]=ERF
@RightBack[EditLeft]=ERFC
@Round[EditLinks]=EVEN
@Second[EditLocations]=EXACT
@Select[EditMakeDocLink]=EXP
@Set[EditNextField]=EXPONDIST
@setCurrentDocument1[EditOpenLink]=FACT
@SetDocField1[EditOwnerVCard]=FACTDOUBLE
@SetEnvironment[EditPaste]=FALSE
@SetField1[EditPasteSpecial]=FDIST
@Sign[EditPhoneNumbers]=FDISTRT
@Sin[EditPrevField]=FIND
@Sort[EditProfile]=FINV
@Sqrt[EditProfileDocument]=FINVRT
@Subset[EditQuoteSelection]=FISHER
@Success[EditResizePicture]=FISHERINV
@Sum[EditRestoreDocument]=FIXED
@Tan[EditRight]=FLOOR
@Text[EditSelectAll]=FLOORMATH
@TextToNumber[EditSelectByDate]=FLOORPRECISE
@TextToTime[EditShowHideHiddenChars]=FORECAST
@ThisName1[EditTableDeleteRowColumn]=FREQUENCY
@ThisValue1[EditTableFormat]=FTEST
@Time[EditTableInsertRowColumn]=FV
@TimeMerge[EditTop]=FVSCHEDULE
@TimeToTextInZone[EditUndo]=GAMMA
@TimeZoneToText[EditUntruncate]=GAMMADIST
@Today[EditUp]=GAMMAINV
@Tomorrow[ExchangeUnreadMarks]=GAMMALN
@ToNumber[Execute]=GAMMALNPRECISE
@ToTime[ExitNotes]=GAUSS
@Transform[FileDatabaseACL]=GCD
@Trim[FileDatabaseCompact]=GEOMEAN
@True[FileDatabaseCopy]=GESTEP
@Unique[FileDatabaseDelete]=GROWTH
@UpperCase[FileDatabaseInfo]=GT
@UserName1[FileDatabaseRemove]=GTE
@V3UserName1[FileDatabaseUseServer]=HARMEAN
@Weekday[FileExit]=HEX2BIN
@Wide[FileExport]=HEX2DEC
@Word[FileFullTextCreate]=HEX2OCT
@Year[FileFullTextDelete]=HLOOKUP
@Yes[FileFullTextInfo]=HOUR
@Yesterday[FileFullTextUpdate]=HYPGEOMDIST
@Zone[FileImport]=IF
[FileNewDatabase]=IFERROR
[FileNewReplica]=IFNA
[FileOpenDBRepID]=IFS
[FilePageSetup]=IMABS
[FilePrintSetup]=IMAGINARY
[FileSaveNewVersion]=IMARGUMENT
[Folder]=IMCONJUGATE
[FolderCollapse]=IMCOS
[FolderCustomize]=IMCOSH
[FolderDocuments]=IMCOT
[FolderExpand]=IMCSC
[FolderExpandAll]=IMCSCH
[FolderExpandWithChildren]=IMDIV
[FolderMove]=IMEXP
[FolderProperties]=IMLN
[FolderRename]=IMLOG10
[FormActions]=IMLOG2
[FormTestDocument]=IMPOWER
[GoUpLevel]=IMPRODUCT
[HelpAboutDatabase]=IMREAL
[HelpAboutNotes]=IMSEC
[HelpUsingDatabase]=IMSECH
[HotspotClear]=IMSIN
[HotspotProperties]=IMSINH
[InsertSubform]=IMSQRT
[LayoutAddGraphic]=IMSUB
[LayoutAddText]=IMSUM
[LayoutElementBringToFront]=IMTAN
[LayoutElementProperties]=INDEX
[LayoutElementSendToBack]=INT
[LayoutProperties]=INTERCEPT
[MailAddress]=INTERVAL
[MailComposeMemo]=IPMT
[MailForward]=IRR
[MailForwardAsAttachment]=ISBLANK
[MailOpen]=ISERR
[MailRequestCrossCert]=ISERROR
[MailRequestNewName]=ISEVEN
[MailRequestNewPublicKey]=ISLOGICAL
[MailScanUnread]=ISNA
[MailSendCertificateRequest]=ISNONTEXT
[MailSendEncryptionKey]=ISNUMBER
[MailSendPublicKey]=ISODD
[NavigateNext]=ISOWEEKNUM
[NavigateNextHighlight]=ISPMT
[NavigateNextMain]=ISTEXT
[NavigateNextSelected]=KURT
[NavigateNextUnread]=LARGE
[NavigatePrev]=LCM
[NavigatePrevHighlight]=LEFT
[NavigatePrevMain]=LEN
[NavigatePrevSelected]=LINEST
[NavigatePrevUnread]=LN
[NavigateToBacklink]=LN10
[NavigatorProperties]=LN2
[NavigatorTest]=LOG
[NavNext]=LOG10
[NavNextMain]=LOG10E
[NavNextSelected]=LOG2E
[NavNextUnread]=LOGEST
[NavPrev]=LOGINV
[NavPrevMain]=LOGNORMDIST
[NavPrevSelected]=LOGNORMINV
[NavPrevUnread]=LOOKUP
[ObjectDisplayAs]=LOWER
[ObjectOpen]=LT
[ObjectProperties]=LTE
[OpenCalendar]=MATCH
[OpenFrameset]=MAX
[OpenHelpDocument]=MAXA
[OpenNavigator]=MEDIAN
[OpenPage]=MID
[PasteBitmapAsBackground]=MIN
[PasteBitmapAsObject]=MINA
[PictureProperties]=MINUS
[PublishDatabase]=MINUTE
[RefreshFrame]=MIRR
[RefreshHideFormulas]=MOD
[RefreshParentNote]=MODE
[RemoteDebugLotusScript]=MODEMULT
[RenameDatabase]=MODESNGL
[Replicator]=MONTH
[ReplicatorReplicateHigh]=MROUND
[ReplicatorReplicateNext]=MULTINOMIAL
[ReplicatorReplicateSelected]=MULTIPLY
[ReplicatorReplicateWithServer]=N
[ReplicatorSendMail]=NA
[ReplicatorSendReceiveMail]=NE
[ReplicatorStart]=NEGBINOMDIST
[ReplicatorStop]=NETWORKDAYS
[SectionCollapse]=NETWORKDAYSINTL
[SectionCollapseAll]=NOMINAL
[SectionDefineEditors]=NORMDIST
[SectionExpand]=NORMINV
[SectionExpandAll]=NORMSDIST
[SectionProperties]=NORMSINV
[SectionRemoveHeader]=NOT
[SetCurrentLocation]=NOW
[ShowHideIMContactList]=NPER
[ShowHideLinkPreview]=NPV
[ShowHideParentPreview]=NUMBERVALUE
[ShowHidePreviewPane]=OCT2BIN
[ShowProperties]=OCT2DEC
[SmartIconsFloating]=OCT2HEX
[SmartIconsNextSet]=ODD
[StyleCycleKey]=OR
[SwitchForm]=PDURATION
[SwitchView]=PEARSON
[TextAlignCenter]=PERCENTILE
[TextAlignFull]=PERCENTILEEXC
[TextAlignLeft]=PERCENTILEINC
[TextAlignNone]=PERCENTRANK
[TextAlignRight]=PERCENTRANKEXC
[TextBold]=PERCENTRANKINC
[TextBullet]=PERMUT
[TextCycleSpacing]=PERMUTATIONA
[TextEnlargeFont]=PHI
[TextFont]=PI
[TextItalic]=PMT
[TextNormal]=POISSON
[TextNumbers]=POISSONDIST
[TextOutdent]=POW
[TextParagraph]=POWER
[TextParagraphStyles]=PPMT
[TextPermanentPen]=PRICEDISC
[TextReduceFont]=PROB
[TextSetFontColor]=PRODUCT
[TextSetFontFace]=PROPER
[TextSetFontSize]=PV
[TextSpacingDouble]=QUARTILE
[TextSpacingOneAndAHalf]=QUARTILEEXC
[TextSpacingSingle]=QUARTILEINC
[TextUnderline]=QUOTIENT
[ToolsCall]=RADIANS
[ToolsCategorize]=RAND
[ToolsHangUp]=RANDBETWEEN
[ToolsMarkAllRead]=RANK
[ToolsMarkAllUnread]=RANKAVG
[ToolsMarkSelectedRead]=RANKEQ
[ToolsMarkSelectedUnread]=RATE
[ToolsRefreshAllDocs]=REPLACE
[ToolsRefreshSelectedDocs]=REPT
[ToolsReplicate]=RIGHT
[ToolsScanUnreadChoose]=ROMAN
[ToolsScanUnreadPreferred]=ROUND
[ToolsScanUnreadSelected]=ROUNDDOWN
[ToolsSetupLocation]=ROUNDUP
[ToolsSetupMail]=ROW
[ToolsSetupPorts]=ROWS
[ToolsSetupUserSetup]=RRI
[ToolsSmartIcons]=RSQ
[ToolsSpellCheck]=SEARCH
[ToolsUserLogoff]=SEC
[UserIDCertificates]=SECH
[UserIDClearPassword]=SECOND
[UserIDCreateSafeCopy]=SERIESSUM
[UserIDEncryptionKeys]=SIGN
[UserIDInfo]=SIN
[UserIDMergeCopy]=SINH
[UserIDSetPassword]=SKEW
[UserIDSwitch]=SKEWP
[V3EditNextField]=SLN
[V3EditPrevField]=SLOPE
[ViewArrangeIcons]=SMALL
[ViewBelowFolders]=SQRT
[ViewBesideFolders]=SQRTPI
[ViewCertify]=STANDARDIZE
[ViewChange]=STDEV
[ViewCollapse]=STDEVA
[ViewCollapseAll]=STDEVP
[ViewExpand]=STDEVPA
[ViewExpandAll]=STDEVS
[ViewExpandWithChildren]=STEYX
[ViewHorizScrollBar]=SUBSTITUTE
[ViewMoveName]=SUBTOTAL
[ViewNavigatorsFolders]=SUM
[ViewNavigatorsNone]=SUMIF
[ViewRefreshUnread]=SUMIFS
[ViewRenamePerson]=SUMPRODUCT
[ViewShowFieldHelp]=SUMSQ
[ViewShowObject]=SUMX2MY2
[ViewShowOnlyCategories]=SUMX2PY2
[ViewShowOnlySearchResults]=SUMXMY2
[ViewShowOnlySelected]=SWITCH
[ViewShowOnlyUnread]=SYD
[ViewShowPageBreaks]=T
[ViewShowRuler]=TAN
[ViewShowSearchBar]=TANH
[ViewShowServerNames]=TBILLEQ
[ViewShowUnread]=TBILLPRICE
[ViewSwitchForm]=TBILLYIELD
[WindowCascade]=TDIST
[WindowMaximizeAll]=TDIST2T
[WindowMinimizeAll]=TDISTRT
[WindowNext]=TEXT
[WindowRestore]=TEXTJOIN
[WindowWorkspace]=TIME
[WorkspaceProperties]=TIMEVALUE
[WorkspaceStackReplicaIcons]=TINV
[ZoomPreview]=TINV2T
=TODAY
=TRANSPOSE
=TREND
=TRIM
=TRIMMEAN
=TRUE
=TRUNC
=TTEST
=TYPE
=UNICHAR
=UNICODE
=UNIQUE
=UPPER
=VALUE
=VAR
=VARA
=VARP
=VARPA
=VLOOKUP
=WEEKDAY
=WEEKNUM
=WEIBULL
=WEIBULLDIST
=WORKDAY
=WORKDAYINTL
=XIRR
=XNPV
=XOR
=YEAR
=YEARFRAC
=ZTEST