UNKN75 function seems to be the @TERM function. Excel converts it from @TERM(a,b,c) to NPER(b, -a, c)
Created attachment 109403 [details] Test file
It should be NPER(b, -a, 0, c) in fact.
Andras Timar committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=70ae5bb4182a99c17da8eb32b36baec3e7a48723 import @TERM and @CTERM functions from Lotus 1-2-3 files (related: fdo#86241) It will be available in 4.5.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
"unkn75" comes from libwps which is an external library (cc Fridrich). If you rename the file to .wk1 extension, then internal Lotus filter will be invoked, which can import @TERM and @CTERM functions after my patch (sse above).
Andras Timar committed a patch related to this issue. It has been pushed to "libreoffice-4-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=48801843d65ffa3e31196cabb36c597ff81c6d07&h=libreoffice-4-3 import @TERM and @CTERM functions from Lotus 1-2-3 files (related: fdo#86241) It will be available in 4.3.6. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
(In reply to Andras Timar from comment #4) > "unkn75" comes from libwps which is an external library (cc Fridrich). If > you rename the file to .wk1 extension, then internal Lotus filter will be > invoked, which can import @TERM and @CTERM functions after my patch (sse > above). Concerning libwps, I just commit a patch to treat the TERM and CTERM functions: https://sourceforge.net/p/libwps/code/ci/54a904f5144993d8a2e88aeebe11394053ac62d6 ...
(In reply to osnola from comment #6) > Concerning libwps, I just commit a patch to treat the TERM and CTERM > functions: > https://sourceforge.net/p/libwps/code/ci/ > 54a904f5144993d8a2e88aeebe11394053ac62d6 > ... Thanks, I mark this as RESOLVED FIXED then.