Issue 32483 - =sum(a1:a2:a3) displays #NAME
Summary: =sum(a1:a2:a3) displays #NAME
Status: CLOSED DUPLICATE of issue 4904
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 680m47
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: ms_interoperability
Depends on:
Blocks:
 
Reported: 2004-08-03 07:33 UTC by dankegel
Modified: 2004-08-06 06:52 UTC (History)
1 user (show)

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

Attachments
Tiny spreadsheet demonstrating =sum(a1:a2:a3) problem (13.50 KB, application/vnd.ms-excel)
2004-08-03 07:34 UTC, dankegel 		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 dankegel 2004-08-03 07:33:53 UTC 
Formulae in Excel '97 spreadsheets
like =sum(a1:a2:a3) and =sum(d23,d7) display as #NAME
in OpenOffice, both 1.1.2 and 680m47.
Comment 1 dankegel 2004-08-03 07:34:55 UTC 
Created attachment 16903 [details]
Tiny spreadsheet demonstrating =sum(a1:a2:a3) problem
Comment 2 dankegel 2004-08-03 07:35:52 UTC 
Note: this happened to me in real life.  My wife sent me
a spreadsheet of our family finances.  To my horror, it
didn't display right in OpenOffice, but it displayed fine
in Microsoft Office and in Gnumeric.
Comment 3 frank 2004-08-03 09:57:45 UTC 
Hi,

according to the Calc core developer this is a double to Issue 4904.

BTW this looks really weird. Why should I use to ranges instead of one ?

Frank

*** This issue has been marked as a duplicate of 4904 ***
Comment 4 frank 2004-08-03 09:58:11 UTC 
closed double