How does one format cells in Calc for Hex numbers? There are quite a few included examples for different types of numbers but none for Hex, Octal, or Binary. Is this even possible?
Thanks,
juztreality
No, there are no number formats for other bases. However, you can use the spreadsheet function BASE for this.
There are not such formats, but you can convert the numbers with functions like BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN,HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX. With the function wizard you can look for them easily and call the help.
https://help.libreoffice.org/Calc/Add-in_Functions,_List_of_Analysis_Functions_Part_One
Since this is not the first request in the field and highly appreciated contributors posted answers I will try to draw their attention to this thread in another forum created 13 months ago.
Finding an answer to the question I posted there would open a way to create solutions by user code at least to the not so samll complete field of questions concerning (very) special desired number formats. This without requesting the implementation of a new feature every other day.
(Please note that the code contained in an example attached to the mentioned post is very crude and experimental.)
(There were related topics in the late libreofficeforum.org, here, and also in the forum.openoffice.org/en.)