You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository was archived by the owner on Mar 9, 2020. It is now read-only.
If an ExcelAddress token satisfies the following conditions:
contains a worksheet name (followed by "!")
contains a reference to a single row or column (so it will also have a ":")
then the worksheet name is not returned when the address is translated from A1-style to R1C1-style, or the other way around.
Tests to reproduce:
conststringformula="SUM(Sheet1!A:A)";varformulaR1C1=ExcelCellBase.TranslateToR1C1(formula,1,2);Assert.AreEqual("SUM(Sheet1!C[-1])",formulaR1C1);// fails: formulaR1C1 == "Sum(C[-1])"conststringformulaR1C1="SUM(Sheet1!C[-1])";varformula=ExcelCellBase.TranslateFromR1C1(formulaR1C1,1,2);Assert.AreEqual("SUM(Sheet1!A:A)",formula);// also fails: formula == "Sum(A:A)"