Hi Frank,
Thanks for looking at this.
This is an Excel-to-OpenOffice gotcha - currency is treated as numeric in Excel/VBA, which is where this macro was originally written. However, what you say makes sense, now the behaviour of the Currency type is defined in this way.
May I suggest a small enhancement to the online help to describe this behaviour, particularly as it differs from VBA in a way that some users converting from MS Office may not expect? I did read the help when I had this issue, but I found nothing to suggest I was using the wrong data type.
Once again, thanks!
Regards,
Craig Bourner
On 11 Nov 2005 15:23:25 -0000, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=56479
User fst changed the following:
What |Old value |New value
================================================================================
Status|RESOLVED |CLOSED
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Fri Nov 11 07:23:24 -0800 2005 -------
closed invalid
---------------------------------------------------------------------
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
--
Craig Bourner
Melbourne, Australia
[EMAIL PROTECTED]
+61 3 9012 5291