Change column data based on data from another column in QTableView?

[anda_skoa]

Well, index.column() can obviously not be 8 and 9 at the same time, so first checking for 8 and the checking for 9 will always fail.

Just imagine what the view will do when it wants to get the value of column 9 in, lets say the first row.
It will call data() with an index that contains row=0 and column=9, right?

So checking for 8 is not going to help you in any way, right?

So you now have the value for row 0, column 9. You want to return that value or a changed value depending on the value in column 8.
How do you get the value of column 8, same row?

Cheers,
_

[adutzu89]

Thank you for your guiding. I finally solved with the following:

QVariant ModelLProd::data(const QModelIndex &index, int role) const
{
    QVariant value = QSqlQueryModel::data(index, role);
    if (value.isValid() && role == Qt::DisplayRole && index.column() == 9) {
        int rand=index.row();
        int val=index.sibling(rand,8).data().toInt();
        if(val==99){
            return value.toString().replace(value.toString(),"0.00");
        }
    }
    return value;
}

QVariant ModelLProd::data(const QModelIndex &index, int role) const
{
    QVariant value = QSqlQueryModel::data(index, role);
    if (value.isValid() && role == Qt::DisplayRole && index.column() == 9) {
        int rand=index.row();
        int val=index.sibling(rand,8).data().toInt();
        if(val==99){
            return value.toString().replace(value.toString(),"0.00");
        }
    }
    return value;
}

To copy to clipboard, switch view to plain text mode 

I was looking at the issue the wrong way.