Hexadecimal trouble [250852483]

Assigned

Bug

Status Update

No update yet.

Description

aa...@gmail.com

created issue #1

Oct 4, 2022 12:31PM

A short description of the issue: Unexpected error while trying to process some symbols.

What steps will reproduce the problem?

Place one of the following characters between any ASCII characters as cell value: 0x2028, 0xad, 0x88, 0x81, 0x85
google.script.run.getValues()
google.script.run.setValues(values) where values is a result from step 2

Expected: same values in cells

Instead: error on client with blocking all next google.script.run calls

Error message: NetworkError: Connection failure due to HTTP 400

Project example: index.html

<!DOCTYPE html>
<html>
  <head>
    <base target="_top">
    <script>
       function getSetData() {
         google.script.run.withSuccessHandler(function(values) {
            google.script.run.withFailureHandler(function(error) {
              console.log(error, error.length);
            }).setValues('Sheet1!A1:A5', values);
         }).getValues('Sheet1!A1:A5');
       }

       function setInitialValues() {
         google.script.run.setupData('Sheet1!A1:A5');
       }

        window.addEventListener('load', function() {
            document.getElementById('getSetButton').addEventListener('click', getSetData);
            document.getElementById('setup').addEventListener('click', setInitialValues);
        });
    </script>
  </head>
  <body>
      <button id="setup">Set initial values (run first)</button>
      <button id="getSetButton">Get and Set values</button>
  </body>
</html>

Code.gs:

function onOpen() {
  SpreadsheetApp.getUi().createAddonMenu().addItem('Show sidebar', 'showSidebar').addToUi();
}

function showSidebar() {
  SpreadsheetApp.getUi().showSidebar(HtmlService.createTemplateFromFile('index').evaluate());
}

function getValues(range) {
  return SpreadsheetApp.getActiveSpreadsheet().getRange(range).getValues();
}

function setValues(range, values) {
  SpreadsheetApp.getActiveSpreadsheet().getRange(range).setValues(values);
}

function setupData(range) {
  SpreadsheetApp.getActiveSpreadsheet().getRange(range).setValues([
    ["foo \x2028 bar"],
    ["foo \xad bar"],
    ["foo \x88 bar"],
    ["foo \x81 bar"],
    ["foo \x85 bar"]
  ]);
}

Comments

lo...@google.com <lo...@google.com> #2Oct 5, 2022 11:06AM

Assigned to lo...@google.com.

I notice the same issue and LogCat shows the following message:
Google Play services out of date. Requires 3159100 but found 3136130

aa...@gmail.com <aa...@gmail.com> #3Oct 5, 2022 11:37AM

Same here.

"Google Play services out of date. Requires 3159100 but found 3136130"

Screen Recording 2022-10-05 at 13.33.11.mov

38 MB

Download

lo...@google.com <lo...@google.com> #4Oct 12, 2022 02:17PM

me as well....
Google Play services out of date. Requires 3159100 but found 3136130

aa...@gmail.com <aa...@gmail.com> #5May 10, 2023 03:07PM

I was hopeful that the release of API 18 (4.3) would have created a solution to this, unfortunately it includes version 3158130

is...@google.com <is...@google.com> May 30, 2023 07:51AM

Status: New

jp...@google.com <jp...@google.com> Jul 13, 2023 01:30AM

Assigned to wo...@google.com.

oh...@gmail.com <oh...@gmail.com> #6Sep 13, 2023 08:31AM

Having the same issue:

07-25 00:03:54.998: W/GooglePlayServicesUtil(27293): Google Play services out of date. Requires 3159100 but found 3158130