The story is that the writer is Orcaset, which is trying to sell you their own analysis tools.
To put it politely, this seems like a self-inflicted problem. If you really want your agents to interpret advanced Excel features exactly the way Excel would, have you considered maybe giving your agents Excel?