https://bugs.documentfoundation.org/show_bug.cgi?id=148184
--- Comment #5 from VGP <[email protected]> --- (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 the assignee for the bug.
