Re: [libreoffice-users] Do you actually use function INFO in Calc?

For me, the osversion shows Windows 32bit, but I"m on Ubuntu 20.04.

When I tested it, I had a LibreOffice spreadsheet already open that is
probably old enough  (20 years?) that it might have originally been created
on OpenOffice/windows 32... but there's no windows in my house for the last
decade.

So, Is Info pulling from the file for the system, or actually doing a
system request? (and if it's pulling from the file.... i don't see the
point unless there's another that shows the current OS ... )



On Sun, Mar 1, 2026 at 12:32 PM Fred James <fredjame@fredjame.net> wrote:

> I found this in "LibreOffice Help - LibreOffice Calc"
> Regards
> Fred James
>
> INFO
>
> Returns specific information about the current working environment. The
> function receives a single text argument and returns data depending on
> that parameter.
>
> This function is always recalculated whenever a recalculation occurs.
>
> Syntax
>
> INFO("Type")
>
> The following table lists the values for the text parameter Type and the
> return values of the INFO function.
>
> Value for "Type"
>
>
>
> Return value
>
> "osversion"
>
>
>
> Always "Windows (32-bit) NT 5.01", for compatibility reasons
>
> "system"
>
>
>
> The type of the operating system:
> "ANDROID" for Google mobile operating system
> "DRAGONFLY" for DragonFly operating system forked from FreeBSD
> "EMSCRIPTEN" for browser WebAssembly system
> "FREEBSD", "OPENBSD" or "NETBSD" for operating systems based on the
> Berkeley Software Distribution (BSD)
> "HAIKU" for BeOS compatible operating system
> "iOS" for Apple mobile operating system
> "LINUX" for GNU/Linux based operating systems
> "MACOSX" for Apple macOS
> "SOLARIS" for Oracle Solaris operating system
> "WNT" for Microsoft Windows
>
> "release"
>
>
>
> The product release identifier, for example "300m25(Build:9876)"
>
> "numfile"
>
>
>
> Always 1, for compatibility reasons
>
> "recalc"
>
>
>
> Current formula recalculation mode, either "Automatic" or "Manual"
> (localized into LibreOffice language)
>
>
>
>
> Robert Großkopf wrote:
> > Ho Regina,
> > > Calc provides a function INFO. Do you actually use INFO? If yes,
> > > which parameter do you use? What do you do with the function result?
> >
> > Tested with choosing INFO in the wizard.
> > Values will be "osversion", "system", "release", "numfile" and "recalc".
> >
> > Will show
> > Linux 6.4
> > LINUX
> > 8399f6259d8c87f40e7255cdb3c9b958f5e08948
> > 1
> > Automatisch
> >
> > here on my system
> >
> > Regards
> >
> > Robert
>
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy