Notes Formula and OpenFormula function implementations as Rosetta APIs as of Volt MX Go 2.0.4 release.
Notes:
1 - Implemented at the VoltMX data framework layer.
Notes @Formula Language OpenFormula (Excel)
FunctionsCommands
163 Implemented34 To Be Implemented84 No Plans To Implement 11 Implemented18 To Be Implemented360 No Plans To Implement 391 Implemented28 To Be Implemented6 No Plans To Implement
@Abs@AddToFolder@Abstract[CloseWindow]1[AgentEnableDisable][AddBookmark]=ABS=ACCRINTM=CELL
@AbstractSimple@AdminECLIsLocked@Accessed[Compose]1[AgentRun][AddDatabase]=ACCRINT=AMORDEGRC=INFO
@ACos@AttachmentLengths@Certificate[FileCloseWindow]1[AttachmentDetachAll][AddDatabaseRepID]=ACOS=AMORLINC=ISFORMULA
@Adjust@AttachmentModifiedTimes@CheckAlarms[FileOpenDatabase]1[AttachmentLaunch][AddToIMContactList]=ACOSH=ASC=ISREF
@All1@BrowserInfo@CheckCalendar[FilePrint]1[EmptyTrash][AdminCertify]=ACOT=BAHTTEXT=SHEET
@AllChildren1@CheckFormulaSyntax@ConfigFile[FileSave]1[FindFreeTimeDialog][AdminCreateGroup]=ACOTH=COUPDAYBS=SHEETS
@AllDescendants1@ClientType@DB2Schema[OpenDocument]1[MailSend][AdminCrossCertifyIDFile]=ADD=COUPDAYSNC
@Ascii@DeleteDocument@DbCommand[OpenView]1[MoveToTrash][AdminCrossCertifyKey]=AGGREGATE=COUPNCD
@ASin@DialogBox@DbExists[ReloadWindow]1[OpenInNewWindow][AdminDatabaseAnalysis]=AND=COUPNUM
@ATan@DocFields@DbManager[WindowMaximize][RefreshWindow][AdminDatabaseQuotas]=ARABIC=COUPPCD
@ATan2@Domain@DbName[WindowMinimize][RemoveFromFolder][AdminIDFileClearPassword]=ASIN=DBCS
@AttachmentNames1@GetHTTPHeader@DbTitle[RunAgent][AdminIDFileExamine]=ASINH=DURATION
@Attachments1@HardDeleteDocument@DDEExecute[RunScheduledAgents][AdminIDFileSetPassword]=ATAN=ERFCPRECISE
@Author1@HashPassword@DDEInitiate[SendInstantMessage][Administration]=ATAN2=ERFPRECISE
@Begins@IsAgentEnabled@DDEPoke[ToolsRunBackgroundMacros][AdminNewOrganization]=ATANH=INTRATE
@BusinessDays@IsValid@DDETerminate[ToolsRunMacro][AdminNewOrgUnit]=AVEDEV=MDURATION
@Char@LDAPServer@Do[ViewRefreshFields][AdminOpenAddressBook]=AVERAGE=ODDFPRICE
@clearCache1@NameLookup@DocLength[WindowTile][AdminOpenCatalog]=AVERAGEA=ODDFYIELD
@Command1@PickList@DocLock[AdminOpenCertLog]=AVERAGEIF=ODDLPRICE
@Compare@Platform@DocMark[AdminOpenGroupsView]=AVERAGEIFS=ODDLYIELD
@Contains@SetHTTPHeader@DocOmmittedLength[AdminOpenServerLog]=BASE=PRICE
@Context@Soundex@DoWhile[AdminOpenServersView]=BESSELI=PRICEMAT
@Cos@StatusBar@EditECL[AdminOpenStatistics]=BESSELJ=PRONETIC
@Count@UndeleteDocument@EditUserECL[AdminOpenUsersView]=BESSELK=RECEIVED
@Created1@URLDecode@EnableAlarms[AdminOutgoingMail]=BESSELY=VDB
@date@URLEncode@FontList[AdminRegisterFromFile]=BETADIST=YIELD
@Day@URLGetHeader@For[AdminRegisterServer]=BETAINV=YIELDDISC
@DbColumn1@URLHistory@FormLanguage[AdminRegisterUser]=BIN2DEC=YIELDMAT
@DbLookup1@URLOpen@GetAddressBooks[AdminRemoteConsole]=BIN2HEX
@Debug@UrlQueryString@GetFocusTable[AdminSendMailTrace]=BIN2OCT
@DeleteField1@UserAccess@GetIMContactListGroupNames[AdminStatisticsConfig]=BINOMDIST
@DocChildren1@UserNamesList@GetPortsList[AdminTraceConnection]=BITAND
@DocDescendants1@UserPrivileges@GetProfileField[AgentEdit]=BITLSHIFT
@DocLevel1@UserRoles@GetViewInfo[AgentLog]=BITOR
@DocNumber1@InheritedDocumentUniqueID[AgentSetServerName]=BITRSHIFT
@DocParentNumber1@IsAppInstalled[AgentTestRun]=BITXOR
@DocSiblings1@IsDB2[AttachmentProperties]=CEILING
@documentSave1@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@Password[CreateTextbox]=COS
@getObjectMetadata1@PasswordQuality[CreateView]=COSH
@getServiceEntry1@PolicyIsFieldLocked[DatabaseDelete]=COT
@getServiceName1@PostedCommand[DatabaseReplSettings]=COTH
@getServiceObject1@RefreshECL[DebugLotusScript]=COUNT
@Hour@RegQueryValue[DesignDocumentInfo]=COUNTA
@If@ReplicaID[DesignFormAttributes]=COUNTBLANK
@IfError@ServerAccess[DesignFormFieldDef]=COUNTIF
@Implode@ServerName[DesignFormNewField]=COUNTIFS
@Integer@SetProfileField[DesignForms]=COUNTIN
@IsAvailable1@SetTargetFrame[DesignFormShareField]=COUNTUNIQUE
@IsCategory1@SetViewInfo[DesignFormUseField]=COUPDAYS
@IsError@ShowParentPreview[DesignFormWindowTitle]=COVAR
@IsMember@TemplateVersion[DesignHelpAboutDocument]=COVARIANCEP
@IsNewDoc1@Unavailable[DesignHelpUsingDocument]=COVARIANCES
@IsNotMember@UserNameLanguage[DesignIcon]=CRITBINOM
@IsNull@V2If[DesignMacros]=CSC
@IsNumber@V4UserAccess[DesignRefresh]=CSCH
@IsResponseDoc1@ValidateInternetAddress[DesignReplace]=CUMIPMT
@IsText@VerifyPassword[DesignSharedFields]=CUMPRINC
@IsTime@Version[DesignSynopsis]=DATE
@IsUnavailable1@ViewShowThisUnread[DesignViewAppendColumn]=DATEDIF
@Keywords@ViewTitle[DesignViewAttributes]=DATEVALUE
@LanguagePreference1@WebDbName[DesignViewColumnDef]=DAVERAGE
@Left@WhichFolders[DesignViewEditActions]=DAY
@LeftBack@While[DesignViewFormFormula]=DAYS
@Length[DesignViewNewColumn]=DAYS360
@Like[DesignViews]=DB
@Ln[DesignViewSelectFormula]=DCOUNT
@Locale[DialingRules]=DCOUNTA
@Log[Directories]=DDB
@LowerCase[DiscoverFolders]=DEC2BIN
@Matches[EditBottom]=DEC2HEX
@Max[EditButton]=DEC2OCT
@Member[EditClear]=DECIMAL
@Middle[EditCopy]=DEGREES
@MiddleBack[EditCut]=DELTA
@Min[EditDeselectAll]=DEVSQ
@Minute[EditDetach]=DGET
@Modified1[EditDocument]=DISC
@Modulo[EditDown]=DIVIDE
@Month[EditEncryptionKeys]=DMAX
@Name1[EditFind]=DMIN
@Narrow[EditFindInPreview]=DOLLAR
@NewLine[EditFindNext]=DOLLARDE
@No[EditGotoField]=DOLLARFR
@NotesError[EditHeaderFooter]=DPRODUCT
@Nothing[EditHorizScrollbar]=DSTDEV
@Now[EditIndent]=DSTDEVP
@Pi[EditIndentFirstLine]=DSUM
@Power[EditInsertButton]=DVAR
@Prompt[EditInsertFileAttachment]=DVARP
@ProperCase[EditInsertObject]=E
@Random[EditInsertPageBreak]=EDATE
@Repeat[EditInsertPopup]=EFFECT
@Replace[EditInsertSignature]=EOMONTH
@ReplaceSubstring[EditInsertTable]=EQ
@Responses1[EditInsertText]=ERF
@Return[EditLeft]=ERFC
@Right[EditLinks]=EVEN
@RightBack[EditLocations]=EXACT
@Round[EditMakeDocLink]=EXP
@Second[EditNextField]=EXPONDIST
@Select[EditOpenLink]=FACT
@Set[EditOwnerVCard]=FACTDOUBLE
@setCurrentDocument1[EditPaste]=FALSE
@SetDocField1[EditPasteSpecial]=FDIST
@SetEnvironment[EditPhoneNumbers]=FDISTRT
@SetField1[EditPrevField]=FIND
@Sign[EditProfile]=FINV
@Sin[EditProfileDocument]=FINVRT
@Sort[EditQuoteSelection]=FISHER
@Sqrt[EditResizePicture]=FISHERINV
@Subset[EditRestoreDocument]=FIXED
@Success[EditRight]=FLOOR
@Sum[EditSelectAll]=FLOORMATH
@Tan[EditSelectByDate]=FLOORPRECISE
@Text[EditShowHideHiddenChars]=FORECAST
@TextToNumber[EditTableDeleteRowColumn]=FREQUENCY
@TextToTime[EditTableFormat]=FTEST
@ThisName1[EditTableInsertRowColumn]=FV
@ThisValue1[EditTop]=FVSCHEDULE
@Time[EditUndo]=GAMMA
@TimeMerge[EditUntruncate]=GAMMADIST
@TimeToTextInZone[EditUp]=GAMMAINV
@TimeZoneToText[ExchangeUnreadMarks]=GAMMALN
@Today[Execute]=GAMMALNPRECISE
@Tomorrow[ExitNotes]=GAUSS
@ToNumber[FileDatabaseACL]=GCD
@ToTime[FileDatabaseCompact]=GEOMEAN
@Transform[FileDatabaseCopy]=GESTEP
@Trim[FileDatabaseDelete]=GROWTH
@True[FileDatabaseInfo]=GT
@Unique[FileDatabaseRemove]=GTE
@UpdateFormulaContext1[FileDatabaseUseServer]=HARMEAN
@UpperCase[FileExit]=HEX2BIN
@UserName1[FileExport]=HEX2DEC
@V3UserName1[FileFullTextCreate]=HEX2OCT
@Weekday[FileFullTextDelete]=HLOOKUP
@Wide[FileFullTextInfo]=HOUR
@Word[FileFullTextUpdate]=HYPGEOMDIST
@Year[FileImport]=IF
@Yes[FileNewDatabase]=IFERROR
@Yesterday[FileNewReplica]=IFNA
@Zone[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