Apache OpenOffice (AOO) Bugzilla – Issue 111609
ODFF: implement missing imaginary functions
Last modified: 2022-10-28 12:54:25 UTC
The ODF formula 1.2 spec specifies some complex number functions which are not yet implemented in OOo: IMCOSH, IMCOT, IMCSC, IMCSCH, IMSEC, IMSECH, IMSINH, IMTAN. (IMSINH and IMCOSH are not yet contained in the draft, but I consider this an error in the draft spec.) Those functions are useful because it is cumbersome to combine them out of the existing ones. For example to get =IMSINH(A1) you would need =IMDIV(IMSUM(IMSUB(IMEXP(A1);IMEXP(-A1)));2)
Created attachment 70041 [details] draft, intermediate version
Created attachment 70042 [details] summary of my tests
Created attachment 78076 [details] adds IMTAN,IMSEC,IMCSC,IMCOT,IMSINH,IMCOSH,IMSECH,,IMCSCH The attachment contains my final version. Please review especially the texts for the application help.
I have reviewed the patch and it looks good to me, nice work
Committed to trunk with r1348096
Resolved in LibreOffice 3.6: https://bugs.freedesktop.org/show_bug.cgi?id=51017
Updated target to release that will contain the enhancement.