[Libreoffice-bugs] [Bug 95010] INFO function not fully supporting ODF 1.2 specification

[bugzilla-daemon]

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

Commit Notification  changed:

   What|Removed |Added

 Whiteboard|| target:5.1.0

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95010] INFO function not fully supporting ODF 1.2 specification

[bugzilla-daemon]

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

--- Comment #4 from Commit Notification 
 ---
Eike Rathke committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=db6a928a420868b2a80ba11c8d46151d16c13624

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:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95010] INFO function not fully supporting ODF 1.2 specification

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

   Priority|medium  |low
   Hardware|Other   |All
Version|5.1.0.0.alpha0+ Master  |Inherited From OOo

--- Comment #3 from Eike Rathke  ---
(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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95010] INFO function not fully supporting ODF 1.2 specification

[bugzilla-daemon]

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

Yousuf (Jay) Philips  changed:

   What|Removed |Added

 CC||philip...@hotmail.com
  Component|Documentation   |Calc
 Blocks||94587
Summary|[LOCALHELP] the INFO|INFO function not fully
   |function not match the  |supporting ODF 1.2
   |standard of ODF 1.2 |specification

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95010] INFO function not fully supporting ODF 1.2 specification

[bugzilla-daemon]

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

--- Comment #2 from Yousuf (Jay) Philips  ---
Created attachment 119557
  --> https://bugs.documentfoundation.org/attachment.cgi?id=119557=edit
sample

Excel no longer supports these memory values - "memavail", "memused", and
"totmem"

https://support.office.com/en-us/article/INFO-function-725f259a-0e4b-49b3-8b52-58815c69acae?omkt=en-US=en-US=en-US=US

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs