https://bugs.documentfoundation.org/show_bug.cgi?id=171098

--- Comment #6 from Vladimir Sokolinskiy <[email protected]> ---
For reference: about the INFO function in MS Excel (as I understand it).

1. In Excel, this function is volatile depending on its parameters [1].

2. If Application.Calculation <> xlCalculationManual, then the INFO function
with the "recalc" parameter returns "Automatic" (taking localization into
account).

3. When Excel switches to manual calculation mode, previously calculated values
​​of all functions are "frozen," meaning that the previously entered INFO
function with the "recalc" parameter returns its previous value ("Automatic").

4. If Application.Calculation = xlCalculationManual, then when entering or
modifying a formula or manually recalculating a cell, the INFO function with
the "recalc" parameter returns "Manual" (taking localization into account).

[1]
https://learn.microsoft.com/en-us/office/client-developer/excel/excel-recalculation

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to