Sorting and Formula issue

Posted by: stefanleitl on 8 September 2017, 3:20 pm EST

  • Posted 8 September 2017, 3:20 pm EST

    Hello,

    please sort up the first column and put the formual "=A1" in the scond row.
    You can see that the other formulas are corrupt.

    do you have an idea what is going wrong

    thanks
    2015/10/WindowsFormsApplication1.zip
  • Replied 8 September 2017, 3:20 pm EST

    Hello,

    We are able to replicate the issue and hence we are escalating the same to the concerned team for the fix.

    #134630 is tracking id of your issue.

    We will update you once we hear anything from them.

    Thanks,
    Reeva
  • Replied 8 September 2017, 3:20 pm EST

    Hello,

    it is very important that this will be fixed for us

    Thanks
  • Replied 8 September 2017, 3:20 pm EST

    Hello,

    Unfortunately, we haven't heard back from our developers yet. We have asked for an urgent update on the same at high priority.

    We will update you once we hear anything from them.

    We regret the inconvenience.

    Thanks,
    Reeva
  • Replied 8 September 2017, 3:20 pm EST

    Hello,

    This is the intended behaviour.

    The model index is always used for calculations, so when the rows are sorted, the formulas will use the model index.

    Hence, you can set the row header labels to make it clear which cells reference which cells:

    // add code to set row header labels
    for (int r = 0; r < 50; r++)
    m_SheetView.SetRowLabel(r, 0, m_SheetView.GetRowLabel(r, 0));

    That will make the row header labels sort with the rows, so it's clear which rows are referenced in the formulas after sorting.

    Hope it helps.

    Thanks,
    Reeva
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels