The repository formulas provides access to the [[Invantive Control for Excel/Formulas/Repository/Repository|Repository]] of an Excel workbook with Invantive Control for Excel enabled. The repository formulas are always available, independent of the connected database. The following formulas are available: %% Begin Waypoint %% - [[I_BLK_ACTIVE]] - [[I_BLK_ALLOW_DELETE]] - [[I_BLK_ALLOW_INSERT]] - [[I_BLK_ALLOW_UPDATE]] - [[I_BLK_ANCHOR_OFFSET_X]] - [[I_BLK_ANCHOR_OFFSET_Y]] - [[I_BLK_ANCHOR_OFFSET_Z]] - [[I_BLK_ANCHOR_TO_CORNER]] - [[I_BLK_BORDER_WIDTH_BEHIND]] - [[I_BLK_BORDER_WIDTH_BOTTOM]] - [[I_BLK_BORDER_WIDTH_FRONT]] - [[I_BLK_BORDER_WIDTH_LEFT]] - [[I_BLK_BORDER_WIDTH_RIGHT]] - [[I_BLK_BORDER_WIDTH_TOP]] - [[I_BLK_COMMENT]] - [[I_BLK_CONSTRAIN_MAX_X]] - [[I_BLK_CONSTRAIN_MAX_Y]] - [[I_BLK_CONSTRAIN_MAX_Z]] - [[I_BLK_CONSTRAIN_MIN_X]] - [[I_BLK_CONSTRAIN_MIN_Y]] - [[I_BLK_CONSTRAIN_MIN_Z]] - [[I_BLK_CURRENT_MAX_X]] - [[I_BLK_CURRENT_MAX_Y]] - [[I_BLK_CURRENT_MAX_Z]] - [[I_BLK_CURRENT_MIN_X]] - [[I_BLK_CURRENT_MIN_Y]] - [[I_BLK_CURRENT_MIN_Z]] - [[I_BLK_DATE_FIRST_SYNCHRONIZATION]] - [[I_BLK_DATE_LAST_SYNCHRONIZATION]] - [[I_BLK_DOWNLOAD_ORDER]] - [[I_BLK_DOWNLOADS_LAST_MS]] - [[I_BLK_DOWNLOADS_MAX_MS]] - [[I_BLK_DOWNLOADS_MIN_MS]] - [[I_BLK_DOWNLOADS_SUCCESS_TOTAL_MS]] - [[I_BLK_DOWNLOADS_SUCCESS]] - [[I_BLK_DOWNLOADS_TOTAL_MS]] - [[I_BLK_DOWNLOADS_TOTAL]] - [[I_BLK_FIXED_POSITION]] - [[I_BLK_HAS_DONE_LAYOUT]] - [[I_BLK_ID_ANCHOR_TO]] - [[I_BLK_INSTEAD_OF_DELETE]] - [[I_BLK_INSTEAD_OF_INSERT]] - [[I_BLK_INSTEAD_OF_UPDATE]] - [[I_BLK_LABEL_PLURAL]] - [[I_BLK_LABEL_SINGULAR]] - [[I_BLK_LAST_TRANSACTION_SEEN]] - [[I_BLK_LAYOUT_RANGE]] - [[I_BLK_NAMED_RANGE_BORDER]] - [[I_BLK_NAMED_RANGE_DATA]] - [[I_BLK_ON_AFTER_DOWNLOAD]] - [[I_BLK_ON_AFTER_UPLOAD]] - [[I_BLK_ON_BEFORE_DOWNLOAD]] - [[I_BLK_ON_BEFORE_UPLOAD]] - [[I_BLK_PRIMARY_KEY_EXPRESSION_REAL_NAME]] - [[I_BLK_PRIMARY_KEY_EXPRESSION]] - [[I_BLK_REPEAT_COLUMNS_ALONG]] - [[I_BLK_REPEAT_COLUMNS_DIRECTION]] - [[I_BLK_REPEAT_ROWS_ALONG]] - [[I_BLK_REPEAT_ROWS_DIRECTION]] - [[I_BLK_ROWS_DOWNLOADED]] - [[I_BLK_ROWS_UPLOADED]] - [[I_BLK_SELECT_BUSINESS_OBJECT]] - [[I_BLK_SELECT_CLAUSE]] - [[I_BLK_SELECT_FILTER_CLAUSE]] - [[I_BLK_SELECT_ORDERING_CLAUSE]] - [[I_BLK_SQL_MODE]] - [[I_BLK_SQL_STATEMENT]] - [[I_BLK_START_POSITION_X]] - [[I_BLK_START_POSITION_Y]] - [[I_BLK_START_POSITION_Z]] - [[I_BLK_TRANSACTION_EXPRESSION_REAL_NAME]] - [[I_BLK_TRANSACTION_EXPRESSION]] - [[I_BLK_UPLOAD_ORDER]] - [[I_BLK_UPLOADS_LAST_MS]] - [[I_BLK_UPLOADS_MAX_MS]] - [[I_BLK_UPLOADS_MIN_MS]] - [[I_BLK_UPLOADS_SUCCESS_TOTAL_MS]] - [[I_BLK_UPLOADS_SUCCESS]] - [[I_BLK_UPLOADS_TOTAL_MS]] - [[I_BLK_UPLOADS_TOTAL]] - [[I_MDL_ALLOW_CHANGES_OUTSIDE_BLOCKS]] - [[I_MDL_ALREADY_ASKED_FOR_PARAMETERS]] - [[I_MDL_AUTHOR_CONTACT_DATA]] - [[I_MDL_AUTHOR]] - [[I_MDL_CODE]] - [[I_MDL_COMMENT 1]] - [[I_MDL_COMMENT]] - [[I_MDL_COMPANY]] - [[I_MDL_COPYRIGHT]] - [[I_MDL_DATE_LAST_DOWNLOADED]] - [[I_MDL_DATE_LAST_OPENED]] - [[I_MDL_DATE_LAST_UPDATED]] - [[I_MDL_DATE_LAST_UPLOADED]] - [[I_MDL_DESCRIPTION]] - [[I_MDL_INSTRUCTIONS]] - [[I_MDL_LAST_CONNECTION_NAME]] - [[I_MDL_LAST_OPENED_BY]] - [[I_MDL_LAST_OPENED_ON]] - [[I_MDL_LAST_UPDATED_BY]] - [[I_MDL_LAST_UPDATED_ON]] - [[I_MDL_LICENSE_BUILD_END_DATE]] - [[I_MDL_LICENSE_BUILD_START_DATE]] - [[I_MDL_LICENSE_END_DATE]] - [[I_MDL_LICENSE_LICENSE_CODES]] - [[I_MDL_LICENSE_NOTIFICATION]] - [[I_MDL_LICENSE_PATTERN_APPLICATION_LABEL]] - [[I_MDL_LICENSE_PATTERN_APPLICATION_USERS]] - [[I_MDL_LICENSE_PATTERN_APPLICATION_VERSION]] - [[I_MDL_LICENSE_PATTERN_IIID 1]] - [[I_MDL_LICENSE_PATTERN_MACHINE_NAME]] - [[I_MDL_LICENSE_PROVIDER]] - [[I_MDL_LICENSE_START_DATE]] - [[I_MDL_NAME]] - [[I_MDL_ON_AFTER_CONNECT_DATABASE]] - [[I_MDL_ON_AFTER_DOWNLOAD]] - [[I_MDL_ON_AFTER_OPEN_WORKBOOK]] - [[I_MDL_ON_AFTER_SYNC]] - [[I_MDL_ON_AFTER_UPLOAD]] - [[I_MDL_ON_BEFORE_CLOSE_WORKBOOK]] - [[I_MDL_ON_BEFORE_DOWNLOAD]] - [[I_MDL_ON_BEFORE_SYNC]] - [[I_MDL_ON_BEFORE_UPLOAD]] - [[I_MDL_REPOSITORY_VERSION]] - [[I_MDL_REVISION_MODE]] - [[I_MDL_USED_SOFTWARE_BUILD_DATE]] - [[I_MDL_USED_SOFTWARE_DESCRIPTION]] - [[I_MDL_USED_SOFTWARE_LICENSE_CODE]] - [[I_MDL_USED_SOFTWARE_PRODUCT]] - [[I_MDL_USED_SOFTWARE_RELEASE]] - [[I_MDL_USED_SOFTWARE_TRADEMARK]] - [[I_MDL_VERSION]] - [[I_MDL_XML]] - [[I_MDL_XPATH_QUERY]] - [[I_PRR_DESCRIPTION]] - [[I_PRR_VALUE]] %% End Waypoint %%