To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56479 Issue #:|56479 Summary:|Cell format ignored where user-function returning |currency type used Component:|Spreadsheet Version:|OOo 2.0 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|programming Assigned to:|spreadsheet Reported by:|cbourner
------- Additional comments from [EMAIL PROTECTED] Sun Oct 23 05:29:44 -0700 2005 ------- I have found that if a cell in a spreadsheet is calculated using a call to an OfficeBasic function which returns a Currency type, formatting the cell as Currency does not result in a $ sign being displayed and only two decimal places. For example: =CALCPAYGTAX(100,0,2005) may return 31.0000, which is displayed in the cell. Setting the cell (or column) formatting to Currency does not change the appearance. However, it is possible to work around this by changing the expression to: =CALCPAYGTAX(100,0,2005)*1 In this case, the cell formatting is now correct. --------------------------------------------------------------------- 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]