https://bugs.documentfoundation.org/show_bug.cgi?id=148184
Bug ID: 148184 Summary: FORMATTING create a means to represent an integer as an IP Address Product: LibreOffice Version: unspecified Hardware: All OS: All Status: UNCONFIRMED Severity: enhancement Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: umine...@gmail.com An IP address, be it an IPv4 or IPv6 is an integer number, being a 32bit integer if IPv4 or a 128bit if IPv6. Since Calc is well suited to perform number operations, it would be nice to add a formatting option to represent an integer as an Human readable IP Address and to accept a valid IP address and stora in the cell as an integer, as it is done with the DATE and TIME formats. There is an excelent set of Libreoffice Basic functions from Thomas Rohmer-Kretz in http://trk.free.fr/ipcalc/ to perform this task among various other IP related functions, but it would be better to have a native conversion in place, since going the Basic functions way is slow and cumbersome. Alternatively, a means to create a personalized format representation with a module function would be also be a way to enhance the personalized format feature. -- You are receiving this mail because: You are the assignee for the bug.