Issue 24811 - Use of DSUM formula with a Calc database (cells in a spreadsheet) results in erroneously reporting Err504:Error in parameter list.
Summary: Use of DSUM formula with a Calc database (cells in a spreadsheet) results in ...
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.1
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: niklas.nebel
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-01-25 17:49 UTC by bicho
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

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

Attachments
Spreadsheet used to reproduce error (8.35 KB, application/vnd.sun.xml.writer)
2004-01-30 03:02 UTC, bicho 		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 bicho 2004-01-25 17:49:42 UTC 
I started populating calc database with information. Then I created a database
field area and set a search criteria to be used in DSUM. DSUM worked jsut fine,
but after I addded more rows to the database (without changing the DSUM
formula), OpenOffice reported an Err504 message! I exported the file to Excel
format and used it on a Windows XP machine and it worked fine. It seems to me
that there is a problem with DSUM or with the way Calc references other cells.
Comment 1 frank 2004-01-26 09:41:08 UTC 
Hi,

this is not a valid bugreport. You're just describing what happened but not how
to reproduce it. 

So please attach a document that shows your problem and describe step by step
what leads to it.

Otherwise I have to close this as Invalid.

Also OOo1.0.1 is a quite old version. I recommend to update to OOo1.1.

Frank
Comment 2 bicho 2004-01-30 03:02:00 UTC 
Created attachment 12799 [details]
Spreadsheet used to reproduce error
Comment 3 bicho 2004-01-30 03:17:47 UTC 
Frank, 

I got to reproduce the problem. I sent you an attachment with the spreadsheet file. 
In the only tab in the spreadsheet you can see that on Cell c58 there is a DSUM
formula referring to the "database" above (january name) and the seach creteria
in rows 55 and 56. This cell should be reporting "Err:504".

To "remove" the problem, copy the heading (of the database) located A4:G4 onto
A55:G55 which is the heading for the search criteria. Tha should be resolve the
problem. The cell C58 should now display $126.58.

I want it to tell you that the original spreadsheet without any changes works
just fine in MS Excel. Also, you can undo the changes described above and verify
that the heading in row 4 and 55 are identical!

Another thing: I installed OpenOffice 1.1 and did the above test using that
version. I guess is the same for version 1.01.

Finally, I want to tell you that when you split the screen by dragging the bar
on the top of the project and you click on a cell on the bottom part, the cell
does not get selected for edition.

Any clue?

Thanks!
Comment 4 frank 2004-01-30 09:11:18 UTC 
Hi Niklas,

I couldn't find any differences in the strings (A4:G4 and A55:G55) please have a
look at this.

Frank
Comment 5 niklas.nebel 2004-02-02 10:52:56 UTC 
B55 contains text "Type", leading to an invalid query.
Comment 6 niklas.nebel 2004-02-02 10:53:41 UTC 
closing.