Re: [libreoffice-users] Re: [3.5.3.2/Calc] Multiply percentage with fraction?

At 18:55 09/07/2012 +0200, Andreas Säger wrote:
> At 08:54 09/07/2012 -0400, Dan Lewis wrote:
> > Have you formatted your C1 and C2 columns correctly?
>
> The OP gets the #NAME error.
> What is a correctly formatted cell?
> Can you demonstrate us a single case where any 
> formatting attribute has any influence on the cell value?

[Shoots hand into the air.]  Oh, sir!  Please, sir!  I know, sir!

If you enter, say "1.23%" into a cell with 
numeric or general formatting, you get a number 
with the expected value and expressed as a 
percentage.  But if the cell is previously 
formatted as text, you get the text string 
"1.23%", which is, of course, different.  In 
contexts where the numerical value of a text 
string is taken as zero in a calculation, there will indeed be a difference.

Now you'll say that this sort of formatting in 
advance was not what you meant, and that may be 
so.  But it *is* what your questioner may have meant.

Brian Barker


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