[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 #2 from csongor at halmai.hu ---
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?

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