[Libreoffice-bugs] [Bug 141271] New: SUM function not always automatically changing as new row added

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=141271

            Bug ID: 141271
           Summary: SUM function not always automatically changing as new
                    row added
           Product: LibreOffice
           Version: 7.0.3.1 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: reay.jespersen at protonmail.com

I've been doing some basic work with Calc, formerly only ever having used
Excel. I was happy to see a couple of days ago that when I had a section of
cells summed up and then retroactively added a new row in the midst of that
section, the SUM functions at the bottom of the columns automated the tweak to
now end on the newer row.

So I was surprised when I did the same thing today and that DIDN'T happen.

The only differences, that I'm aware of, are 1) that the first time I did it,
it was in the midst of the selection of cells being added up--I went into the
middle of them and inserted row--whereas today I was on the row of the totals
instead. And, 2) the first time I added a row, I added a row below the row I
was on, whereas today, I added a row right above the row with all the SUM
functions.



Thanks for your time.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210326/9b6246e0/attachment.htm>