To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95707 Issue #|95707 Summary|addin function that has a ':' in the name doesn't work | in OOo3.0 Component|Spreadsheet Version|OOo 3.0 Platform|Sun URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|randyjones
------- Additional comments from [EMAIL PROTECTED] Fri Oct 31 14:58:51 +0000 2008 ------- I have a calc addin created several years ago (circa 2000) using the xdfa.c and xrot.c examples as starting points. The addin is "installed" by copying the compiled shared lib to OOo_INSTALL_DIR/program/addin/ . After this the addin will show up under the "Add-in" category in Calc by going to "Insert | Function..." and then selecting "Add-in" for the category. To actually use the addin an example would be in cell B1 "=pn_info:descr(A1)". This will then place the description of the part number (contained in cell A1) into cell B1. This addin has functioned perfectly over the years up to and including 00o2.4.1. In OOo3.0 the addin appears in "Insert | Function..." "Add-in" category like it should. However when attempting to actually use the addin [ie =pn_info:descr(A1)] the cell contents read "#NAME?" as if you incorrectly spelled a function name. This addin creates several functions: pn_info:descr(), pn_info:um(), pn_info:price_code(), and so on. If I replace the ':' with a '_' so the function name goes from pn_info:descr() to pn_info_descr() then the addin will function in OO 3.0. This is certainly a workaround. However a very bad workaround because we have hundreds if not thousands of existing OOo spreadsheets that currently use the 9 functions provided by this addin. This would be a huge job to locate all the affected spreadsheets and redo all the formulas. --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]