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
Context
- [libreoffice-users] Sum of sub-section: Calc named row/column error (bug, feature or wrongfull implementation?) · MBB
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.