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