Re: [libreoffice-users] treatment of blank cells

On 08/19/2013 03:10 PM, Gregory Smith - Oracle Sparc Verification wrote:
>  I am disappointed that Libre Office does not treat blank cells as a 
> zero in math calculations.  I have a dozen spreadsheets from Excel and 
> Open Office that take advantage of this fact.  Now I get errors with 
> Libre Office.  Going back and retrofitting n(cell reference) to 
> achieve the translation is a ton of extra work.  Am I missing something.
>
> gs

I'm not sure what you're missing, but my LO spreadsheets always treat 
blank cells as zeros. I'm not that well versed in spreadsheets, but I've 
never had the problem you describe.

Virgil

--
To unsubscribe e-mail to: users+unsubscribe@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