| Summary: | Other: Formula error when copying and pasting a SUBTOTAL formula | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Grant Botes <botes.grant> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | miguelangelrv |
| Priority: | medium | ||
| Version: | 4.2.4.2 release | ||
| Hardware: | Other | ||
| OS: | Linux (All) | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
Source File
Destiny File |
||
|
Description
Grant Botes
2014-05-31 08:28:48 UTC
Hmm, not so sure about this now - this bug appeared for me three times, but suddenly I am unable to duplicate it. Ok, the bug appears again when using Paste, not Paste Special. Subtotal formula doesn't paste over into a new sheet; the formula becomes: =SUBTOTAL(9,E#REF!:E59) 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? Thank you - you have explained it. I was puzzled by the intermittent nature of the problem. Now that you have pointed it out, I realise that is exactly what I was doing - I was pasting data over two rows higher than I was copying it from. Now I just feel embarassed at making such a silly mistake. Don't worry Grant, sometimes we have the issue in front us without see it, and we need someone else open our eyes. Typical writing a letter. :) Hello to All. thanks for the firs time explanation, but I disagree, cause when you copy and paste in a new file the error appears again, and I'm sure the row are the same. In my case, I have a file wiht many providers of elements, I filter each one and then copy and paste in a new file and get the error whit subtotals. In LibreOffice 5 Win 8.1 and Ubuntu 14.04 After read this explanation, I put the reference as fixed whit "$", but the error still exist. Please @Emerson, can you attach a couple of sample files, and describes what you copy and where. Remember to delete any private/confidential information, this a public site. Created attachment 118132 [details]
Source File
This file is the source one, ther first sheet is the original data set, the second is the copy result. No error
Created attachment 118133 [details]
Destiny File
This is the destiny file, when you copy the row, subtotal has an error, reference error, and does not matter if is in the same range.
Well, good afternoon to all. The files are: Source: is the original file, it has 2 sheets, the first one is the very source of data, and the second one is the one who has the copied files. No error in ther. The second file is Destiny, is when you copy the same information in other file in the same range or in diferent range. There is the error with subtotals. The issue is reproducible only copying including column titles, if the copy is from A9:N272, no issue. Please @Emerson, could you open a new bug, because it's a different issue than the original reported here. |