[sc-issues] [Issue 113409] Unable to use LN (natural logarithm) within Macro
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113409 Issue #|113409 Summary|Unable to use LN (natural logarithm) within Macro Component|Spreadsheet Version|1.0.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|jenf --- Additional comments from j...@openoffice.org Sun Jul 25 11:57:38 + 2010 --- The LN-function can not be used in Macros, the following fails with a runtime-error: Function HellWorld(abc) HellWorld = LN(abc) End Function - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 113409] Unable to use LN (natural logarithm) within Macro
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113409 User jenf changed the following: What|Old value |New value Version|1.0.0 |OOo 3.2.1 --- Additional comments from j...@openoffice.org Sun Jul 25 12:02:08 + 2010 --- For a Workaround, the following function can be used within the Marco: Function LN(x) LN=LOG(x)/LOG(EXP(1)) End Function - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 113409] Unable to use LN (natural logarithm) within Macro
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113409 User regina changed the following: What|Old value |New value CC|''|'regina' Component|Spreadsheet |api Status|UNCONFIRMED |RESOLVED Keywords| |oooqa QA contact|iss...@sc |iss...@api Resolution| |WORKSFORME Subcomponent|programming |code --- Additional comments from reg...@openoffice.org Sun Jul 25 20:07:08 + 2010 --- ln is not a Basic function. For a list of existing Basic functions see Content2 Macros and Programming Alphabetic List of Functions, Statements, and Operators in the help. You cannot use Calc functions directly but have to use createUnoService(com.sun.star.sheet.FunctionAccess) - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org