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