23331 – Different cells with the same formula give different results

Issue 23331 - Different cells with the same formula give different results

Summary: Different cells with the same formula give different results

Status:	CLOSED IRREPRODUCIBLE

Alias:	None

Product:	Calc
Classification:	Application
Component:	code (show other issues)
Version:	OOo 1.1
Hardware:	PC Windows 98

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

URL:
Keywords:

Depends on:
Blocks:

Reported:	2003-12-09 06:35 UTC by sgb
Modified:	2003-12-09 11:11 UTC (History)
CC List:	1 user (show)

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

Attachments
Spreadsheet file displaying problem (9.60 KB, application/octet-stream) 2003-12-09 06:36 UTC, sgb	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 sgb 2003-12-09 06:35:02 UTC

On the spreadsheet to be attached, cells M126 and B131 both have the formula "=SUM(B126:K126)", but give different results.

Comment 1 sgb 2003-12-09 06:36:09 UTC

Created attachment 11822 [details]
Spreadsheet file displaying problem

Comment 2 sgb 2003-12-09 10:21:24 UTC

Gah.  Once the problem was saved, it started working fine.  It definitely was happening though, after inserting a few rows.

I'll try to get a reproducable example...

Comment 3 frank 2003-12-09 11:11:14 UTC

I could not reproduce it either.

So closing this one.

Feel free to re-open this Issue if you can reproduce the problem.

Maybe a textvalue contained in the sum range cause such problems. So have a look
at the Value Highlighting feature under the View Menu. Green are formula
results, blue are values and black is text.

Hope this helps.

Frank