View GitHub Repository PhpSpreadsheet

Schedule Inspection
Subscribe

Code Duplication    Length = 5-5 lines in 2 locations

src/PhpSpreadsheet/Writer/Xlsx/Worksheet.php 2 locations

@@ 497-501 (lines=5) @@
494 
                        && $conditional->getOperatorType() == Conditional::OPERATOR_CONTAINSTEXT
495 
                        && $conditional->getText() !== null) {
496 
                        $objWriter->writeElement('formula', 'NOT(ISERROR(SEARCH("' . $conditional->getText() . '",' . $cellCoordinate . ')))');
497 
                    } elseif ($conditional->getConditionType() == Conditional::CONDITION_CONTAINSTEXT
498 
                        && $conditional->getOperatorType() == Conditional::OPERATOR_BEGINSWITH
499 
                        && $conditional->getText() !== null) {
500 
                        $objWriter->writeElement('formula', 'LEFT(' . $cellCoordinate . ',' . strlen($conditional->getText()) . ')="' . $conditional->getText() . '"');
501 
                    } elseif ($conditional->getConditionType() == Conditional::CONDITION_CONTAINSTEXT
502 
                        && $conditional->getOperatorType() == Conditional::OPERATOR_ENDSWITH
503 
                        && $conditional->getText() !== null) {
504 
                        $objWriter->writeElement('formula', 'RIGHT(' . $cellCoordinate . ',' . strlen($conditional->getText()) . ')="' . $conditional->getText() . '"');
@@ 505-509 (lines=5) @@
502 
                        && $conditional->getOperatorType() == Conditional::OPERATOR_ENDSWITH
503 
                        && $conditional->getText() !== null) {
504 
                        $objWriter->writeElement('formula', 'RIGHT(' . $cellCoordinate . ',' . strlen($conditional->getText()) . ')="' . $conditional->getText() . '"');
505 
                    } elseif ($conditional->getConditionType() == Conditional::CONDITION_CONTAINSTEXT
506 
                        && $conditional->getOperatorType() == Conditional::OPERATOR_NOTCONTAINS
507 
                        && $conditional->getText() !== null) {
508 
                        $objWriter->writeElement('formula', 'ISERROR(SEARCH("' . $conditional->getText() . '",' . $cellCoordinate . '))');
509 
                    } elseif ($conditional->getConditionType() == Conditional::CONDITION_CELLIS
510 
                        || $conditional->getConditionType() == Conditional::CONDITION_CONTAINSTEXT
511 
                        || $conditional->getConditionType() == Conditional::CONDITION_EXPRESSION) {
512 
                        foreach ($conditional->getConditions() as $formula) {