Apache OpenOffice (AOO) Bugzilla – Issue 58183
Error 504 with DSUM function
Last modified: 2008-11-24 01:51:04 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).
Created attachment 31637 [details] .ods document
added me on CC Using the attached document, issue confirmed : I have verified format, formulas ..etc and found nothing ? Waiting, Happy New year !
Hi, tried to reproduce with internal m154 build and could not reproduce. So I close this Issue as worksforme. Frank
closed wfm
*** Issue 77107 has been marked as a duplicate of this issue. ***
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.
Can someone please re-open this issue, or tell me what I should do to have this re-opened?
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.