Notes Formula and OpenFormula function implementations as Rosetta APIs as of Volt MX Go v2.1.1 release
Notes:
1 - Implemented at the VoltMX data framework layer.
Notes @Formula Language OpenFormula (Excel)
FunctionsCommands
155 Implemented28 To Be Implemented87 No Plans To Implement 13 Implemented15 To Be Implemented361 No Plans To Implement 391 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]=DEC2BIN
@Month[EditBottom]=DEC2HEX
@Name[EditButton]=DEC2OCT
@Narrow[EditClear]=DECIMAL
@NewLine[EditCopy]=DEGREES
@No[EditCut]=DELTA
@NotesError[EditDeselectAll]=DEVSQ
@Nothing[EditDetach]=DGET
@Now[EditDocument]=DISC
@Pi[EditDown]=DIVIDE
@Platform[EditEncryptionKeys]=DMAX
@Power[EditFind]=DMIN
@Prompt[EditFindInPreview]=DOLLAR
@ProperCase[EditFindNext]=DOLLARDE
@Random[EditGotoField]=DOLLARFR
@Repeat[EditHeaderFooter]=DPRODUCT
@Replace[EditHorizScrollbar]=DSTDEV
@ReplaceSubstring[EditIndent]=DSTDEVP
@Responses[EditIndentFirstLine]=DSUM
@Return[EditInsertButton]=DVAR
@Right[EditInsertFileAttachment]=DVARP
@RightBack[EditInsertObject]=E
@Round[EditInsertPageBreak]=EDATE
@Second[EditInsertPopup]=EFFECT
@Select[EditInsertSignature]=EOMONTH
@SelectDocuments1[EditInsertTable]=EQ
@Set[EditInsertText]=ERF
@SetDocField1[EditLeft]=ERFC
@SetEnvironment[EditLinks]=EVEN
@SetField[EditLocations]=EXACT
@Sign[EditMakeDocLink]=EXP
@Sin[EditNextField]=EXPONDIST
@Sort[EditOpenLink]=FACT
@Sqrt[EditOwnerVCard]=FACTDOUBLE
@Subset[EditPaste]=FALSE
@Success[EditPasteSpecial]=FDIST
@Sum[EditPhoneNumbers]=FDISTRT
@Tan[EditPrevField]=FIND
@Text[EditProfile]=FINV
@TextToNumber[EditProfileDocument]=FINVRT
@TextToTime[EditQuoteSelection]=FISHER
@ThisName[EditResizePicture]=FISHERINV
@ThisValue[EditRestoreDocument]=FIXED
@Time[EditRight]=FLOOR
@TimeMerge[EditSelectAll]=FLOORMATH
@TimeToTextInZone[EditSelectByDate]=FLOORPRECISE
@TimeZoneToText[EditShowHideHiddenChars]=FORECAST
@Today[EditTableDeleteRowColumn]=FREQUENCY
@Tomorrow[EditTableFormat]=FTEST
@ToNumber[EditTableInsertRowColumn]=FV
@ToTime[EditTop]=FVSCHEDULE
@Transform[EditUndo]=GAMMA
@Trim[EditUntruncate]=GAMMADIST
@True[EditUp]=GAMMAINV
@Unique[ExchangeUnreadMarks]=GAMMALN
@UpdateFormulaContext1[Execute]=GAMMALNPRECISE
@UpperCase[ExitNotes]=GAUSS
@UserName[FileDatabaseACL]=GCD
@V3UserName[FileDatabaseCompact]=GEOMEAN
@Weekday[FileDatabaseCopy]=GESTEP
@Wide[FileDatabaseDelete]=GROWTH
@Word[FileDatabaseInfo]=GT
@Year[FileDatabaseRemove]=GTE
@Yes[FileDatabaseUseServer]=HARMEAN
@Yesterday[FileExit]=HEX2BIN
@Zone[FileExport]=HEX2DEC
[FileFullTextCreate]=HEX2OCT
[FileFullTextDelete]=HLOOKUP
[FileFullTextInfo]=HOUR
[FileFullTextUpdate]=HYPGEOMDIST
[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
[WindowTile]=TIME
[WindowWorkspace]=TIMEVALUE
[WorkspaceProperties]=TINV
[WorkspaceStackReplicaIcons]=TINV2T
[ZoomPreview]=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