You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/06/23 14:28:11 UTC

[Bug 120063] DSUM function locked

https://issues.apache.org/ooo/show_bug.cgi?id=120063

Regina Henschel <rb...@t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |rb.henschel@t-online.de
         Resolution|---                         |INVALID

--- Comment #1 from Regina Henschel <rb...@t-online.de> ---
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.