Triggers don't work for absolute cell references

Spreadsheet
#1

Hi,

I just tried dhtmlxSpreadsheet and think it works great. However, I discovered that if I use absolute cell references then the automatic updates do not work. E.g. if I in cell C1 enters ‘=A1+$B$1’ then C1 will be correctly updated when I alter the value in A1 but not when I alter the value in B1.
The patch below fixes this for me.

Best regards,
Erik

diff --git a/installer/src/codebase/php/api.php b/installer/src/codebase/php/api.php
index ffad77a…ab9022a 100755
— a/installer/src/codebase/php/api.php
+++ b/installer/src/codebase/php/api.php
@@ -484,10 +484,10 @@ class SpreadSheetCell {
*/
public function getTriggers($expr) {
$matches = “”;

  •           $expr = preg_match_all("/([A-Z]+\d+)[^\(]?/i", $expr, $matches);

  •           $expr = preg_match_all("/([$]?[A-Z]+[$]?\d+)[^\(]?/i", $expr, $matches);
          $triggers = Array();
          for ($i = 0; $i < count($matches[1]); $i++)

  •                   $triggers[] = $matches[1][$i];

  •                   $triggers[] = str_replace('$', '', $matches[1][$i]);
          return $triggers;
  }
#2

Thanks for the patch, we will include it in the main codebase.