Is there a way to use "Replace Named Range Content Request" on Table cell content?

Question

I am trying to use the "Replace Named Range Content Request" to update the content of table cells but I keep getting a this range cannot be replaced error, I also tried deleting the table cells content,not the table cell itself, but I got this error (

{
  "error": {
    "code": 400,
    "message": "Invalid requests[0].deleteContentRange: Invalid deletion range. Cannot delete the requested range.",
    "status": "INVALID_ARGUMENT"
  }
}

)

I have cross-checked the indexes I am using and I can't figure it out, Insert Text request works but replacing or deleting the text in a table cell brings back an error.

Here is the body of one of my table cells in JSON format

                     "startIndex": 145,
                      "endIndex": 152,
                      "paragraph": {
                        "elements": [
                          {
                            "startIndex": 145,
                            "endIndex": 152,
                            "textRun": {
                              "content": "Item 1\n",
                              "textStyle": {}
                            }

My delete content request in JSON format

{
  "requests": [
    {
      "deleteContentRange": {
        "range": {
          "startIndex": 145,
          "endIndex": 152
        }
      }
    ]
  }

I created a named range with the table cell content start and end indexes and I was expecting it to automatically replace the text in the cell when I use "Replace Named Range Content Request"

@Ihopethisishelpfultoyou { "requests": [ { "insertText": { "text": "Test", "location": { "index": 145, "segmentId": "" } } } ] } — Chi Resha
– Chi Resha, Commented Oct 29, 2022 at 12:53

Rafa Guillermo · Accepted Answer · 2022-10-31 07:58:52Z

2

I think this error normally appears when the range you specify attempts to delete an element outside of the current element's index range.

If you're trying to remove the word "Test" then endIndex should be 149 if starting at 145 (4 characters).

As the table cell itself is from range 145 to 152, then the delete range should be 146 to 151 to delete all the cell contents.

answered Oct 31, 2022 at 7:58

Rafa Guillermo

15.5k3 gold badges23 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Todd Nov 27 at 20:50

This should be the answer.

Tom Redman · Accepted Answer · 2023-05-19 14:05:56Z

Docs API is a bit of a joke. To delete the paragraph content in a tableCell, subtract 1 from the endIndex to account for the newline character.

For example, this results in the error you're seeing:

const removePhotoTokenRequest = {
      deleteContentRange: {
        range: {
          startIndex: photoElement.startIndex,
          endIndex: photoElement.endIndex,
        },
      },
    };

You'll get the error:

{
  "error": {
    "code": 400,
    "message": "Invalid requests[0].deleteContentRange: Invalid deletion range. Cannot delete the requested range.",
    "status": "INVALID_ARGUMENT"
  }
}

Instead, do this:

const removePhotoTokenRequest = {
      deleteContentRange: {
        range: {
          startIndex: photoElement.startIndex,
          endIndex: photoElement.endIndex - 1,
        },
      },
    };

Welcome to wonderful world of the Google Docs API! The four of us that have used this API to this level should hold a meetup.

Collectives™ on Stack Overflow

Is there a way to use "Replace Named Range Content Request" on Table cell content?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related