Issue 56034 - Calulating with text-fields containing numbers
Summary: Calulating with text-fields containing numbers
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOO 2.0 Beta2
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Keywords: oooqa
Depends on:
Reported: 2005-10-14 21:25 UTC by beckerma
Modified: 2005-10-14 22:05 UTC (History)
2 users (show)

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

Test Spreadsheet (13.50 KB, application/
2005-10-14 21:25 UTC, beckerma
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description beckerma 2005-10-14 21:25:07 UTC
In contrast to Microsoft EXCEL OOo does not compute fields that contain numbers
entered as text with leading apostrophe (i.e. '753).
Comment 1 beckerma 2005-10-14 21:25:54 UTC
Created attachment 30460 [details]
Test Spreadsheet
Comment 2 Regina Henschel 2005-10-14 22:05:14 UTC
You are right, OOo will not calculate with text. Please see the discussion in
issue 5658.

*** This issue has been marked as a duplicate of 5658 ***
Comment 3 Regina Henschel 2005-10-14 22:05:49 UTC
closing duplicate