-
Public Cells
#if $mismatchPublicCellDict:
#for $publicCell in $mismatchPublicCellDict:
-
#if 'Deleted' in $mismatchPublicCellDict[$publicCell]['Mismatch Type'] or 'Added' in $mismatchPublicCellDict[$publicCell]['Mismatch Type']:
$mismatchPublicCellDict[$publicCell]['newVerDetails'].get('Cell Name') $mismatchPublicCellDict[$publicCell]['newVerDetails'].get('Data Type') $mismatchPublicCellDict[$publicCell]['newVerDetails'].get('Text Length')
#else if 'Renamed' in $mismatchPublicCellDict[$publicCell]['Mismatch Type']:
$mismatchPublicCellDict[$publicCell]['newVerDetails'].get('Cell Name') ($mismatchPublicCellDict[$publicCell]['newVerDetails'].get('Data Type') $mismatchPublicCellDict[$publicCell]['newVerDetails'].get('Text Length'))
#else if 'Data Type Changed' in $mismatchPublicCellDict[$publicCell]['Mismatch Type']:
$mismatchPublicCellDict[$publicCell]['newVerDetails'].get('Cell Name') ($mismatchPublicCellDict[$publicCell]['newVerDetails'].get('Data Type') $mismatchPublicCellDict[$publicCell]['newVerDetails'].get('Text Length'))
#else if 'Text Length Changed' in $mismatchPublicCellDict[$publicCell]['Mismatch Type']:
$mismatchPublicCellDict[$publicCell]['newVerDetails'].get('Cell Name') ($mismatchPublicCellDict[$publicCell]['newVerDetails'].get('Data Type') $mismatchPublicCellDict[$publicCell]['newVerDetails'].get('Text Length'))
#else:
$mismatchPublicCellDict[$publicCell]['newVerDetails'].get('Cell Name') ($mismatchPublicCellDict[$publicCell]['newVerDetails'].get('Data Type') $mismatchPublicCellDict[$publicCell]['newVerDetails'].get('Text Length'))
#end if
#end for
#end if
-
Private Cells
#if $mismatchPrivateCellDict:
#for $privateCell in $mismatchPrivateCellDict:
-
#if 'Deleted' in $mismatchPrivateCellDict[$privateCell]['Mismatch Type'] or 'Added' in $mismatchPrivateCellDict[$privateCell]['Mismatch Type']:
$mismatchPrivateCellDict[$privateCell]['newVerDetails'].get('Cell Name') $mismatchPrivateCellDict[$privateCell]['newVerDetails'].get('Data Type') $mismatchPrivateCellDict[$privateCell]['newVerDetails'].get('Text Length')
#else if 'Renamed' in $mismatchPrivateCellDict[$privateCell]['Mismatch Type']:
$mismatchPrivateCellDict[$privateCell]['newVerDetails'].get('Cell Name') ($mismatchPrivateCellDict[$privateCell]['newVerDetails'].get('Data Type') $mismatchPrivateCellDict[$privateCell]['newVerDetails'].get('Text Length'))
#else if 'Data Type Changed' in $mismatchPrivateCellDict[$privateCell]['Mismatch Type']:
$mismatchPrivateCellDict[$privateCell]['newVerDetails'].get('Cell Name') ($mismatchPrivateCellDict[$privateCell]['newVerDetails'].get('Data Type') $mismatchPrivateCellDict[$privateCell]['newVerDetails'].get('Text Length'))
#else if 'Text Length Changed' in $mismatchPrivateCellDict[$privateCell]['Mismatch Type']:
$mismatchPrivateCellDict[$privateCell]['newVerDetails'].get('Cell Name') ($mismatchPrivateCellDict[$privateCell]['newVerDetails'].get('Data Type') $mismatchPrivateCellDict[$privateCell]['newVerDetails'].get('Text Length'))
#else:
$mismatchPrivateCellDict[$privateCell]['newVerDetails'].get('Cell Name') ($mismatchPrivateCellDict[$privateCell]['newVerDetails'].get('Data Type') $mismatchPrivateCellDict[$privateCell]['newVerDetails'].get('Text Length'))
#end if
#end for
#end if
-
Reference Cells
#if $mismatchReferenceCellDict:
#for $referenceCell in $mismatchReferenceCellDict:
-
#if 'Deleted' in $mismatchReferenceCellDict[$referenceCell]['Mismatch Type'] or 'Added' in $mismatchReferenceCellDict[$referenceCell]['Mismatch Type']:
$mismatchReferenceCellDict[$referenceCell]['newVerDetails'].get('Cell Name') $mismatchReferenceCellDict[$referenceCell]['newVerDetails'].get('Referred Sheet Name')
#else if 'Referred Sheet Changed' in $mismatchReferenceCellDict[$referenceCell]['Mismatch Type']:
$mismatchReferenceCellDict[$referenceCell]['newVerDetails'].get('Cell Name')($mismatchReferenceCellDict[$referenceCell]['newVerDetails'].get('Referred Sheet Name'))
#else:
$mismatchReferenceCellDict[$referenceCell]['newVerDetails'].get('Cell Name') ($mismatchReferenceCellDict[$referenceCell]['newVerDetails'].get('Referred Sheet Name'))
#end if
#end for
#end if
|
|
-
Public Cells
#if $mismatchPublicCellDict:
#for $publicCell in $mismatchPublicCellDict:
-
#if 'Deleted' in $mismatchPublicCellDict[$publicCell]['Mismatch Type'] or 'Added' in $mismatchPublicCellDict[$publicCell]['Mismatch Type']:
$mismatchPublicCellDict[$publicCell]['oldVerDetails'].get('Cell Name') $mismatchPublicCellDict[$publicCell]['oldVerDetails'].get('Data Type') $mismatchPublicCellDict[$publicCell]['oldVerDetails'].get('Text Length')
#else if 'Renamed' in $mismatchPublicCellDict[$publicCell]['Mismatch Type']:
$mismatchPublicCellDict[$publicCell]['oldVerDetails'].get('Cell Name') ($mismatchPublicCellDict[$publicCell]['oldVerDetails'].get('Data Type') $mismatchPublicCellDict[$publicCell]['oldVerDetails'].get('Text Length'))
#else if 'Data Type Changed' in $mismatchPublicCellDict[$publicCell]['Mismatch Type']:
$mismatchPublicCellDict[$publicCell]['oldVerDetails'].get('Cell Name') ($mismatchPublicCellDict[$publicCell]['oldVerDetails'].get('Data Type') $mismatchPublicCellDict[$publicCell]['oldVerDetails'].get('Text Length'))
#else if 'Text Length Changed' in $mismatchPublicCellDict[$publicCell]['Mismatch Type']:
$mismatchPublicCellDict[$publicCell]['oldVerDetails'].get('Cell Name') ($mismatchPublicCellDict[$publicCell]['oldVerDetails'].get('Data Type') $mismatchPublicCellDict[$publicCell]['oldVerDetails'].get('Text Length'))
#else:
$mismatchPublicCellDict[$publicCell]['oldVerDetails'].get('Cell Name') ($mismatchPublicCellDict[$publicCell]['oldVerDetails'].get('Data Type') $mismatchPublicCellDict[$publicCell]['oldVerDetails'].get('Text Length'))
#end if
#end for
#end if
-
Private Cells
#if $mismatchPrivateCellDict:
#for $privateCell in $mismatchPrivateCellDict:
-
#if 'Deleted' in $mismatchPrivateCellDict[$privateCell]['Mismatch Type'] or 'Added' in $mismatchPrivateCellDict[$privateCell]['Mismatch Type']:
$mismatchPrivateCellDict[$privateCell]['oldVerDetails'].get('Cell Name') $mismatchPrivateCellDict[$privateCell]['oldVerDetails'].get('Data Type') $mismatchPrivateCellDict[$privateCell]['oldVerDetails'].get('Text Length')
#else if 'Renamed' in $mismatchPrivateCellDict[$privateCell]['Mismatch Type']:
$mismatchPrivateCellDict[$privateCell]['oldVerDetails'].get('Cell Name') ($mismatchPrivateCellDict[$privateCell]['oldVerDetails'].get('Data Type') $mismatchPrivateCellDict[$privateCell]['oldVerDetails'].get('Text Length'))
#else if 'Data Type Changed' in $mismatchPrivateCellDict[$privateCell]['Mismatch Type']:
$mismatchPrivateCellDict[$privateCell]['oldVerDetails'].get('Cell Name') ($mismatchPrivateCellDict[$privateCell]['oldVerDetails'].get('Data Type') $mismatchPrivateCellDict[$privateCell]['oldVerDetails'].get('Text Length'))
#else if 'Text Length Changed' in $mismatchPrivateCellDict[$privateCell]['Mismatch Type']:
$mismatchPrivateCellDict[$privateCell]['oldVerDetails'].get('Cell Name') ($mismatchPrivateCellDict[$privateCell]['oldVerDetails'].get('Data Type') $mismatchPrivateCellDict[$privateCell]['oldVerDetails'].get('Text Length'))
#else:
$mismatchPrivateCellDict[$privateCell]['oldVerDetails'].get('Cell Name') ($mismatchPrivateCellDict[$privateCell]['oldVerDetails'].get('Data Type') $mismatchPrivateCellDict[$privateCell]['oldVerDetails'].get('Text Length'))
#end if
#end for
#end if
-
Reference Cells
#if $mismatchReferenceCellDict:
#for $referenceCell in $mismatchReferenceCellDict:
-
#if 'Deleted' in $mismatchReferenceCellDict[$referenceCell]['Mismatch Type'] or 'Added' in $mismatchReferenceCellDict[$referenceCell]['Mismatch Type']:
$mismatchReferenceCellDict[$referenceCell]['oldVerDetails'].get('Cell Name') $mismatchReferenceCellDict[$referenceCell]['oldVerDetails'].get('Referred Sheet Name')
#else if 'Referred Sheet Changed' in $mismatchReferenceCellDict[$referenceCell]['Mismatch Type']:
$mismatchReferenceCellDict[$referenceCell]['oldVerDetails'].get('Cell Name') ($mismatchReferenceCellDict[$referenceCell]['oldVerDetails'].get('Referred Sheet Name'))
#else:
$mismatchReferenceCellDict[$referenceCell]['oldVerDetails'].get('Cell Name') ($mismatchReferenceCellDict[$referenceCell]['oldVerDetails'].get('Referred Sheet Name'))
#end if
#end for
#end if
|