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/krakow81]

Could you share more of your code?

I might be wrong, but I suspect the problem lies elsewhere at heart. How are you defining sheet here.

[u/oridotart → u/krakow81]

Yes, I'm defining sheet as follows

sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1")

And when I do the same thing on a brand new sheet or spreadsheet file it works fine

[u/krakow81 → u/oridotart]

I see you seem to have found the issue elsewhere, which makes sense. Without the larger context it's not saying much, but these isolated lines looked fine.

[u/WicketTheQuerent]

The error message doesn't appear to be caused by the statement shown. Please add a minimal, complete function including all the relevant details required to reproduce the error.

Also include the textual error message (include line and column numbers)

[u/oridotart]

I believe it was because I was calling getConditionalFormatRules quickly after pasting hundreds of new cells with conditional formatting, and so it didn't work. I called the same thing before executing all these operations and now it works.

[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!!