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!
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
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: *Test to see if the bug is still present on a currently supported version of LibreOffice (4.4.1 or later) https://www.libreoffice.org/download/ *If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior *If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT *Update the version field *Reply via email (please reply directly on the bug tracker) *Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-04-18
Still reproducible on 4.4.3 on Windows 7, Ubuntu 14.04 and on 4.4.1 OpenSuse 13.2.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.1.5 or 5.2.1 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20160920
Still reproducible on 5.4.4.2
Just to report that I was caught by this bug in 5.4.5.1 (running in Kubuntu 16.10 but reproducible in windows 7). I think this is a serious bug since this causes harm in the real world. One colleague of mine created a report with wrong values. In a way, we can think of this bug as data corruption. The bitmap workaround is not entirely satisfactory. I was not able to create a minimal example.
Tested with LO 6.1.1.0.0+ under Ubuntu 16.04. It works as expected if the subtotal formula is changed as follows: =SUBTOTAL(109;B2:B22) https://help.libreoffice.org/6.1/en-US/text/scalc/01/04060106.html?DbPAR=CALC#bm_id3165633 I guess the code that produces the GDI metafile confuses hidden rows and filtered-out cells. Best regards. JBF
Dear Nikos, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
I can still reproduce this bug in Libreoffice 6.1.6.3 in Ubuntu 18.10 and in LibreOffice 6.2.5.2 in Windows 10.
Same (??) issue for Calc (LibreOffice-fresh) If only SubTotals are Shown and copied: ALL cells ( also non visible) will be inserted
(In reply to JohnML from comment #22) > Same (??) issue for Calc (LibreOffice-fresh) > > If only SubTotals are Shown and copied: ALL cells ( also non visible) will > be inserted What you describe is actually not the same problem. In the original bug, only visible cells are copied, but the sums are wrong.
Thanks for this information was looking for it. https://www.go-mcafee.com/activate/ https://www.thenortonsetup.com/ https://setupofficecomsetup.com/ https://product-hotline.com/hp-printer-support/ https://email-phone-support.com/roadrunner-email-login/
Many people are depressed about the problems of essay writing. Well, don’t worry about that because we are providing this service at a very reasonable price. <a href='https://www.calltutors.com/Articles/Statistics-Assignment-Help'>statistics assignment help</a> <a href='https://www.calltutors.com/Articles/python-assignment-help'>python assignment help</a> <a href='https://www.calltutors.com/Articles/Economics-Homework-Help'>Economics Homework Help</a> <a href='https://www.calltutors.com/Articles/Digital-marketing-assignment-help'>Digital Marketing Assignment Help</a> <a href='https://www.calltutors.com/Articles/Rstudio-Assignment-Help'>Rstudio Assignment Help</a>
Thanks for this useful stuff, Global Assignment Help Australia is the right place where students can avail the Mass communication assignment writing services at affordable prices. Our professional academic writers try hard to assist students in writing assignments. https://www.globalassignmenthelp.com.au/mass-communication-assignment-help
https://www.sfvpoolcare.com/
Bug 55870 refers to a specific issue reported in a software application, involving the copying of a filtered table from a spreadsheet program (Calc) and pasting it as a GDI Metafile into a word processing program (Writer). According to the bug report, when the table contains subtotals, incorrect values are pasted into Writer.