@@ -1243,15 +1243,15 @@ |
||
1243 | 1243 | if (isset ($xmlSheet->extLst, $xmlSheet->extLst->ext, $xmlSheet->extLst->ext['uri']) |
1244 | 1244 | && $xmlSheet->extLst->ext['uri'] == "{CCE6A557-97BC-4b89-ADB6-D9C93CAAB3DF}" ) |
1245 | 1245 | { |
1246 | - // retreive MS extension data to create a node that matches expectations. |
|
1247 | - foreach ($xmlSheet->extLst->ext->children('x14', TRUE)->dataValidations->dataValidation as $item) |
|
1248 | - { |
|
1246 | + // retreive MS extension data to create a node that matches expectations. |
|
1247 | + foreach ($xmlSheet->extLst->ext->children('x14', TRUE)->dataValidations->dataValidation as $item) |
|
1248 | + { |
|
1249 | 1249 | $node = $xmlSheet->dataValidations->addChild('dataValidation'); |
1250 | 1250 | foreach ($item->attributes() as $attr) |
1251 | - $node->addAttribute($attr->getName(), $attr); |
|
1251 | + $node->addAttribute($attr->getName(), $attr); |
|
1252 | 1252 | $node->addAttribute('sqref', $item->children('xm',TRUE)->sqref); |
1253 | 1253 | $node->addChild('formula1', $item->formula1->children('xm',TRUE)->f); |
1254 | - } |
|
1254 | + } |
|
1255 | 1255 | } |
1256 | 1256 | |
1257 | 1257 | foreach ($xmlSheet->dataValidations->dataValidation as $dataValidation) { |
@@ -1241,7 +1241,7 @@ discard block |
||
1241 | 1241 | if ($xmlSheet && $xmlSheet->dataValidations && !$this->readDataOnly) { |
1242 | 1242 | // handle Microsoft extension if present |
1243 | 1243 | if (isset ($xmlSheet->extLst, $xmlSheet->extLst->ext, $xmlSheet->extLst->ext['uri']) |
1244 | - && $xmlSheet->extLst->ext['uri'] == "{CCE6A557-97BC-4b89-ADB6-D9C93CAAB3DF}" ) |
|
1244 | + && $xmlSheet->extLst->ext['uri'] == "{CCE6A557-97BC-4b89-ADB6-D9C93CAAB3DF}") |
|
1245 | 1245 | { |
1246 | 1246 | // retreive MS extension data to create a node that matches expectations. |
1247 | 1247 | foreach ($xmlSheet->extLst->ext->children('x14', TRUE)->dataValidations->dataValidation as $item) |
@@ -1249,8 +1249,8 @@ discard block |
||
1249 | 1249 | $node = $xmlSheet->dataValidations->addChild('dataValidation'); |
1250 | 1250 | foreach ($item->attributes() as $attr) |
1251 | 1251 | $node->addAttribute($attr->getName(), $attr); |
1252 | - $node->addAttribute('sqref', $item->children('xm',TRUE)->sqref); |
|
1253 | - $node->addChild('formula1', $item->formula1->children('xm',TRUE)->f); |
|
1252 | + $node->addAttribute('sqref', $item->children('xm', TRUE)->sqref); |
|
1253 | + $node->addChild('formula1', $item->formula1->children('xm', TRUE)->f); |
|
1254 | 1254 | } |
1255 | 1255 | } |
1256 | 1256 |
@@ -1247,8 +1247,9 @@ |
||
1247 | 1247 | foreach ($xmlSheet->extLst->ext->children('x14', TRUE)->dataValidations->dataValidation as $item) |
1248 | 1248 | { |
1249 | 1249 | $node = $xmlSheet->dataValidations->addChild('dataValidation'); |
1250 | - foreach ($item->attributes() as $attr) |
|
1251 | - $node->addAttribute($attr->getName(), $attr); |
|
1250 | + foreach ($item->attributes() as $attr) { |
|
1251 | + $node->addAttribute($attr->getName(), $attr); |
|
1252 | + } |
|
1252 | 1253 | $node->addAttribute('sqref', $item->children('xm',TRUE)->sqref); |
1253 | 1254 | $node->addChild('formula1', $item->formula1->children('xm',TRUE)->f); |
1254 | 1255 | } |