https://bugs.freedesktop.org/show_bug.cgi?id=79475

m.a.riosv <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEEDINFO
                 CC|                            |[email protected]
     Ever confirmed|0                           |1

--- Comment #3 from m.a.riosv <[email protected]> ---
Hi Grant, thanks for reporting.

I think the problem is, if you have in:

E60: SUBTOTAL(9:E1:E59)

copying to a row above the 60 you get the error in the reference, because E1 is
a relative reference and can't be adapted to a row less than 1.

make absolute the initial row in the formula:

E60:  SUBTOTAL(9:E$1:E59)

and try to copy.

Please lets us know if this solves your issue.

If not, can you attach a sample file and detail copy steps?

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to