In standard of ODF 1.2 describes the INFO function like:
Evaluators shall support at least the following categories:
But it is supported only five of them.
I think that it should support all options.
As Eike explained on IRC this is not a bug. We decided not to implement more.
Created attachment 119557 [details]
Excel no longer supports these memory values - "memavail", "memused", and "totmem"
Markus stated that no calc dev wants to support this function, which is why only a few of its features were implemented. He also stated that 'osversion' always outputting 'Windows (32-bit) NT 5.01' was a decision taken to support some legacy documents.
The LO code shows that 'numfile' always outputs 1, though it should output the number of worksheets in a file. So only 3 of the features (recalc, release, system) actually output something useful in this function.
(In reply to Yousuf (Jay) Philips from comment #2)
> The LO code shows that 'numfile' always outputs 1, though it should output
> the number of worksheets in a file. So only 3 of the features (recalc,
> release, system) actually output something useful in this function.
It's even more convoluted.. in Excel "numfile" returns the number of all sheets in all open files because historically one sheet was one file before Workbooks existed that could have more than one sheet. So actually that was the number of open files, which may had made sense when the number of open files on a system was limited to 255 (or less?). How helpful is that nowadays? Though this is also specified in ODFF with "Number of active worksheets in files".
Maybe we could do that as well, I'm not sure about "get all docshells of type Calc and count sheets", but as said I consider this totally unimportant.
For unsupported but known arguments we should return #N/A error instead of Err:502 (illegal argument). Not necessary to reopen this bug, I'll just use the bug number.
Eike Rathke committed a patch related to this issue.
It has been pushed to "master":
return #N/A for defined but unsupported arguments, tdf#95010 related
It will be available in 5.1.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.