•   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
 
  •   icon 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

  •   icon 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

    •   icon 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