Issue 58183

Summary: Error 504 with DSUM function
Product: Calc Reporter: jpaulblanc <jpolblanc>
Component: codeAssignee: spreadsheet <spreadsheet>
Status: CLOSED IRREPRODUCIBLE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: dumbledore, eric.bachard, issues
Version: OOo 2.0   
Target Milestone: ---   
Hardware: Mac   
OS: Mac OS X, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
.ods document none

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 
Hi,

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

Frank
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
re-opened?
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.