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