To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108385
User regina changed the following:
What |Old value |New value
================================================================================
CC|'' |'regina'
--------------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |WORKSFORME
--------------------------------------------------------------------------------
Summary| function text does not wo|function text does not wor
|rk correctly |k correctly
--------------------------------------------------------------------------------
------- Additional comments from reg...@openoffice.org Sun Jan 17 13:00:05
+0000 2010 -------
The TEXT function requires a number as first parameter, but the result of the
MID function is a text. So before you can use the TEXT function you have to
convert the result of the MID function to a number. You can use the VALUE or the
DATEVALUE function for converting.
Please try to get help in a forum or mailing list before assuming a bug.
---------------------------------------------------------------------
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
