Bug 104123 - EDITING a cell with =INFO("osversion") returns invalid value
Summary: EDITING a cell with =INFO("osversion") returns invalid value
Status: RESOLVED DUPLICATE of bug 96661
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-11-23 12:02 UTC by John Arroyave
Modified: 2020-10-15 09:09 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description John Arroyave 2016-11-23 12:02:00 UTC 
Description:
When I add a new cell in calc this expression:
=INFO("osversion")
Libreoffice is returning the value "Windows (32-bit) NT 5.01" but my system is under Linux Ubuntu 16.04.1 LTS.

I think that returning the correct info here is a main thing, because we use that kind of values to export files by macros or use the filesystem according to the operative system.


Steps to Reproduce:
1.Do a Linux installation of LibreOffice
2.Put in a cell this expression:    =INFO("osversion")
3.You could see that the operative system returned is incorrect

Actual Results:  
Libreoffice Calc return the value:  Windows (32-bit) NT 5.01

Expected Results:
This function should return a name like:   Linux Ubuntu 16.04.1 LTS   or similar, according to the operative system


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.100 Safari/537.36
Comment 1 Thomas Hackert 2016-11-23 15:02:46 UTC 
Hello John, *,
thank you very much for reporting this bug :) I have tested it with

OS: Debian Testing AMD64
LO: Version: 5.1.6.2
Build-ID: 07ac168c60a517dba0f0d7bc7540f5afa45f0909
CPU-Threads: 4; BS-Version: Linux 4.5; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE.UTF-8); Calc: group

and also with

OOo: OpenOffice.org 3.2.0
OOO320m12 (Build:9483)
(my oldest OOo/LO version, parallel installed, following the instructions from https://wiki.documentfoundation.org/Installing_in_parallel/Linux)

On both versions, I can reproduce this bug, so setting "Status" to "NEW" and changing "Version" to "Inherited from OOo".

HTH
Thomas.
Comment 2 Gabor Kelemen (allotropia) 2016-11-23 15:39:28 UTC 
According to the help this is intentional:

https://help.libreoffice.org/Calc/Information_Functions#INFO

"osversion" 	Always "Windows (32-bit) NT 5.01", for compatibility reasons
Comment 3 MM 2016-11-23 22:17:21 UTC 
Maybe, after so many years that this function exists, it could / should be improved ?!
Comment 4 m_a_riosv 2016-11-23 22:42:51 UTC 
(In reply to MM from comment #3)
> Maybe, after so many years that this function exists, it could / should be
> improved ?!

But not a bug. At most a request for enhancement.
Comment 5 Julien Nabet 2016-11-24 09:47:00 UTC 
Code pointer: http://opengrok.libreoffice.org/xref/core/sc/source/core/tool/interpr5.cxx#ScInfo

Eike: any idea why wiki link https://help.libreoffice.org/Calc/Information_Functions#INFO indicates this: 
"Always "Windows (32-bit) NT 5.01", for compatibility reasons"
?
Comment 6 QA Administrators 2017-05-31 10:50:37 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2017-06-28 12:33:52 UTC Comment hidden (obsolete)
Comment 8 Wolfgang Jäger 2020-10-15 09:09:25 UTC 

*** This bug has been marked as a duplicate of bug 96661 ***