I start by saying it’s not a function name (I did some search before posting). In the attached project, you will notice that F28 and F29 contain formulas. Both depend on the “hidden” column E values. The formula is as simple as:
The cell value becomes “0”. If I call manually “CalculateFormula” for that Worksheet, the value then changes to “” (empty string).
On E28, for example, the content is just “true” (lower case). According to some sources, if we use “=” to compare a cell to a string, this comparison is case insensitive. If we want to force it to be case sensitive, we should use “EXACT” instead.
I noticed that if I save this file (using excel), the value and formula start to get read correctly, although I don’t control this Excel file. I can’t just save it again. Is there any way to fix this?
AsposeTest12.zip (280.7 KB)