SOLVED DSUM function ot working properly

[Wayne Hammond]

I developed a somewhat complex spreadsheet using DSUM to calculate values for maintenance hours each week in Excel. I attempted to open the spreadsheet in Calc several times and the DSUM is not working as intended. I have a large table downloaded from a corporate server and pasted into a worksheet. The table is named and called on another worksheet in a series of values, each having a different value to be totaled. The first row of calculated values is correct, the second and subsequent rows in a series have Err504 in the cells. The strange pat is that the next series is a duplicate of the first as far as appearance goes, the first row appears correct and the next and subsequent rows in that series have Err504. This behavior is the same for the entire sheet.

I went back and reviewed the headers of each line in the DSUM parameters. As it turns out, the header row must contain the same text as the first row in the data table. In Excel, if a cell is blank there is no error, but in Calc, a Err:504 is generated.

Thank's for reviewing the issue.

[Villeroy]