Ask Your Question

Calc: Adding cryptographic hash functions [closed]

asked 2013-11-24 12:15:38 +0200

lalle gravatar image

updated 2013-11-25 00:05:36 +0200

oweng gravatar image

Hi, we use several cryptographic functions in our operations, e.g. MD5 to create unique customer IDs (instead of logging original data we store only the hash), or to create one-time passwords where we combine date/time with input from the user. Another common function is of course to calculate file integrity, which many others do too.

The function is already implemneted in an extension to OO3: "Cryptographic Hash Functions UNO Component for" See more at:

We hope it can be added as a native function into Calc and thereby beat the other productivity suites in the market, which is still miss this valuable functionality.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-14 21:30:39.709726

1 Answer

Sort by » oldest newest most voted

answered 2013-11-25 00:17:49 +0200

oweng gravatar image

These types of functions are not specified in ODF v1.2 so would need to be added to the underlying specification before being made available. The only references to "hash" in either ODF v1.2 or ISO/IEC 29500-1 2012 (OOXML) are in relation to file/sheet/range/protection/sharing encryption rather than spreadsheet functions for computing a hash, using "MD2, MD5, SHA-1, SHA-256, SHA-384 [or] SHA-512."

It would be much easier and better for the extension provider to upgrade the extension in question so it works with current versions of AOO/LO (I have not tested it so it may still work). This is what extensions are for: extending the basic capability of a product.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-11-24 12:15:38 +0200

Seen: 7,673 times

Last updated: Nov 25 '13