User Profile
charles983
Copper Contributor
Joined May 17, 2023
User Widgets
Recent Discussions
Re: Office scripts formulas auto updating other formulas
1. I have checked that calculation mode is set to manual before I change the formula, after the formula is changed, and at the end of the script. 2. The current way I am using setFormula is by directly hardcoding the link in, Ex: '=HYPERLINK("https://thisisanexample'/ + num + '.com")' 3. I believe the range is correct as I am using a similar format to things that are previously working. 4. The rows are incrementing properly. The code is as follows: table.getRange().getCell(i + 1, 3).setFormula('=HYPERLINK("https://help.examplesite.com/tickets/' + jsonData[0][0][i]['ticket_id'] + '", "' + jsonData[0][0][i]['ticket_id'] + '")'); I do not believe the jsonData is causing the issue as when I log it in the console, it gives the correct output3.6KViews0likes9CommentsOffice scripts formulas auto updating other formulas
I am currently writing an excel script that populates a table. I am trying to add a hyperlink to one of the columns; however, when I add the hyperlink via a setValue or a setFormula function, the very last setFormula/setValue function auto populates the remaining rows in the table. I have already turned CalculationMode to manual in the code.Solved4.1KViews0likes11Comments
Recent Blog Articles
No content to show