Issue 58183 - Error 504 with DSUM function
Summary: Error 504 with DSUM function
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0
Hardware: Mac Mac OS X, all
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
: 77107 (view as issue list)
Depends on:
Reported: 2005-11-20 01:34 UTC by jpaulblanc
Modified: 2008-11-24 01:51 UTC (History)
3 users (show)

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

.ods document (17.86 KB, application/vnd.oasis.opendocument.spreadsheet)
2005-11-20 01:36 UTC, jpaulblanc
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description jpaulblanc 2005-11-20 01:34:18 UTC
I want to use a spreadsheet I made three years ago on Excel (it worked then). 
I have in it some DB table and use DSUM (BDSOMME in French). The formula is repeated many times, 
but only the two first times are ok. After that the formula gives an error 504. But I don't see any 
problems with the parameters of the function.
I've seen the issue 24811 (and 3140 and 16689), but it doesn't give a solution in my case.

I want send an attachment with the file that has the problem. The error is in the cell K21 and below.
But I don't find where I could join an attachment (I use Safari on MacOSX).
Comment 1 jpaulblanc 2005-11-20 01:36:09 UTC
Created attachment 31637 [details]
.ods document
Comment 2 eric.bachard 2005-12-31 15:49:24 UTC
added me on CC

Using the attached document, issue confirmed : I have verified format, formulas
..etc and found nothing ? 

Waiting, Happy New year !
Comment 3 frank 2006-01-30 13:32:31 UTC

tried to reproduce with internal m154 build and could not reproduce. So I close
this Issue as worksforme.

Comment 4 frank 2006-01-30 13:34:00 UTC
closed wfm
Comment 5 gercokees 2007-05-09 15:08:46 UTC
*** Issue 77107 has been marked as a duplicate of this issue. ***
Comment 6 albus_dumbledore 2007-05-09 19:04:19 UTC
This problem can be consistently reproduced with OOo 2.x on Mac OS X (PPC).
Please re-open this issue and give it a proper attention.
Comment 7 albus_dumbledore 2007-05-29 18:48:18 UTC
Can someone please re-open this issue, or tell me what I should do to have this
Comment 8 rmst 2008-11-24 01:51:04 UTC
Another, possibly unrelated 504 error.  To reproduce:

1) Format cells in column A as text
2) Enter 

         A          B
   1  314159   =MID(A1;4;1)
   2  ABCDEF   =MID(A2;B1;1)

3) See:

         A         B
   1  314159    1
   2  ABCDEF       Err:504

This works fine in Excel (with commas instead of semicolons in function
arguments - what's the point of this gratuitous incompatibility?)

Running OpenOffice 2.4.0 on Windows XP SP2.