package jxl.biff;

import common.Logger;
import jxl.biff.formula.ExternalSheet;
import okhttp3.internal.http2.Settings;

/* JADX INFO: loaded from: classes.dex */
public final class CellReferenceHelper {
    public static /* synthetic */ Class class$jxl$biff$CellReferenceHelper = null;
    private static final char fixedInd = '$';
    private static Logger logger = null;
    private static final char sheetInd = '!';

    static {
        Class clsClass$ = class$jxl$biff$CellReferenceHelper;
        if (clsClass$ == null) {
            clsClass$ = class$("jxl.biff.CellReferenceHelper");
            class$jxl$biff$CellReferenceHelper = clsClass$;
        }
        logger = Logger.getLogger(clsClass$);
    }

    private CellReferenceHelper() {
    }

    public static /* synthetic */ Class class$(String str) {
        try {
            return Class.forName(str);
        } catch (ClassNotFoundException e2) {
            throw new NoClassDefFoundError(e2.getMessage());
        }
    }

    public static void getCellReference(int i2, int i3, StringBuffer stringBuffer) {
        getColumnReference(i2, stringBuffer);
        stringBuffer.append(Integer.toString(i3 + 1));
    }

    public static int getColumn(String str) {
        int numberIndex = getNumberIndex(str);
        String upperCase = str.toUpperCase();
        int iLastIndexOf = str.lastIndexOf(33) + 1;
        if (str.charAt(iLastIndexOf) == '$') {
            iLastIndexOf++;
        }
        if (str.charAt(numberIndex - 1) == '$') {
            numberIndex--;
        }
        int iCharAt = 0;
        for (int i2 = iLastIndexOf; i2 < numberIndex; i2++) {
            if (i2 != iLastIndexOf) {
                iCharAt = (iCharAt + 1) * 26;
            }
            iCharAt += upperCase.charAt(i2) - 'A';
        }
        return iCharAt;
    }

    public static String getColumnReference(int i2) {
        StringBuffer stringBuffer = new StringBuffer();
        getColumnReference(i2, stringBuffer);
        return stringBuffer.toString();
    }

    private static int getNumberIndex(String str) {
        int iLastIndexOf = str.lastIndexOf(33) + 1;
        boolean z = false;
        while (!z && iLastIndexOf < str.length()) {
            char cCharAt = str.charAt(iLastIndexOf);
            if (cCharAt < '0' || cCharAt > '9') {
                iLastIndexOf++;
            } else {
                z = true;
            }
        }
        return iLastIndexOf;
    }

    public static int getRow(String str) {
        try {
            return Integer.parseInt(str.substring(getNumberIndex(str))) - 1;
        } catch (NumberFormatException e2) {
            logger.warn(e2, e2);
            return Settings.DEFAULT_INITIAL_WINDOW_SIZE;
        }
    }

    public static String getSheet(String str) {
        int iLastIndexOf = str.lastIndexOf(33);
        return iLastIndexOf == -1 ? "" : str.substring(0, iLastIndexOf);
    }

    public static boolean isColumnRelative(String str) {
        return str.charAt(0) != '$';
    }

    public static boolean isRowRelative(String str) {
        return str.charAt(getNumberIndex(str) - 1) != '$';
    }

    public static void getCellReference(int i2, boolean z, int i3, boolean z2, StringBuffer stringBuffer) {
        if (z) {
            stringBuffer.append('$');
        }
        getColumnReference(i2, stringBuffer);
        if (z2) {
            stringBuffer.append('$');
        }
        stringBuffer.append(Integer.toString(i3 + 1));
    }

    public static void getColumnReference(int i2, StringBuffer stringBuffer) {
        int i3 = i2 % 26;
        StringBuffer stringBuffer2 = new StringBuffer();
        for (int i4 = i2 / 26; i4 != 0; i4 /= 26) {
            stringBuffer2.append((char) (i3 + 65));
            i3 = (i4 % 26) - 1;
        }
        stringBuffer2.append((char) (i3 + 65));
        for (int length = stringBuffer2.length() - 1; length >= 0; length--) {
            stringBuffer.append(stringBuffer2.charAt(length));
        }
    }

    public static void getCellReference(int i2, int i3, int i4, ExternalSheet externalSheet, StringBuffer stringBuffer) {
        stringBuffer.append(StringHelper.replace(externalSheet.getExternalSheetName(i2), "'", "''"));
        stringBuffer.append(sheetInd);
        getCellReference(i3, i4, stringBuffer);
    }

    public static void getCellReference(int i2, int i3, boolean z, int i4, boolean z2, ExternalSheet externalSheet, StringBuffer stringBuffer) {
        stringBuffer.append(externalSheet.getExternalSheetName(i2));
        stringBuffer.append(sheetInd);
        getCellReference(i3, z, i4, z2, stringBuffer);
    }

    public static String getCellReference(int i2, int i3, int i4, ExternalSheet externalSheet) {
        StringBuffer stringBuffer = new StringBuffer();
        getCellReference(i2, i3, i4, externalSheet, stringBuffer);
        return stringBuffer.toString();
    }

    public static String getCellReference(int i2, int i3) {
        StringBuffer stringBuffer = new StringBuffer();
        getCellReference(i2, i3, stringBuffer);
        return stringBuffer.toString();
    }
}