@aengelriv
Did you note that I included code completely avoiding the usage of Calc functions? Simply omit the two functions based on FunctionAccess and the parts of the Sub callimg them. I only included this part with respect to earlier posts in this thred.
The replacing functions do not contain any problematic code. No errors expected insofar!
See new attachment.
@Villeroy
Yes, your code is surely useful, and I didn't know that way to get the cell under focus. Thanks. In fact I get the fully qualified names for the functions under discussion this way, but
You get the full name of certain functions that are not part of the Open Document standard like this:
The (pseudo-) type
Complex and many related functions are specified in the respective OpenFormula document
http://docs.oasis-open.org/office/v1.2/ ... -part2.odt under "4.4 Complex Number" and under
"2.3.4 OpenDocument Formula Large Group Evaluator"
COMPLEX 6.8.2 ; IMABS 6.8.3 ; IMAGINARY 6.8.4 ; IMARGUMENT 6.8.5 ;
IMCONJUGATE 6.8.6 ; IMCOS 6.8.7 ; IMCOT 6.8.9 ; IMCSC 6.8.10 ; IMCSCH 6.8.11 ; IMDIV
6.8.12 ; IMEXP 6.8.13 ; IMLN 6.8.14 ; IMLOG10 6.8.15 ; IMLOG2 6.8.16 ; IMPOWER 6.8.17 ;
IMPRODUCT 6.8.18 ; IMREAL 6.8.19 ; IMSEC 6.8.22 ; IMSECH 6.8.23 ; IMSIN 6.8.20 ; IMSQRT
6.8.24 ; IMSUB 6.8.25 ; IMSUM 6.8.26 ; IMTAN 6.8.27
On the other hand the recently (in LibO) impemented functions CONCAT and TEXTJOIN have internal qualified names containing the 'MicroSoft' key in one place. (I haven't them at hand at the moment.)
They are not specified by OpenFormula and only implemented under the general clause for compatibility with Excel. These functions are shown for me by your code with their
short names.
The mystery doesn't just persist. It is growing.
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München