To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=80985
Issue #|80985
Summary|using Hex data into Calc
Component|Spreadsheet
Version|OOo 2.2
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|ENHANCEMENT
Priority|P3
Subcomponent|formatting
Assigned to|spreadsheet
Reported by|npendleton
------- Additional comments from [EMAIL PROTECTED] Thu Aug 23 20:30:36 +0000
2007 -------
Calc should have "Format > Cells > Other Bases" to permit easy entry and
manipulation of HexDecimal data. If you have Mac Address, IP6 addresses, memory
address, or web colors, the data is provided in Hex. Currently text cell is the
only format support. Validation, export and reformatting would be handy
features, such as adding prefixes such as "0x", zero padding, and the like.
The current work around is clumsy [dec2hex() and hex2dec()], requiring import
hex data in one column and a second column with hex2dec(celladdress), to convert
hex to decimal, and computation in decimal.
In cell manipulation:
The default functions called from "f(x)" button use single quotes, not double
quotes, so the function breaks!
hex2dec('ff') = 0 or #Value!
hex2dec("ff") = 255
and no quotes hex2dec(celladdress) works.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
