Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
5,087 questions
macOS Excel v16.85 truncates string size to 126 characters for custom property values
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 4%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECT%3C/text%3E%3C/svg%3E)
Colby Timm
0
Reputation points
In the latest release of Excel M365 for macOS (v16.85) we are experiencing an issue where when we use the Excel Javascript API via an add-in application to retrieve custom property values, where each custom property is truncated to 126 characters. We have been able to reproduce on multiple machines using the same version of Excel (v16.85). Lower versions of Excel don't experience this issue and it seems to be isolated to macOS only (tested on Intel and M chips). We can't reproduce this on the latest version of Excel in Windows version 2404 Build 16.0.17531.20152.
The custom properties are fetched by calling:
context.workbook.properties.custom
For the implementation, we are using the same solution that's shown in the example here. Based on the documentation, the value should be limited to 255 characters outside of Excel on the web (see documentation here or screenshot below).
Microsoft 365
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,954 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
995 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,972 questions
Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
511 questions
Sign in to answer