So sorry for the late reply, it got lost in the flood of mail. I have to figure 
out to better organize my mail.  

I figured it out, I don't know why or how but Cell Format was set in Boolean 
Value.  

Jack

Mon, 29 Aug 2011 03:46:00 -0700
Am 29.08.2011 09:13, nvrk wrote: 
Do you think that this could be a cell format problem?
nvsoar Could be. Nobody can tell without any data nor formulas from 
the original poster. Unlike Excel, the boolean data type is just a subtype of 
the decimal type. The number format "BOOLEAN" displays any non-zero number as 
TRUE and all the rest as FALSE. In Excel there is a separate boolean data type, 
so TRUE and FALSE are never equal to any number.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Reply via email to