PHPOffice / PhpSpreadsheet

                        $modified3 = substr($this->updateCellReference('$A' . $match[3], $pBefore, $pNumCols, $pNumRows), 2);

                        $modified4 = substr($this->updateCellReference('$A' . $match[4], $pBefore, $pNumCols, $pNumRows), 2);

                        if ($match[3] . ':' . $match[4] !== $modified3 . ':' . $modified4) {

                            if (($match[2] == '') || (trim($match[2], "'") == $sheetName)) {

                                $toString = ($match[2] > '') ? $match[2] . '!' : '';

                                $toString .= $modified3 . ':' . $modified4;

                                //    Max worksheet size is 1,048,576 rows by 16,384 columns in Excel 2007, so our adjustments need to be at least one digit more

                                $column = 100000;

                                $row = 10000000 + trim($match[3], '$');

                                $cellIndex = $column . $row;

                                $newCellTokens[$cellIndex] = preg_quote($toString);

                                $cellTokens[$cellIndex] = '/(?<!\d\$\!)' . preg_quote($fromString) . '(?!\d)/i';

                                ++$adjustCount;

                            }

                        }

                    }

                }

                //    Search for column ranges (e.g. 'Sheet1'!C:E or C:E) with or without $ absolutes (e.g. $C:E)

                        $modified3 = substr($this->updateCellReference($match[3] . '$1', $pBefore, $pNumCols, $pNumRows), 0, -2);

                        $modified4 = substr($this->updateCellReference($match[4] . '$1', $pBefore, $pNumCols, $pNumRows), 0, -2);

                        if ($match[3] . ':' . $match[4] !== $modified3 . ':' . $modified4) {

                            if (($match[2] == '') || (trim($match[2], "'") == $sheetName)) {

                                $toString = ($match[2] > '') ? $match[2] . '!' : '';

                                $toString .= $modified3 . ':' . $modified4;

                                //    Max worksheet size is 1,048,576 rows by 16,384 columns in Excel 2007, so our adjustments need to be at least one digit more

                                $column = Coordinate::columnIndexFromString(trim($match[3], '$')) + 100000;

                                $row = 10000000;

                                $cellIndex = $column . $row;

                                $newCellTokens[$cellIndex] = preg_quote($toString);

                                $cellTokens[$cellIndex] = '/(?<![A-Z\$\!])' . preg_quote($fromString) . '(?![A-Z])/i';

                                ++$adjustCount;

                            }

                        }

                    }

                }

                //    Search for cell ranges (e.g. 'Sheet1'!A3:C5 or A3:C5) with or without $ absolutes (e.g. $A1:C$5)