To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=96494
Issue #|96494
Summary|Error 504 on substring function
Component|Spreadsheet
Version|OOo 2.4.0
Platform|All
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|code
Assigned to|spreadsheet
Reported by|rmst
------- Additional comments from [EMAIL PROTECTED] Mon Nov 24 02:17:34 +0000
2008 -------
To reproduce error:
1) Format cells in column A as text
2) Enter
A B
1 314159 =MID(A1;4;1)
2 ABCDEF =MID(A2;B1;1)
3) See:
A B
1 314159 1
2 ABCDEF Err:504
This works fine in Excel, displaying "A" in cell B2. Assume the problem is that
Calc will not treat numeric strings as numbers when function argument requires a
number. This is a severe defect - a spreadsheet should not be a strongly-typed.
(Also reported under issue 58183, but that issue is closed and may have nothing
in common with this except the Error 504.)
---------------------------------------------------------------------
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]
