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.
