Issue 96201 - ip2long() builtin ip address conversion function
Summary: ip2long() builtin ip address conversion function
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 2.4.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL: http://gurubert.de/openoffice.org/ip2...
Keywords:
Depends on:
Blocks:
 
Reported: 2008-11-14 08:39 UTC by gurubert
Modified: 2013-02-07 22:37 UTC (History)
3 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description gurubert 2008-11-14 08:39:24 UTC 
Hi,

I am handling spreadsheets with computer inventory data from our CMDB on a 
regular basis. I need to sort the data by IP address. I have written a user 
defined macro function to accomplish this task as there is no natural sort 
order for IP addresses (see also issue #26565).

I would be nice to have ip2long() and long2ip() built into the Spreadsheet 
component.
Comment 1 frank 2008-11-14 09:11:21 UTC 
Hi Daniel,

please take over this one.

Frank
Comment 2 daniel.rentz 2008-11-14 09:31:49 UTC 
dr->er: new functions? please have a look... maybe an add-in is better here.
Comment 3 ooo 2008-11-14 11:45:47 UTC 
An Add-In would do as well. However, this is an RFE and as such I reassign it to
requirements. Target OOo3.x doesn't make sense as long as nobody picks this up.