Description: I am using Linux mint 19.3 64 bits with libreoffice 7.1.0 CALC formula =INFO("system") gives output as " LINUX " ... This is correct But, I have noticed that CALC formula =INFO("OSVERSION") gives output as " Windows (32-bit) NT 5.01 " ... This is WRONG. Steps to Reproduce: 1. From Linux 64 bit machine Open LO Calc 2. In a cell type formula =INFO("OSVERSION") Actual Results: It will show " Windows (32-bit) NT 5.01 " Expected Results: It should be Linux (64-bit) ..etc whatever ... but not WINDOWS ! Reproducible: Always User Profile Reset: Yes Additional Info: Enclosed spreadsheet file showing up this error Vs my actual system information
Created attachment 169604 [details] INFO("OSVERSION") formula result example
Reproduced in Version: 7.2.0.0.alpha0+ / LibreOffice Community Build ID: dc1b416c684c4e2525978e48252d55d78adcfca8 CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Version: 5.2.0.0.alpha1+ Build ID: 5b168b3fa568e48e795234dc5fa454bf24c9805e CPU Threads: 4; OS Version: Linux 4.8; UI Render: default; Locale: ca-ES (ca_ES.UTF-8) Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
@Eike, I thought you might be interested in this issue
This hasn't changed since 2006 https://opengrok.libreoffice.org/diff/core/sc/source/core/tool/interpr5.cxx?r1=%2Fcore%2Fsc%2Fsource%2Fcore%2Ftool%2Finterpr5.cxx%40fe4a73e0&r2=%2Fcore%2Fsc%2Fsource%2Fcore%2Ftool%2Finterpr5.cxx%402ff54fba
Reason probably being that it's there because of Excel Windows interoperability. I'm unbiased, I don't mind if we change it to return the actual OS (and possibly version), but I also don't know the use case of this function/argument at all or if and how documents rely on it (and why). Btw, what does current Excel on a current Windows return?
Excel 2016 On Windows 10 Shows: Windows (32-bit) NT 10.00
64 bit MS Office may give different value (but I don't have 64 bit MS Office)
(In reply to Eike Rathke from comment #5) > Btw, what does current Excel on a current Windows return? My Windows 10 Home, OS build 19041.746 is correctly reported by Excel as Windows (64-bit) NT 10.00 and wrongly by LibreOffice as Windows (32-bit) NT 5.01
I presume we could use the same information as for Environment OS in the Help -> About dialog, which calls Application::GetHWOSConfInfo(). That can't be used though because it concatenates CPUs and OS, but a similar function could be introduced returning only the OS and version without label, i.e. using the overridden SalInstance::getOSVersion() return value. Whatever that gives for Windows might have to be massaged into shape to somewhat resemble the Excel string. And what does Excel on MacOS produce? I'd make this an EasyHack once we clarified what we actually want here..
Any updates on this ?
"Windows (32-bit) NT 5.01" is a hard coded string in the source (interpr5.cxx). It came with commit 2ff54fbac26a884e53e74f44db7831cc179a6a97 (2006).
scito committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/4d0d4fb11f7251e0437ec8e6fe7b7693f3a31800 tdf#140286 fix INFO("OSVERSION") for Linux: return kernel version It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
If some devs on Mac and/or Windows could check with that patch added what Application::GetOSVersion() gives and whether the result is usable for the INFO("osversion") call? See sc/source/core/tool/interpr5.cxx ScInterpreter::ScInfo()
I'm not sure how much sense it makes to show the Linux kernel version. Maybe just as a fallback, if "lsb_release -d" has no result? Not sure how common the lsb tools are installed. I doubt LO depends at all somehow on the Linux kernel version.
What should it show for MacOS?
On a Mac, I get "Macintosh (Intel) Version 11.6.2 (Build 20G314)"
(In reply to Jan-Marek Glogowski from comment #14) > I'm not sure how much sense it makes to show the Linux kernel version. Maybe > just as a fallback, if "lsb_release -d" has no result? Not sure how common > the lsb tools are installed. I doubt LO depends at all somehow on the Linux > kernel version. I agree that knowing the Linux distribution and the version is much more important compared to the kernel version. Looking at the output of `cat /etc/*release` is usually fine, because it is OK in most Linux distributions.
Can someone test Excel on Windows with this function and tell us what they get back?
Hossein, most Linux systems are using systemd, so it is best to look at /etc/os-release; then fall back to lsb_release; if that doesn't work (there will be distros out there that don't support this - yes they are oddball) then we can fall back to just the kernel version.
Regina, sorry missed your comment. Do we want to implement precisely what Microsoft provides, or do we want the more detailed version information we provide in Application::GetOSVersion() for Windows?
The outcome at ESC just now is: noone uses Excel on Linux, probably not important.
The same in Version: 7.5.3.2 (X86_64) / LibreOffice Community Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3 CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded