Re: [libreoffice-users] Weird Named Range Error

At 20:23 11/02/2016 -0500, Joshua Kramer wrote:
> I'm wondering if someone can please take a look at the attached sheet.

No! Attached files are generally removed by the mailing list 
processor before messages are distributed. So no-one will have seen 
your document or be able to see what you mean.

> [...] On line 45, there are totals for the named ranges. However, 
> for some reason, any numbers entered into lines 35-42 do not get 
> added into those totals. Can anyone determine why?

One obvious guess is that the relevant cells have been formatted as 
Text before the values were entered or that values that might have 
been pasted in were themselves text, not numbers. Text values are 
treated as zero in numerical formulae, so will be ignored in your totals.

Numbers are right-aligned by default, whereas text values are 
left-aligned, but you may have hidden this distinction by setting the 
cell alignment explicitly.

Note that you can use View | Value Highlighting (probably 
temporarily) to display the difference: numerical values appear in 
blue whereas textual values appear in black (and results of formulae in green).

I trust this helps.

Brian Barker


--
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