On 01/31/2016 05:26 PM, Joshua Kramer wrote:
Hello,
I'm using LO 5.4.0.2 on Linux, and I have some weird spreadsheet behavior.
On one of my spreadsheets, I have a named range. Then I have a cell
below it with the formula =SUM(NamedRange). The cell only picks up
some of the values! There are 33 rows in this range. If I put a 1 in
all of them, the total adds up to 26. If I use the actual cell ranges
instead of the name, it adds the cells properly.
How could the named range be malfunctioning??
Thanks!
If you haven't do so already I would check to see that the named range
actually includes all of the cells.
Regards, Jim
--
To unsubscribe e-mail to: users+unsubscr...@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