function _sheetnode_google_import_formula_replace_coords in Sheetnode 7

Same name and namespace in other branches

1. 6 modules/sheetnode_google/sheetnode_google.import.inc \_sheetnode_google_import_formula_replace_coords()
2. 7.2 modules/sheetnode_google/sheetnode_google.import.inc \_sheetnode_google_import_formula_replace_coords()

1 string reference to '_sheetnode_google_import_formula_replace_coords'

_sheetnode_google_import_do in modules/sheetnode_google/sheetnode_google.import.inc

File

modules/sheetnode_google/sheetnode_google.import.inc, line 305

Extension to sheetnode for importing from Google sheets.

Code

function _sheetnode_google_import_formula_replace_coords($matches) {
  global $_sheetnode_google_import_col, $_sheetnode_google_import_row;
  $col = $_sheetnode_google_import_col;
  $row = $_sheetnode_google_import_row;
  if (@$matches[4]) {
    if (@$matches[3] == '[') {
      $col += $matches[4];
    }
    else {
      $col = $matches[4];
    }
  }
  if (@$matches[2]) {
    if (@$matches[1] == '[') {
      $row += $matches[2];
    }
    else {
      $row = $matches[2];
    }
  }
  return socialcalc_cr_to_coord($col, $row);
}