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: [email protected]
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
