[libreoffice-users] Sum of sub-section: Calc named row/column error (bug, feature or wrongfull implementation?)

Hello 

v4.2 (Calc made in Lo 4.0 or 3.6)

I have a spreadsheet where I list expenses by year, with subsections for
months that I want the sum of. 

In LO Calc I named rows so I could use the OFFSET formula to make sure that
sum calculations would always include inserted rows. According to tutorials
this was the advised way for older pre-table Excel versions. I never used
Excel much, but I assumed this should work in Calc too. 


=SUM((OFFSET(Feb2013!Overig;-1;0)):(OFFSET(Jan2013!Overig;1;0)))
Takes the sum between  row Feb 2013 and  jan2013 in column Overig

While the formula itself works, it's intended implementation does not. 
Because when adding a column later, it gives a reverence error. 
Because the name for the row is assigned from 
$Uitgaven2013.$A$7:$AMJ$7
So when adding a column, it wants to more ^AMJ one up, except because the
entire row was named, that is of course the last column. 
So that gives the name range an error, which is moved to the fomula, which
defeats the entire purpose. 


(adding a row does not work either, but I have not yet tried to find out
why)


Does anyone know if I am just doing this wrong and knows where I can find
the Calc way, or if I should file a bug report for this?

Thanks in advance (and more after solving)

MBB



--
View this message in context: 
http://nabble.documentfoundation.org/Sum-of-sub-section-Calc-named-row-column-error-bug-feature-or-wrongfull-implementation-tp4103196.html
Sent from the Users mailing list archive at Nabble.com.

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