109165 – Behavior of calculation with text cell.

Issue 109165 - Behavior of calculation with text cell.

Summary: Behavior of calculation with text cell.

Status:	CLOSED WONT_FIX

Alias:	None

Product:	Calc
Classification:	Application
Component:	editing (show other issues)
Version:	OOO320m12
Hardware:	Unknown All

Importance:	P3 Trivial (vote)
Target Milestone:	---
Assignee:	spreadsheet
QA Contact:	issues@sc

URL:
Keywords:	oooqa

Duplicates (1):	110123 (view as issue list)
Depends on:
Blocks:

Reported:	2010-02-11 18:28 UTC by jmaguro
Modified:	2013-12-17 13:58 UTC (History)
CC List:	2 users (show)

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

Attachments
sumple of Behavior (77.56 KB, application/vnd.sun.xml.calc) 2010-02-11 18:38 UTC, jmaguro	no flags	Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.

Description jmaguro 2010-02-11 18:28:10 UTC

Different Behavior of calculation with text cell between OOo3.1.1 and 3.2.0.

Calculation of the text cell outputs 0 in 3.1.1. 
But,Calculation of the text cell outputs #VALUE in 3.2.0. 

look at attached file.

Comment 1 jmaguro 2010-02-11 18:38:15 UTC

Created attachment 67759 [details]
sumple of Behavior

Comment 2 niklas.nebel 2010-02-12 10:10:11 UTC

This change is intentional, see
http://www.openoffice.org/dev_docs/features/3.2/#calc_strings,
http://www.openoffice.org/servlets/ReadMsg?list=allfeatures&msgNo=3523 and issue
5658.

Comment 3 Rainer Bielefeld 2010-03-02 06:09:25 UTC

*** Issue 109721 has been marked as a duplicate of this issue. ***

Comment 4 Rainer Bielefeld 2010-03-02 06:14:42 UTC

No new arguments, so closed

Comment 5 Rainer Bielefeld 2010-03-02 21:54:57 UTC

*** Issue 109721 has been marked as a duplicate of this issue. ***

Comment 6 Rainer Bielefeld 2010-03-02 21:59:01 UTC

Testing with attachment for Issue 109721 issue I see that my MS EXCEL VIEWER
handles that like OOo 3.1, not like 3.2.! Have there be any comparisons with
other spreadsheet software before that change? Have there been any UX comments?

Comment 7 Rainer Bielefeld 2010-03-16 13:40:20 UTC

*** Issue 110123 has been marked as a duplicate of this issue. ***

Comment 8 Rainer Bielefeld 2010-06-26 08:51:18 UTC

In between we had some discussion in Issue 109721 with many new points of view,
it seems that the WONTFIX decision was overhasty. May be the new behaviour is
intended, but intention seems to be wrong, pls see Issue 109721.