[Bug 148184] FORMATTING create a means to represent an integer as an IP Address

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=148184

--- Comment #5 from VGP <umineiro at gmail.com> ---
(In reply to csongor from comment #2)
> I came here to read the motivation behind this feature request. 
> 
> I cannot see too many reasons why someone would store an IP address as an
> integer rather than a string. I had only one idea: creating subsequent IP
> addresses via autofill. To me, it looks like a very rare edge case and I
> would rather do it by this formula in A2 to convert the integer of A1:
> 
> =TEXTJOIN(".", 0, 
> BITRSHIFT(A1, 24), 
> BITAND(BITRSHIFT(A1, 16), 255), 
> BITAND(BITRSHIFT(A1, 8), 255), 
> BITAND(A1, 255)
> )
> 
> I may be wrong and there can be more valid use cases. If this is the case,
> could you show some, please?

For one, one may be able to setup a IP Address Management for a few separate
office in a single spreadsheet without the need to install a whole system and a
database to do it.

For another, one cannot order subnetted IP ranges with the TEXTJOIN function
you suggested.

-- 
You are receiving this mail because:
You are on the CC list for the bug.