[Desktop-packages] [Bug 1074083] Re: Insert a column /moving a block in a conditional formatted range give wrong results
[Expired for libreoffice (Ubuntu) because there has been no activity for 60 days.] ** Changed in: libreoffice (Ubuntu) Status: Incomplete => Expired -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1074083 Title: Insert a column /moving a block in a conditional formatted range give wrong results Status in “libreoffice” package in Ubuntu: Expired Bug description: This bug is a new one --- I reported before an invalid one, because I failed to see that the management of conditional formatting has drastically changed from LO 3.4 to 3.6. I think I spotted a bad bug that breaks compatibility with MS Excel. If I define a new conditional format, says, on column B (from B4 to B11), then I do an "insert column", the new column will have the conditional formatting (ok) but when opening the conditional format dialog on the newly created C column the dialog says "conditional formatting for B4:B11", and looking at "conditional formatting -> managing" seems that the C column is not included in the conditional formatting ranges. But the conditional format of B column is applied to numbers in C. Exporting the file to MS Excel format gives a file that has column C without conditional formatting. Saving, closing, and reopening the file with the same LibreOffice gives the C column without conditional formatting. This is at least confusing. See file test_new_cf.ods. If you now select the square of numbers, and move them one column to the left (occupying three columns), I now have FOUR conditional formatting zones, overlapping, and the B (was the C before) column has the conditional formatting changed. I think this is at least difficult to understand. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1074083/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1074083] Re: Insert a column /moving a block in a conditional formatted range give wrong results
Romano Giannetti, thank you for reporting this and helping make Ubuntu better. Please execute the following command, as it will automatically gather debugging information, in a terminal: apport-collect 1074083 When reporting bugs in the future please use apport by using 'ubuntu-bug' and the name of the package affected. You can learn more about this functionality at https://wiki.ubuntu.com/ReportingBugs. As well, the problem is unreproducible via a terminal: cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1074083/+attachment/3420866/+files/test_new_cf.ods && localc --nologo test_new_cf.ods when one inserts a new column in C, the conditional formatting is not applied to the new column, as expected. As well, when one saves as .xls and opens in Excel, no unexpected changes existed. lsb_release -rd Description:Ubuntu 12.10 Release:12.10 apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.6.2~rc2-0ubuntu4 Candidate: 1:3.6.2~rc2-0ubuntu4 Version table: *** 1:3.6.2~rc2-0ubuntu4 0 900 http://archive.ubuntu.com/ubuntu/ quantal-updates/main i386 Packages 100 /var/lib/dpkg/status 1:3.6.2~rc2-0ubuntu3 0 500 http://archive.ubuntu.com/ubuntu/ quantal/main i386 Packages Microsoft Office Professional Plus 2010 Excel Version 14.0.6023.1000 (32-bit) ** Changed in: libreoffice (Ubuntu) Status: New => Incomplete -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1074083 Title: Insert a column /moving a block in a conditional formatted range give wrong results Status in “libreoffice” package in Ubuntu: Incomplete Bug description: This bug is a new one --- I reported before an invalid one, because I failed to see that the management of conditional formatting has drastically changed from LO 3.4 to 3.6. I think I spotted a bad bug that breaks compatibility with MS Excel. If I define a new conditional format, says, on column B (from B4 to B11), then I do an "insert column", the new column will have the conditional formatting (ok) but when opening the conditional format dialog on the newly created C column the dialog says "conditional formatting for B4:B11", and looking at "conditional formatting -> managing" seems that the C column is not included in the conditional formatting ranges. But the conditional format of B column is applied to numbers in C. Exporting the file to MS Excel format gives a file that has column C without conditional formatting. Saving, closing, and reopening the file with the same LibreOffice gives the C column without conditional formatting. This is at least confusing. See file test_new_cf.ods. If you now select the square of numbers, and move them one column to the left (occupying three columns), I now have FOUR conditional formatting zones, overlapping, and the B (was the C before) column has the conditional formatting changed. I think this is at least difficult to understand. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1074083/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1074083] Re: Insert a column /moving a block in a conditional formatted range give wrong results
This is the second test file. Notice that the conditional formatting in column B is unexpected --- the file is simply the previous one, where I just moved the blocks of numbers to the left. ** Attachment added: "second file" https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1074083/+attachment/3420867/+files/test_new_cf2.ods -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1074083 Title: Insert a column /moving a block in a conditional formatted range give wrong results Status in “libreoffice” package in Ubuntu: New Bug description: This bug is a new one --- I reported before an invalid one, because I failed to see that the management of conditional formatting has drastically changed from LO 3.4 to 3.6. I think I spotted a bad bug that breaks compatibility with MS Excel. If I define a new conditional format, says, on column B (from B4 to B11), then I do an "insert column", the new column will have the conditional formatting (ok) but when opening the conditional format dialog on the newly created C column the dialog says "conditional formatting for B4:B11", and looking at "conditional formatting -> managing" seems that the C column is not included in the conditional formatting ranges. But the conditional format of B column is applied to numbers in C. Exporting the file to MS Excel format gives a file that has column C without conditional formatting. Saving, closing, and reopening the file with the same LibreOffice gives the C column without conditional formatting. This is at least confusing. See file test_new_cf.ods. If you now select the square of numbers, and move them one column to the left (occupying three columns), I now have FOUR conditional formatting zones, overlapping, and the B (was the C before) column has the conditional formatting changed. I think this is at least difficult to understand. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1074083/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp