The Worksheet.getRange(address) and Worksheet.getRanges(address) methods have an address string limit of 8192 characters. See OfficeDev/office-js Issue #235 for the current status. The Range getImage method isn't currently supported in Excel for Mac.
Range getImage method unsupported on Excel for Mac
Setting these properties to false has no effect. On all platforms, the useStandardHeight and useStandardWidth properties of CellPropertiesFormat are only intended to be set to true. For example, a standard height of 14 is modified to 14.25 in Excel on the web. Due to an issue in the Excel on the web UI, setting the useStandardHeight property to true calculates height imprecisely on this platform. The useStandardHeight property of CellPropertiesFormat doesn't work properly in Excel on the web. The getBindingId method uses the ID of the temporary Binding object to retrieve the Binding object that raised the event.Īsync function run ( ) Cell format useStandardHeight and useStandardWidth issues The listener calls the getBindingId method when the onDataChanged event is triggered. In the sample, an event listener is assigned to a binding.
The following code sample shows how to use this temporary binding ID to retrieve the related Binding object. Use this ID with BindingCollection.getItem(id) to retrieve the Binding object that raised the event. You may not see any tab or option appear in the ribbon, but the add-in gets activated at this stage and the code is available to be used now. In the Add-ins dialogue box, browse and locate the file that you saved, and click OK.
Known Issues Binding events return temporary Binding obectsīoth BindingDataChangedEventArgs.binding and BindingSelectionChangedEventArgs.binding return a temporary Binding object that contains the ID of the Binding object that raised the event. Open an Excel workbook and Go to Developer > Add-ins > Excel Add-ins. The article also discusses potential merge conflicts when using certain APIs, such as TableRowCollection.add. See Coauthoring in Excel add-ins for patterns to use with events in a coauthoring environment. This only applies to multiple Excel workbooks open on Windows or Mac. WorksheetFreezePanes.getLocationOrNullObject The following APIs are affected by this workbook switch. This only happens when particular methods are in the process of being called when the focus changes. Errors can arise when a workbook that is separate from the one running the add-in gains focus. API limitations when the active workbook switchesĪdd-ins for Excel are intended to operate on a single workbook at a time. Please use the feedback tool at the bottom of the page to suggest other issues that can be added to the article. This article discusses troubleshooting issues that are unique to Excel.