tree a15527a078ff5d12cdab3ca2ea0e26a56be79691
parent 03d755c27ff0c034c6d40ce5e23964abfa3283ac
author philga <philga@1track.com> 1566852193 -0700
committer Trevor Ryland <tryland@google.com> 1603410182 -0600

When Google Sheets exports a Google Sheets formula into an Excel file as an A1 format formula, it sometimes splits a column name and includes an embedded 'double quote, ampersand, double quote' in the middle of the column name. The location of the embedded 'double quote, ampersand, double quote' can vary from row to row. As a result when the A1 formula is converted to R1C1 format, the R1C1 formula can differ simply because the column name was split at a slightly different location. This change looks for 'double quote, ampersand, double quote' in the middle of a quote identifier and remove them. This results in matching R1C1 formulas despite the presence of the 'double quote, ampersand, double quote' characters. This fix is somewhat speculative. I am making it after seeing one instance of this problem which was reported by a single customer.