Getting apostrophe prepended after batch update on every row updated

  google-sheets, php
$data = [];
array_push(
  $data,
  new Google_Service_Sheets_ValueRange([
      'range' => $year.'!'. self::GOOGLECOL_PRICE_COLUMN . $e['rowIndex'],
      'values' =>  [[number_format((double) $data['price'], 0, '.', ' ')]]
  ])
);
array_push(
  $data,
  new Google_Service_Sheets_ValueRange([
      'range' => $year.'!'. self::GOOGLECOL_PRICETWO_COLUMN. $e['rowIndex'],
      'values' =>  [[number_format((double) $data['price_two'], 0, '.', ' ')]]
  ])
);
array_push(
  $data,
  new Google_Service_Sheets_ValueRange([
      'range' => $year.'!'. self::GOOGLECOL_PRICETHREE_COLUMN . $e['rowIndex'],
      'values' =>  [[number_format((double) $price, 0, '.', ' ')]]
  ])
);
$body = new Google_Service_Sheets_BatchUpdateValuesRequest([
    "valueInputOption" => "RAW",
    "data" => $data
]);

$this->_service->spreadsheets_values->batchUpdate($this->_sheetId, $body);

I do this and I get the results I want except that I get these ' characters prepended, is there a reason for this?

example: '1231 '0 '0

Source: Ask PHP

LEAVE A COMMENT