Sorting on Adhoc formula column and formatting

Issue #138 wontfix
Wei Wang created an issue

There appears to be a cell-color formatting issue when an inserted column with adhoc formulas are sorted. By default, when there is an error in an adhoc formula (e.g., dividing by zero), the color of the cell turns red as it uses the “td.htInvalid” class. However, if you sort by the adhoc column, the red cell remains on the original formula error cell, even if it is now sorted to another row.

Comments (2)

  1. Ada Trajer

    At the moment handsontable does not support sorting on calculated columns. Once they do, we will support it. It is recommended to turn off sorting on columns which have formulas.

  2. Log in to comment