Issue 88775 - Using Text Values in Formulas
Summary: Using Text Values in Formulas
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.4.0
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Keywords: oooqa
Depends on:
Reported: 2008-04-27 10:29 UTC by mdevenish
Modified: 2008-04-27 13:09 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Sample Excel file with text added to number (13.50 KB, application/
2008-04-27 10:32 UTC, mdevenish
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description mdevenish 2008-04-27 10:29:19 UTC
Excel seems to try and convert text to a value automatically when a mathematical
formula is applied to a cell which contains a text value. The current version of
OOo either ignores the text or treats it as zero.

In the attached sample excel file, the text value "1" in cell A2 is added to the
numerical value 2 in cell A3 and the result displayed in cell A4. In excel the
value in cell A4 is '3'.
In OOo 2.4.0 and 2.3.0 (also OOo3devM7) the result is '2' since the text value
in cell A2 is treated as zero. In the ubuntu build of OOo 2.4 (2.4.0-3ubuntu6)
the result in cell A4 is 'Err:529'. If the Value() function is applied to the
value in cell A2 the result is '3' as expected.

This error could be confusing for those switching from excel (I noticed it when
opening an excel file from work which is more detailed than the example - not a
good way to set up a spreadsheet but it works in excel). I think it would be
helpful if OOo was to attempt to automatically apply the value() function to
text, although it is more strictly correct to display the error as in the ubuntu
Comment 1 mdevenish 2008-04-27 10:32:18 UTC
Created attachment 53223 [details]
Sample Excel file with text added to number
Comment 2 Regina Henschel 2008-04-27 13:09:03 UTC
That is a very old problem, see issue 5658.

*** This issue has been marked as a duplicate of 5658 ***
Comment 3 Regina Henschel 2008-04-27 13:09:33 UTC
closing duplicate