incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 120063] DSUM function locked
Date Sat, 23 Jun 2012 12:28:11 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=120063

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

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

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

Mime
View raw message