PHPOffice / PhpSpreadsheet

            } elseif ((($opCharacter == '~') || ($opCharacter == '|')) && (!$isOperandOrFunction)) {    //    We have to explicitly deny a tilde or pipe, because they are legal

                return $this->raiseFormulaError("Formula Error: Illegal character '~'"); //        on the stack but not in the input expression

            } elseif ((isset(self::$operators[$opCharacter]) or $isOperandOrFunction) && $expectingOperator) {    //    Are we putting an operator on the stack?

                while ($stack->count() > 0 &&

                    ($o2 = $stack->last()) &&

                    isset(self::$operators[$o2['value']]) &&

                    @(self::$operatorAssociativity[$opCharacter] ? self::$operatorPrecedence[$opCharacter] < self::$operatorPrecedence[$o2['value']] : self::$operatorPrecedence[$opCharacter] <= self::$operatorPrecedence[$o2['value']])) {

                    $output[] = $stack->pop(); //    Swap operands and higher precedence operators from the stack to the output

                }

                $stack->push('Binary Operator', $opCharacter); //    Finally put our current operator onto the stack

                ++$index;

                $expectingOperator = false;

                //        Cell References) then we have an INTERSECTION operator

                if (($expectingOperator) && (preg_match('/^' . self::CALCULATION_REGEXP_CELLREF . '.*/Ui', substr($formula, $index), $match)) &&

                    ($output[count($output) - 1]['type'] == 'Cell Reference')) {

                    while ($stack->count() > 0 &&

                        ($o2 = $stack->last()) &&

                        isset(self::$operators[$o2['value']]) &&

                        @(self::$operatorAssociativity[$opCharacter] ? self::$operatorPrecedence[$opCharacter] < self::$operatorPrecedence[$o2['value']] : self::$operatorPrecedence[$opCharacter] <= self::$operatorPrecedence[$o2['value']])) {

                        $output[] = $stack->pop(); //    Swap operands and higher precedence operators from the stack to the output

                    }

                    $stack->push('Binary Operator', '|'); //    Put an Intersect Operator on the stack

                    $expectingOperator = false;

                }