https://bugs.freedesktop.org/show_bug.cgi?id=79475
Priority: medium
Bug ID: 79475
Assignee: [email protected]
Summary: Other: Formula error when copying and pasting a
SUBTOTAL formula
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.4.2 release
Component: Spreadsheet
Product: LibreOffice
I am analysing sick leave usage, using a SAP sick leave extract, LibreOffice
Calc 4.2.4 on Ubuntu 14.04. I have extracted the relevant elements I need to
analyse using a Pivot Table and pasted them into a new worksheet, so I have a
simple table without formulas. I add a row at the bottom, and use SUBTOTAL to
sum the columns. Now, I apply a Standard Filter to the table, to display sick
leave usage of between 30 and 60 days. I unhide just the row containing the
SUBTOTAL summed values. So far, so good - the values calculate correctly.
Now the problem - I copy the filtered list and use PASTE SPECIAL to paste the
values into a new worksheet. All the SUBTOTAL formulas display #REF, and the
pasted values look like this: =SUBTOTAL(9,E#REF!:E59)
Operating System: Ubuntu
Version: 4.2.4.2 release
--
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
