To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=105039
User regina changed the following:
What |Old value |New value
================================================================================
CC|'' |'regina'
--------------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
Resolution| |WORKSFORME
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Sun Sep 13 16:11:58
+0000 2009 -------
Inside BASIC all numbers have to be written with a dot as decimal delimiter.
They will be changed to the local format, when the values are entered into the
cell.
If you will compose a string for to use as formula, you cannot take the value of
the cell directly, but you have to convert it to a string inside the macro to
convert the local format to the "decimal dot" format.
The #Name? error is not because of e instead of E but because of a wrong decimal
delimiter.
So you have to decide to use either the standard form of formulas with "decimal
dot" or to use the local form of formulas with local form of decimal delimiter.
To make documents portable, you should not use FormulaLocal.
---------------------------------------------------------------------
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]
