Search code examples
javascriptexceloffice-jsoffice-addinsexcel-web-addins

Custom functions DataType to make text in cell bold office.js

Are there any ways to make the text bold without using the Excel.run method in a custom function?

I found how to format the numbers, but I could not find the formatting of the strings https://learn.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-data-types-concepts

Solution

  • It is not possible to set the text to bold etc using the formatted number value data type. You can however call the Excel API and set the formatting on the cell that called the custom function. Access to the Excel API from a custom function require the use of the shared runtime.

    The ability to apply additional formatting to formatted number value data types is a great feature request. Consider posting this as an item for the backlog in the Microsoft 365 Developer Community.