I put another workaround example on the bug -- https://bugs.freedesktop.org/show_bug.cgi?id=37860 Can reuse same condition that determines whether source term is Blank or Numeric. I fully appreciate attempts to improve VBA interop as this is the way LO can gain placement on the myriad desktops stalling at XP waiting for a better solution than tithing to M$0. The Basic module has VBA_Interop (sp?) flag(s?) but in some places they make the Basic core logic more complex and hard to understand/maintain. I am all for a standard solution that treats empty strings, blanks strings and all other nothings as zeros in math context, but see the need for the VBA style results as well, however bizarre they are. Dang needy M$ - nothing is not acceptable - give me VALUE NOW!!! :-0 jlc -- View this message in context: http://nabble.documentfoundation.org/Simple-solution-to-avoid-VALUE-required-tp3030643p3038328.html Sent from the Discuss mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to discuss+help@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted