QString xl_rowcol_to_cell(int row, int col, bool row_abs, bool col_abs) { QString cell_str; if (col_abs) cell_str.append(QLatin1Char('$')); cell_str.append(xl_col_to_name(col)); if (row_abs) cell_str.append(QLatin1Char('$')); cell_str.append(QString::number(row)); return cell_str; }
QString xl_rowcol_to_cell_fast(int row, int col) { static QMap<int, QString> col_cache; QString col_str; if (col_cache.contains(col)) { col_str = col_cache[col]; } else { col_str = xl_col_to_name(col); col_cache[col] = col_str; } return col_str + QString::number(row+1); }