How do I multiple an Excel Range by 1 using Office Script?
How can I multiple the selected range in Excel using Office Script by 1?
Changing Conditional format rule seems to work but doesn’t in office-js
I am trying to write some simple TypeScript code to change a conditional formatting rule in an Excel file. To repro my issue:
Typescript Code to set formulas to a range of cells runs fine in Script lab, doesn’t compile in VSCode
Does anyone know why this simple code:
We need to move cell A100 below A54
We are freezing cells in the range A51 to A54, and we have selected cell A100.
How to add comments over tooltips in Office JS
I’m currently working in a rewrite of a VSTO-based add-in in Office JS. Our old add-in created some template sheets for users to fill which are then used for data upload.
How can I show some feedback from a Office.js Excel right-click command?
I have an Excel javascript add-in that includes some cell right-click actions, which can therefore be done when the add-in’s task pane is not showing.
Does the Excel API have a way to change the position of the grouped row expand/collapse button?
In the desktop version of Excel, the expand/collapse button can be moved to the top of grouped rows by going to data->outline->(more options) and unchecking “Summary Rows below Detail.” Is there a way to do this programmatically via the Excel/Office-JS API? I haven’t been able to find anything in the docs, and given that this feature seems to be missing in the web version of Excel, I’m guessing the answer is probably no, but just want to check.