incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject [Bug 120063] DSUM function locked
Date Sat, 23 Jun 2012 12:28:11 GMT

Regina Henschel <> changed:

           What    |Removed                     |Added
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |
         Resolution|---                         |INVALID

--- Comment #1 from Regina Henschel <> ---
The search criteria for field "age" and "Distance to School" contain a space
character. That space character does not match any row in the database,
therefore the sum is zero.
Remove the space characters to make the cells empty and DSUM works as expected.

Tip: Use Find&Replace with 'Find All' with a space character in 'Search for'
and checked 'Entire cells' to mark all those cells which contain such-otherwise
not visible-space character.

You are receiving this mail because:
You are the assignee for the bug.

View raw message