Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
4165
How to know Cell Updated via Formula rather than Manual Edit
posted

Hello,

We use the AfterCellUpdate event a lot on our grids. We are expanding some manually calculated items to use the formulas on columns.

We want to know if the cell has been updated via the formula vs. being manually editied. Is there a property that we can check? Most of the formula columns can't be edited but there happens to be two that can either be formulated or manually entered by row (not by column).

Thanks.

Parents
  • 469350
    Offline posted

    Hi,

    No, there's no way to tell if a cell's value came from a formula or from being manually entered. In fact, it doesn't really make much sense to have a cell that is the target of a formula and to also allow that cell to be editing by the user, since whatever the user entered will simply be overwritten when the formula is calculated.

Reply Children