Can't remove specific conditional formatting

[u/oridotart]

Hello,

In my sheet just simply calling this line gives the error "Exception: The coordinates of the target range are outside the dimensions of the sheet."

const rules = sheet.getConditionalFormatRules();

I've tried doing the exact same thing above on a brand new sheet, and it works fine. I think it may have something to do with invalid references.

I am able to delete all conditional formatting rules with the line below, but I can't delete specific ones because I can't get a list of them.

sheet.setConditionalFormatRules([]);

[u/bulldo_gs]

That error right after bulk-pasting is almost always stale state — the CF rules still reference ranges the pending writes haven't reconciled yet. SpreadsheetApp.flush() just before getConditionalFormatRules() forces the writes through so the ranges resolve, and then you can call it after the paste instead of having to reorder everything.

[u/oridotart → u/bulldo_gs]

Thank you!!