Notes Formula and OpenFormula function implementations as Rosetta APIs as of Volt MX Go 2.1 release
Notes:
1 - Implemented at the VoltMX data framework layer.
Notes @Formula Language OpenFormula (Excel)
FunctionsCommands
154 Implemented30 To Be Implemented85 No Plans To Implement 12 Implemented15 To Be Implemented362 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[OpenDocument]1[MoveToTrash][AdminCrossCertifyIDFile]=ADD=COUPDAYSNC
@Ascii@DocFields@DbCommand[OpenInNewWindow][RefreshWindow][AdminCrossCertifyKey]=AGGREGATE=COUPNCD
@ASin@Domain@DbExists[OpenView]1[RemoveFromFolder][AdminDatabaseAnalysis]=AND=COUPNUM
@ATan@GetHTTPHeader@DbManager[ReloadWindow][RunAgent][AdminDatabaseQuotas]=ARABIC=COUPPCD
@ATan2@HardDeleteDocument@DbName[WindowMaximize][RunScheduledAgents][AdminIDFileClearPassword]=ASIN=DBCS
@AttachmentNames@IsAgentEnabled@DbTitle[WindowMinimize][SendInstantMessage][AdminIDFileExamine]=ASINH=DURATION
@Attachments@IsValid@DDEExecute[ToolsRunBackgroundMacros][AdminIDFileSetPassword]=ATAN=ERFCPRECISE
@Author@LDAPServer@DDEInitiate[ToolsRunMacro][Administration]=ATAN2=ERFPRECISE
@Begins@NameLookup@DDEPoke[ViewRefreshFields][AdminNewOrganization]=ATANH=INTRATE
@BusinessDays@PickList@DDETerminate[AdminNewOrgUnit]=AVEDEV=MDURATION
@Char@SetHTTPHeader@Do[AdminOpenAddressBook]=AVERAGE=ODDFPRICE
@Command1@Soundex@DocLength[AdminOpenCatalog]=AVERAGEA=ODDFYIELD
@Compare@StatusBar@DocLock[AdminOpenCertLog]=AVERAGEIF=ODDLPRICE
@Contains@UndeleteDocument@DocMark[AdminOpenGroupsView]=AVERAGEIFS=ODDLYIELD
@Context@URLDecode@DocOmmittedLength[AdminOpenServerLog]=BASE=PRICE
@Cos@URLEncode@DoWhile[AdminOpenServersView]=BESSELI=PRICEMAT
@Count@URLGetHeader@EditECL[AdminOpenStatistics]=BESSELJ=PRONETIC
@Created1@URLHistory@EditUserECL[AdminOpenUsersView]=BESSELK=RECEIVED
@date@URLOpen@EnableAlarms[AdminOutgoingMail]=BESSELY=VDB
@Day@UrlQueryString@FontList[AdminRegisterFromFile]=BETADIST=YIELD
@DbColumn1@UserAccess@For[AdminRegisterServer]=BETAINV=YIELDDISC
@DbLookup1@UserNamesList@FormLanguage[AdminRegisterUser]=BIN2DEC=YIELDMAT
@Debug@UserPrivileges@GetAddressBooks[AdminRemoteConsole]=BIN2HEX
@DeleteDocument@UserRoles@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
@FileDir@IsModalHelp[CreateEllipse]=CODE
@FloatEq@IsUsingJavaElement[CreateFolder]=COLUMN
@GetCurrentTimeZone@IsVirtualizedDirectory[CreateForm]=COLUMNS
@GetDocField1@LaunchApp[CreateLayoutRegion]=COMBIN
@GetField@MailDbName[CreateNavigator]=COMBINA
@GetFieldType@MailEncryptSavedPreference[CreatePolygon]=COMPLEX
@HashPassword@MailEncryptSentPreference[CreatePolyline]=CONCAT
@Hour@MailSavePreference[CreateRectangle]=CONCATENATE
@IfError@MailSignPreference[CreateRectangularHotspot]=CONFIDENCE
@Implode@NoteID[CreateSection]=CONVERT
@Integer@OptimizeMailAddress[CreateSubform]=CORREL
@IsAvailable@OrgDir[CreateTextbox]=COS
@IsCategory@Password[CreateView]=COSH
@IsError@PasswordQuality[DatabaseDelete]=COT
@IsMember@PolicyIsFieldLocked[DatabaseReplSettings]=COTH
@IsNewDoc@PostedCommand[DebugLotusScript]=COUNT
@IsNotMember@RefreshECL[DesignDocumentInfo]=COUNTA
@IsNull@RegQueryValue[DesignFormAttributes]=COUNTBLANK
@IsNumber@ReplicaID[DesignFormFieldDef]=COUNTIF
@IsResponseDoc@ServerAccess[DesignFormNewField]=COUNTIFS
@IsText@ServerName[DesignForms]=COUNTIN
@IsTime@SetProfileField[DesignFormShareField]=COUNTUNIQUE
@IsUnavailable@SetTargetFrame[DesignFormUseField]=COUPDAYS
@Keywords@SetViewInfo[DesignFormWindowTitle]=COVAR
@LanguagePreference@ShowParentPreview[DesignHelpAboutDocument]=COVARIANCEP
@Left@TemplateVersion[DesignHelpUsingDocument]=COVARIANCES
@LeftBack@Unavailable[DesignIcon]=CRITBINOM
@Length@UserNameLanguage[DesignMacros]=CSC
@Like@V2If[DesignRefresh]=CSCH
@Ln@V4UserAccess[DesignReplace]=CUMIPMT
@Locale@ValidateInternetAddress[DesignSharedFields]=CUMPRINC
@Log@VerifyPassword[DesignSynopsis]=DATE
@LowerCase@Version[DesignViewAppendColumn]=DATEDIF
@Matches@ViewShowThisUnread[DesignViewAttributes]=DATEVALUE
@Max@ViewTitle[DesignViewColumnDef]=DAVERAGE
@Member@WebDbName[DesignViewEditActions]=DAY
@Middle@WhichFolders[DesignViewFormFormula]=DAYS
@MiddleBack@While[DesignViewNewColumn]=DAYS360
@Min[DesignViews]=DB
@Minute[DesignViewSelectFormula]=DCOUNT
@Modified1[DialingRules]=DCOUNTA
@Modulo[Directories]=DDB
@Month[DiscoverFolders]=DEC2BIN
@Name[EditBottom]=DEC2HEX
@Narrow[EditButton]=DEC2OCT
@NewLine[EditClear]=DECIMAL
@No[EditCopy]=DEGREES
@NotesError[EditCut]=DELTA
@Nothing[EditDeselectAll]=DEVSQ
@Now[EditDetach]=DGET
@Pi[EditDocument]=DISC
@Platform[EditDown]=DIVIDE
@Power[EditEncryptionKeys]=DMAX
@Prompt[EditFind]=DMIN
@ProperCase[EditFindInPreview]=DOLLAR
@Random[EditFindNext]=DOLLARDE
@Repeat[EditGotoField]=DOLLARFR
@Replace[EditHeaderFooter]=DPRODUCT
@ReplaceSubstring[EditHorizScrollbar]=DSTDEV
@Responses[EditIndent]=DSTDEVP
@Return[EditIndentFirstLine]=DSUM
@Right[EditInsertButton]=DVAR
@RightBack[EditInsertFileAttachment]=DVARP
@Round[EditInsertObject]=E
@Second[EditInsertPageBreak]=EDATE
@Select[EditInsertPopup]=EFFECT
@SelectDocuments1[EditInsertSignature]=EOMONTH
@Set[EditInsertTable]=EQ
@SetDocField1[EditInsertText]=ERF
@SetEnvironment[EditLeft]=ERFC
@SetField[EditLinks]=EVEN
@Sign[EditLocations]=EXACT
@Sin[EditMakeDocLink]=EXP
@Sort[EditNextField]=EXPONDIST
@Sqrt[EditOpenLink]=FACT
@Subset[EditOwnerVCard]=FACTDOUBLE
@Success[EditPaste]=FALSE
@Sum[EditPasteSpecial]=FDIST
@Tan[EditPhoneNumbers]=FDISTRT
@Text[EditPrevField]=FIND
@TextToNumber[EditProfile]=FINV
@TextToTime[EditProfileDocument]=FINVRT
@ThisName[EditQuoteSelection]=FISHER
@ThisValue[EditResizePicture]=FISHERINV
@Time[EditRestoreDocument]=FIXED
@TimeMerge[EditRight]=FLOOR
@TimeToTextInZone[EditSelectAll]=FLOORMATH
@TimeZoneToText[EditSelectByDate]=FLOORPRECISE
@Today[EditShowHideHiddenChars]=FORECAST
@Tomorrow[EditTableDeleteRowColumn]=FREQUENCY
@ToNumber[EditTableFormat]=FTEST
@ToTime[EditTableInsertRowColumn]=FV
@Transform[EditTop]=FVSCHEDULE
@Trim[EditUndo]=GAMMA
@True[EditUntruncate]=GAMMADIST
@Unique[EditUp]=GAMMAINV
@UpdateFormulaContext1[ExchangeUnreadMarks]=GAMMALN
@UpperCase[Execute]=GAMMALNPRECISE
@UserName[ExitNotes]=GAUSS
@V3UserName[FileDatabaseACL]=GCD
@Weekday[FileDatabaseCompact]=GEOMEAN
@Wide[FileDatabaseCopy]=GESTEP
@Word[FileDatabaseDelete]=GROWTH
@Year[FileDatabaseInfo]=GT
@Yes[FileDatabaseRemove]=GTE
@Yesterday[FileDatabaseUseServer]=HARMEAN
@Zone[FileExit]=HEX2BIN
[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
[MailSend]=ISNONTEXT
[MailSendCertificateRequest]=ISNUMBER
[MailSendEncryptionKey]=ISODD
[MailSendPublicKey]=ISOWEEKNUM
[NavigateNext]=ISPMT
[NavigateNextHighlight]=ISTEXT
[NavigateNextMain]=KURT
[NavigateNextSelected]=LARGE
[NavigateNextUnread]=LCM
[NavigatePrev]=LEFT
[NavigatePrevHighlight]=LEN
[NavigatePrevMain]=LINEST
[NavigatePrevSelected]=LN
[NavigatePrevUnread]=LN10
[NavigateToBacklink]=LN2
[NavigatorProperties]=LOG
[NavigatorTest]=LOG10
[NavNext]=LOG10E
[NavNextMain]=LOG2E
[NavNextSelected]=LOGEST
[NavNextUnread]=LOGINV
[NavPrev]=LOGNORMDIST
[NavPrevMain]=LOGNORMINV
[NavPrevSelected]=LOOKUP
[NavPrevUnread]=LOWER
[ObjectDisplayAs]=LT
[ObjectOpen]=LTE
[ObjectProperties]=MATCH
[OpenCalendar]=MAX
[OpenFrameset]=MAXA
[OpenHelpDocument]=MEDIAN
[OpenNavigator]=MID
[OpenPage]=MIN
[PasteBitmapAsBackground]=MINA
[PasteBitmapAsObject]=MINUS
[PictureProperties]=MINUTE
[PublishDatabase]=MIRR
[RefreshFrame]=MOD
[RefreshHideFormulas]=MODE
[RefreshParentNote]=MODEMULT
[RemoteDebugLotusScript]=MODESNGL
[RenameDatabase]=MONTH
[Replicator]=MROUND
[ReplicatorReplicateHigh]=MULTINOMIAL
[ReplicatorReplicateNext]=MULTIPLY
[ReplicatorReplicateSelected]=N
[ReplicatorReplicateWithServer]=NA
[ReplicatorSendMail]=NE
[ReplicatorSendReceiveMail]=NEGBINOMDIST
[ReplicatorStart]=NETWORKDAYS
[ReplicatorStop]=NETWORKDAYSINTL
[SectionCollapse]=NOMINAL
[SectionCollapseAll]=NORMDIST
[SectionDefineEditors]=NORMINV
[SectionExpand]=NORMSDIST
[SectionExpandAll]=NORMSINV
[SectionProperties]=NOT
[SectionRemoveHeader]=NOW
[SetCurrentLocation]=NPER
[ShowHideIMContactList]=NPV
[ShowHideLinkPreview]=NUMBERVALUE
[ShowHideParentPreview]=OCT2BIN
[ShowHidePreviewPane]=OCT2DEC
[ShowProperties]=OCT2HEX
[SmartIconsFloating]=ODD
[SmartIconsNextSet]=OR
[StyleCycleKey]=PDURATION
[SwitchForm]=PEARSON
[SwitchView]=PERCENTILE
[TextAlignCenter]=PERCENTILEEXC
[TextAlignFull]=PERCENTILEINC
[TextAlignLeft]=PERCENTRANK
[TextAlignNone]=PERCENTRANKEXC
[TextAlignRight]=PERCENTRANKINC
[TextBold]=PERMUT
[TextBullet]=PERMUTATIONA
[TextCycleSpacing]=PHI
[TextEnlargeFont]=PI
[TextFont]=PMT
[TextItalic]=POISSON
[TextNormal]=POISSONDIST
[TextNumbers]=POW
[TextOutdent]=POWER
[TextParagraph]=PPMT
[TextParagraphStyles]=PRICEDISC
[TextPermanentPen]=PROB
[TextReduceFont]=PRODUCT
[TextSetFontColor]=PROPER
[TextSetFontFace]=PV
[TextSetFontSize]=QUARTILE
[TextSpacingDouble]=QUARTILEEXC
[TextSpacingOneAndAHalf]=QUARTILEINC
[TextSpacingSingle]=QUOTIENT
[TextUnderline]=RADIANS
[ToolsCall]=RAND
[ToolsCategorize]=RANDBETWEEN
[ToolsHangUp]=RANK
[ToolsMarkAllRead]=RANKAVG
[ToolsMarkAllUnread]=RANKEQ
[ToolsMarkSelectedRead]=RATE
[ToolsMarkSelectedUnread]=REPLACE
[ToolsRefreshAllDocs]=REPT
[ToolsRefreshSelectedDocs]=RIGHT
[ToolsReplicate]=ROMAN
[ToolsScanUnreadChoose]=ROUND
[ToolsScanUnreadPreferred]=ROUNDDOWN
[ToolsScanUnreadSelected]=ROUNDUP
[ToolsSetupLocation]=ROW
[ToolsSetupMail]=ROWS
[ToolsSetupPorts]=RRI
[ToolsSetupUserSetup]=RSQ
[ToolsSmartIcons]=SEARCH
[ToolsSpellCheck]=SEC
[ToolsUserLogoff]=SECH
[UserIDCertificates]=SECOND
[UserIDClearPassword]=SERIESSUM
[UserIDCreateSafeCopy]=SIGN
[UserIDEncryptionKeys]=SIN
[UserIDInfo]=SINH
[UserIDMergeCopy]=SKEW
[UserIDSetPassword]=SKEWP
[UserIDSwitch]=SLN
[V3EditNextField]=SLOPE
[V3EditPrevField]=SMALL
[ViewArrangeIcons]=SQRT
[ViewBelowFolders]=SQRTPI
[ViewBesideFolders]=STANDARDIZE
[ViewCertify]=STDEV
[ViewChange]=STDEVA
[ViewCollapse]=STDEVP
[ViewCollapseAll]=STDEVPA
[ViewExpand]=STDEVS
[ViewExpandAll]=STEYX
[ViewExpandWithChildren]=SUBSTITUTE
[ViewHorizScrollBar]=SUBTOTAL
[ViewMoveName]=SUM
[ViewNavigatorsFolders]=SUMIF
[ViewNavigatorsNone]=SUMIFS
[ViewRefreshUnread]=SUMPRODUCT
[ViewRenamePerson]=SUMSQ
[ViewShowFieldHelp]=SUMX2MY2
[ViewShowObject]=SUMX2PY2
[ViewShowOnlyCategories]=SUMXMY2
[ViewShowOnlySearchResults]=SWITCH
[ViewShowOnlySelected]=SYD
[ViewShowOnlyUnread]=T
[ViewShowPageBreaks]=TAN
[ViewShowRuler]=TANH
[ViewShowSearchBar]=TBILLEQ
[ViewShowServerNames]=TBILLPRICE
[ViewShowUnread]=TBILLYIELD
[ViewSwitchForm]=TDIST
[WindowCascade]=TDIST2T
[WindowMaximizeAll]=TDISTRT
[WindowMinimizeAll]=TEXT
[WindowNext]=TEXTJOIN
[WindowRestore]=TIME
[WindowTile]=TIMEVALUE
[WindowWorkspace]=TINV
[WorkspaceProperties]=TINV2T
[WorkspaceStackReplicaIcons]=TODAY
[ZoomPreview]=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