Excel crashes when trying to read a custom properties with a value that is longer than 255 characters about office-js

[dingjin-ms]

Hi @mburbea , thank you for reporting the issue.

But I'm not able to repro your problem. Here is my repro step:

1. Save a blank workbook.
2. Change the custom.xml file with the property string you gave.
3. Reopen the workbook and load the key value with the script you gave.

I could successfully get the key-value (though just the substring of the actual value).

Could you please provide the file that would crash after loading the custom properties, or could you please share a recording of your complete repro process? Thank you very much.

[penglongzhaochina]

Your length of value exceed the 255 characters. larger values are automatically trimmed to 255 characters. This is the official doc to tell this: https://learn.microsoft.com/en-us/javascript/api/excel/excel.customproperty?view=excel-js-preview.

The fix is releasing to production, after that your length will be trimmed to 255 characters.

Thanks!

[microsoft-github-policy-service]

This issue has been automatically marked as stale because it is marked as needing author feedback but has not had any activity for 4 days. It will be closed if no further activity occurs within 3 days of this comment. Thank you for your interest in Office Add-ins!

[microsoft-github-policy-service]

This issue has been closed due to inactivity. Please comment if you still need assistance and we'll re-open the issue.