Overwrite cells with formulas

[monoasbush]

Noticed after a few hours of troubleshooting that set_cell_value does not overwrite a cells value if there's a formula in the cell. Am I doing something wrong or does this feature not exist?

My use case is that I'm trying to do a sensitivity study by adjusting some variables (cells H1, A13, and C59) in a for loop, and evaluating the resultant cells (B99, B100) that are dependent on cells H1, A13, and C59. In the spreadsheet, H1, A13, and C59 have formulas in them, but for my purposes I want to overwrite those values in python before calculating B99, B100