[libreoffice-users] Weird Named Range Error

Hello,

I'm wondering if someone can please take a look at the attached sheet.
Specifically, columns B and C.  Note that the named range
"ExpensesPlanned" is B9-B42; "ExpensesActual" is C9-C42.  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?

(Note that there is a macro: it's a Python script that will calculate
the week ending dates for all biweekly pay periods and create
corresponding worksheets.)

Thanks!
-JK

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