This is absolutely sadistic. And also I think correct , lol
On Mon, Sep 15, 2025 at 3:17 PM Christopher Morrow <[email protected]> wrote: > > =TEXT(BITAND(A1,4278190080)/16777216,"0")&"."&TEXT(BITAND(A1,16711680)/65536,"0")&"."&TEXT(BITAND(A1,65280)/256,"0")&"."&TEXT(BITAND(A1,255),"0") > > apparnetly is inet_ntoa maybe? :) > > On Mon, Sep 15, 2025 at 2:52 PM Tom Beecher via NANOG > <[email protected]> wrote: > > > > If you had to in GSheets, I would just recreate inet_aton and inet_ntoa > in > > Apps Script. It's just bit shifts and ORs, shouldnt be hard. > > > > On Mon, Sep 15, 2025 at 2:31 PM Bryan Fields via NANOG < > > [email protected]> wrote: > > > > > Has anyone found a solution to represent IPv4 addresses in a > spreadsheet, > > > preferably Google Sheets? I'm not here to debate the use of > spreadsheets > > > for > > > tracking IP addresses, just find something better than storing v4 > dotted > > > decimal as text in a spreadsheet. We don't need v6 at this time; we're > > > using > > > a spreadsheet for tracking addressing, v6 is beyond us. > > > > > > At minimum we need to store it as a 32 bit INT, and display as dotted > > > decimal. > > > If there's some way to make it aware of subnet slash notation, so > much > > > the > > > better. I'm a bit at a loss as to why there's no IPv4 number format > with > > > how > > > often spreadsheets are the source of truth in some rather large service > > > providers. > > > > > > Again, not looking for non-spreadsheet solutions to this, and ideally a > > > web > > > interface spreadsheet would be best for sharing. We don't need a real > > > database if it's on the web :-) > > > > > > -- > > > Bryan Fields > > > > > > 727-409-1194 - Voice > > > http://bryanfields.net > > > > > > _______________________________________________ > > > NANOG mailing list > > > > > > > https://lists.nanog.org/archives/list/[email protected]/message/VDO2LGNHKC3XXZQEL2ATCRELA6RUFY5H/ > > > > > _______________________________________________ > > NANOG mailing list > > > https://lists.nanog.org/archives/list/[email protected]/message/D7ZEVMHZ77EJIVKUGVA26CRYQLW3J3PE/ > _______________________________________________ NANOG mailing list https://lists.nanog.org/archives/list/[email protected]/message/MNPJNZVCFDKCEBCMQ3YR3WP55DMZDJ6N/
