If someone actually uses the INFO function, what is their purpose in doing so? Could this purpose also be achieved by other means? Which of the possible arguments are used?
INFO(“recalc”) could be informative, particularly when macros switch auto-calculation on and off. However, playing with this use case, it turns out to be buggy.
Turning off auto-calc, no recalculation switches the output to “Manual”, not even the hard recalculation nor ThisComponent.calculateAll(). Re-entry will do that.
Switching back to auto-calc, the output changes to “Automatic” automatically.
The standard has, "Evaluators shall support at least the following categories: directory, memavail, memused, numfile, osversion, origin, recalc, release, system, and totmem". LibreOffice accepts only numfile, osversion, recalc, release, and system. numfile is useless as it returns always 1, osversion is useless on Windows, recalc is buggy because it always returns “Automatic”. release might result a curious string, e.g. “7829c6a12aea8e7b66acb1f86a04bc81a71d2d4c” for my debug build. It seems only system gives some useful information.
I am considering to suggest to the ODF TC that the word “shall” be toned down to “should.”
@Villeroy: I was not able to bring INFO("recalc") to return “Manual”. It is always “Automatic” for me. Only editing the formula indeed brings it to “Manual”. That is surely buggy, especially as INFO is contained in the list of often volatile functions in ODF.
That’s what I mean with re-entry of the formula. Why shoujld it be volatile anyway? Just in case someone changes the system or the release without closing the spreadsheet?
I neither see a reason for that. Perhaps next candidate for a change in the ODF standard.
I have generated bug tdf#171098 for this.
1 Like