To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=4904
------- Additional comments from [EMAIL PROTECTED] Sat Jan 14 19:26:11 -0800
2006 -------
Perhaps this is unnecessary effort, but I spent tonite looking back at all the
other issues closed into this one, in order to understand the problem. It
helped. With 22 other issues (so far) combined into this one, I decided it
might help generate movement on this if all of that history was summarized
below:
Issues Problem
4904 (May 2002)(empii)
Cell C9 has name defined "test1"
Cells c10,c11 contain 1(numeric value)
cell d9 contains formula =SUM(test1:c11)
Cell d9 results "#NAME?"
Neither the SUM nor the COUNT functions respect references
to named cells.
5052 (Jul 2002)(empii)
Excel allows using named ranges in formulas. When importing Excel
sheets that use this feature formulas get screwed up.
11799 (Feb 2003)(jwlemke)
The following cell contents works fine with Excel, but gives an
error 508 with OO.
=SUM(INDIRECT("C"&F8+1):C8)
The only way I've found to make this work with OO is:
=SUM(INDIRECT("C"&F8+1&":C8"))
20587 (Oct 2003)(timdeaton)
Column F contains the following formula:
(row 8): =IF(E8=0,"",F$6+SUM(E$7:OFFSET(F8,0,-1)))
When I open this spreadsheet in OpenOffice.org (version 1.1.0)
the formula is corrupted to read as follows:
(row 8): =IF(E8=0;"";F$6+SUM(#NAME!(E$7;OFFSET(F8;0;-1))))
26004 (Mar 2004)(gardenal)
while Excel allows you to use dynamic ranges in SUM(), Calc does not.
32483 (Aug 2004)(dankegel)
=sum(a1:a2:a3) and =sum(d23,d7) display as #NAME
displayed fine in Microsoft Office and in Gnumeric
37351 (Nov 2004)(micrond)
when importing an Excel spreadsheet containing formula
"=IF(COUNT(C9:E9:G9:I9:K9:M9:O9)=0;"";((C9+E9+G9+I9+K9+M9+O9)/COUNT(C9:E9:G9:I9:K9:M9:O9)))"
in OpenOffice version 680m59 and 1.1, the formula is not imported
properly. The problem seems to be in the enumeration C9:E9:I9:...
that is shown as "#name?(#name?(#name?(..."
38413 (Dec 2004)(urlgrrrl)
The following formula imported from Excel returns Err:508:
=CORREL($G60:INDIRECT(CONCATENATE("g"&F6));H60:INDIRECT(CONCATENATE("h"&F6)))
The problem appears to be with specifying the cell ranges using
INDIRECT. Rewriting the formula as follows does work:
=CORREL($G60:G244;H60:H244)
This problem was reproducted in OOo 2.0 (1.9.62) of 12 Nov.
42678 (Feb 2005)(patrick_catel)
Preliminary note: I am french and use french OOo 1.1.4 version.
Involved function names are SOMME and DECALER in french,
may be SUM and SHIFT in english.
Problem is
SOMME and DECALER functions work separetaly. But to write in a cell
of an OOo calc-sheet =SOMME(A3:DECALER(A8;-1;0)) appears impossible
[the cell references are example] , whatever the way of doing it
(import from Excel sheet or direct typing).
43804 (Mar 2005)(tulitanssi)
The sumif function gives err:508 when args to it are complex,
e.g. indirect function etc.
46210 (Apr 2005)(lucianomw)
The offset function does not return a reference when used as
parameter to another function. This produces an error message in the
cell that was calling the function.
47976 (Apr 2005)(nbwepaul)
Importing a XLS file into OOo Calc it fails to correctly import some
things. It shows Err:508 (Error: in bracketing) instead. It seems to
happen when a range is used that contains a formula rather than a
fixed cell address. This real-life example works in Excel but becomes
Err:508 when imported into Calc:
=SUM($'Dept Sales'.$B119:OFFSET($'Dept Sales'.$B119;0;+($B$3-1);1;1))
48761 (May 2005)(sinewalker)
When entering a cell range into calc for the SUM() function, it does
not parse the colon syntax if I use a reference function such as
INDIRECT(). Non-range formulas do work however.
SUM(INDIRECT(ADDRESS(CELL("ROW";A8);3)):INDIRECT(ADDRESS(CELL("ROW";A10);3)))
results in Err508 (missing parameter).
51186 (Jul 2005)(tommyads)
Enter
=SUM(I2:ADDRESS(ROW()-1;COLUMN();4))
in any cell zzz within column I below row 2.
This should always give the sum of all cells above the cell zzz,
starting from the second row (my first row contains a Header).
But this does not work!!!
53262 (Sep 2005)(opp)
If you use INDIRECT as single arguments it works proper.
If you use INDIRECT within a range-arguments ERR 508 is produced.
53263 (Sep 2005)(opp)
If you use INDEX as single arguments it works proper.
If you use INDEX within a range-arguments ERR 508 is produced.
55662 (Oct 2005)(fuechsel)
DSUM function returns value 'Err:508' under the following conditions:
formula:
=-DSUM(DBASE;"Amount";A19:A20 located on an adjacent worksheet
where: A19 has value "Cd" on the worksheet with the formula
A20 has value "Hi" on the worksheet with the formula
DBASE is a named variable with value START:END
START is a named variable with value $Acounts:$A$1
END is a named variable with value $Acounts:$J$649
Accounts is name of a worksheet in the workbook
Amount is a column heading in 'Accounts'
Cd is a column heading in 'Acounts'
Hi is one of several values appearing in column 'Cd'
55758 (Oct 2005)(patrick_catel)
test made with OOo 2.0 rc2
When I open with OOo an Excel sheet containing
=SUM(B1:OFFSET(B7;-1;0))]
I get
Err :508
56051 (Oct 2005)(cerulli)
Using INDIRECT()location as one of the boundary of a range in SUM,
gives a (misleading) Err:508.
Example =SUM(INDIRECT(I18):E17) where I18 = E14, that should give
the sum in the range (E14:E17), gives an Err:508.
56936 (Oct 2005)(timdeaton)
When I use the Offset() function inside a SUM() function, it results
in an error message. Used in an IF() function, it seems to work
okay. But when I loaded an Excel97 sheet with the formula
=-SUM(H$6:OFFSET(H147;-1;0)) in E147
Yesterday it gave me an "Error 508" message in that and all dependent
cells. Today, the same formula in the same place gave me an "#N/A"
error message.
57341 (Nov 2005)(andypopely)
example cell B16 is assigned a name of Q1Medical and cell B19 is
assigned a name Q1RealEstate. When used in the formula
=SUM(Q1Medical:Q1RealEstate) to add cells B16 thru B19
Calc returns a #NAME? error.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
