| Summary: | When copying filtered table, which contains subtotals, from calc and pasting as GDI Metafile into writer, wrong values are pasted. | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Nikos <gdna> |
| Component: | Writer | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | QA Contact: | |
| Severity: | normal | ||
| Priority: | high | CC: | bgran05, gdna |
| Version: | 3.6.2.2 release | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | |||
| i915 platform: | i915 features: | ||
| Attachments: |
Ods table with filters and subtotal function
Odt file showing the wrong result Comparisson Metafile - bitmap after removing auto filter |
||
Created attachment 68435 [details]
Odt file showing the wrong result
BTW Bitmap works fine Tested on Win7 and OpenSuse 12.2 64bit with LibreOffice 3.6.2.2. Also reproducible on Win7 with Libreoofice 3.5.6 I also tested, that this is unrelated to enabling "experimental features". Please feel free to ask for clarifications if the bug description is not clear enough. Created attachment 68784 [details]
Comparisson Metafile - bitmap
Changed component to writer. I don't know if this is really a writer issue or a calc issue, but I got the feeling if I don't select something, simply nobody will ever look at it. How, about giving me a little feedback on this bug...as a Christmas present? Thank you, and have nice holiday. Persists on 4.0.3 Hi, I am sorry it took so long to respond to this bug. I did want to let you know I have confirmed the behavior- the subtotal after copy-paste from the .ods is incorrect. Here are the steps I followed: 1. Open the bug .ods file. 2. Highlight all the data, including subtotal. 3. Go to Data -> Filter. Check Auto Filter. 4. Ctrl- C to copy cells, including subtotal. 5. Copy -> Paste (or Copy -> Paste special -> GDI Metafile) into Writer document. Expected Result: cell information, including subtotal, copied as is. Actual Result: subtotal is different. As you mentioned, Copy-> Paste Special -> Bitmap does not result in an error. Something else I noticed: When I try to remove the filter by going to Data -> Filter and unchecking Auto Filter.... the .ods changes. The left column shows a, b, c, and the right column repeats 1, 2, 3. The new subtotal after that is now 42. So maybe when you copy-paste to .odt, the filter is removed. I will include a screenshot. Created attachment 76936 [details]
after removing auto filter
I forgot to include the version/ platform used to test: Version: Version 4.0.2.1 (Build ID: 7e5467ff8f30d821f4fbf69cb2769163eb64c2c) Platform: Ubuntu Linux 12.04 LTS x64 Finally, I think the priority should be lowered to a Normal - High/Highest. The Major priority is for things such as unable to print, save documents, tediously slow. There is a temporary workaround, the Bitmap copy-paste. I hope you agree. -Brenda ----------------------------- LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link: https://wiki.documentfoundation.org/QA/BugTriage There are also other ways to get involved including with marketing, UX, documentation, and of course developing - http://www.libreoffice.org/get-help/mailing-lists No problem, I think I had only changed that in desperate search for attention...At least now I know this is not my diary ;-) Persists on 4.1.2.2 |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
Created attachment 68434 [details] Ods table with filters and subtotal function Steps to reproduce Open file 20121110bug.ods. Select visible cells (with filter set) copy Create new .odt file paste special --> GDI Metafile Expected behavior: A picture is inserted in the .odt file, with the values that were visible in the .ods (correctly calculated subtotal) Actual behavior: A picture is inserted in the .odt file, even though only the filtered cells are shown, the subtotal function is wrong!