Launchpad has imported 20 comments from the remote bug at https://bugs.freedesktop.org/show_bug.cgi?id=57176.
If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. ------------------------------------------------------------------------ On 2012-11-16T05:30:06+00:00 Rh-libre wrote: Problem description: I have a spreadsheet with one cell (with an =IF(condition,"CORRECT","INCORRECT") function having one format dependent on its own text value (or else its default format, making it go red or green). Another column of cells each have formatting (Blue Green or Red background) dependent on whether their value is greater, equal or less than the value three cells to the right. Saving as ODF (or opening a Libre Office 3.4-created file with this formatting) the column of cells have only background formatting and no Conditional Formatting shows up while the single condition has correct formatting. Also if re-formatted as Conditional, then you Format Paint this format onto the same cell dragging down one cell too far, hitting undo to try again will wipe the original conditional format and there's no redo available. Similarly, hitting the Delete key (or Delete Contents without deleting formatting) has the same effect. Steps to reproduce: 1. .... 2. .... 3. .... Current behavior: Expected behavior: Same as Libre Office 3.4 - Conditional Format is retained. Platform (if different from the browser): Browser: Opera/9.80 (Windows NT 6.1; Edition Campaign 21) Presto/2.12.388 Version/12.10 Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1099246/comments/0 ------------------------------------------------------------------------ On 2012-11-20T22:23:55+00:00 Cno wrote: Hi rh, thanks for your report. Could you pls try the following: - try 3.6.4 release candidate 1 http://www.libreoffice.org/download/pre-releases/ - try a daily build http://dev-builds.libreoffice.org/daily/ If the issue is not fixed in those, pls attach an example file? thanks - Cor Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1099246/comments/1 ------------------------------------------------------------------------ On 2012-11-21T15:48:03+00:00 Rh-libre wrote: Created attachment 70378 Example balance sheet / cash till float spreadsheet Thanks. I tried version 3.6.4RC1 and after my PC hung on me mid-install leaving a 'program' folder with no access and no owner which I cannot delete or take ownership of even as administrator, I managed to install it in a different folder. (Windows 7 Professional 32 bit on AMD Turion 64-bit processor with 4GB RAM) Still have some problems, so I attach Cash_Check_test.ods saved using that version of LibreOffice Calc Cells K2 to K13 have three-way conditional formatting depending on whether lower, equal or higher than cell N2 to N13. For example, change K4 from 30 to 40 and notice it becomes light-blue. Change it to 20 and it becomes light-red (pink). Set it back to 30 and it becomes green. Now, still on K4, hit Delete. It's treated as zero, and goes light red. Hit Undo, and it reverts to 30 and green. Now select two cells, K4:K5 and hit delete. This time all formatting is lost. Not to worry, you might think, just hit Undo. The values return. But, Oh, where has my conditional formatting gone!? It seems to lose the Conditional Formatting when deleting a multiple selection and the Undo doesn't realise it has gone, so I don't think it's an intended feature of hitting delete on a multi-cell selection. There doesn't seem to be a problem with Paste Special / Numbers changing the formats now, but at least I can demonstrate a bug of the sort I mentioned with steps to try to replicate it. Thanks, rh Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1099246/comments/2 ------------------------------------------------------------------------ On 2012-11-21T16:33:33+00:00 Doledoux wrote: I've tried the Version 3.6.4.1 (Build ID: a9a0717) on MacOS 10.7.5. I still lose the Conditional Formatting when deleting a multiple selection. See attachment Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1099246/comments/3 ------------------------------------------------------------------------ On 2012-11-21T16:37:40+00:00 Doledoux wrote: Created attachment 70380 LibO files with bug using conditional formatting Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1099246/comments/4 ------------------------------------------------------------------------ On 2012-11-23T16:39:50+00:00 Markus Mohrhard wrote: Undo/Redo fixed in master for 4.0 Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1099246/comments/5 ------------------------------------------------------------------------ On 2012-11-23T22:25:25+00:00 Markus Mohrhard wrote: Fixed the autofill problem in master. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1099246/comments/6 ------------------------------------------------------------------------ On 2012-11-23T22:28:19+00:00 Markus Mohrhard wrote: Sorry marked the wrong bug as fixed. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1099246/comments/7 ------------------------------------------------------------------------ On 2012-12-04T06:34:38+00:00 Libreoffice-z wrote: This problem can be reproduced easily with "SampleSource.ods" in test kit Attachment 68944 of Bug 56316. Steps how to reproduce: 0. download / Unzip Attachment 68944 1. Open "SampleSource.ods" from Test kit 2. With menu 'Format -> Conditional Formatting -> Manage' you see that there is some CF for Cell I5 3. Click row heading for row 3 > row 3 selected 4. <control+c> for copy 5. Click row heading for row 5 6. <control+v> for paste > only empty cells in row 5 7. With menu 'Format -> Conditional Formatting -> Manage' you see that there is NO CF for Cell I5 8. Click the "Undo" Icon in the Standard Toolbar > Contents of row 5 reappears 9. With menu 'Format -> Conditional Formatting -> Manage' you see BUG: still NO CF for Cell I5 !!! Other possibility to reproduce the bug (as observed in <https://bugs.freedesktop.org/show_bug.cgi?id=56316#c13>: 11. Open Attachment 70975 Details for Bug 56316 12. Click common rows / Columns heading at top left corner all cells become selected 13. <control+c> for copy 14. Click A1 15. <control+v> for paste > Complete sheet contents of sheet sheet "replaced by itself" But Conditional Formatting is lost 16. Click the "Undo" Icon in the Standard Toolbar > a lot of flickering seems to restore the old contents BUG: still NO CF (cells with contents "8" without blue background !!! Already [Reproducible] with - Server Installation of "LibreOffice 3.6.2.1 rc English UI/ German Locale [Build-ID: ba822cc] on German WIN7 Home Premium (64bit) and Sample of Step 1, Sample of step 11 crashes this version. This still worked fine with - Server Installation of "LibreOffice 3.6.0.4 English UI/ German Locale [Build-ID: 932b512] on German WIN7 Home Premium (64bit) - Server Installation of "LibreOffice 3.6.0.0.beta2 German UI/Locale [Build-ID: f010139] on German WIN7 Home Premium (64bit) (already new CF dialog, but without "Manage" option Works for me with both examples in this comment and with parallel installation of "LOdev 4.0.0.0.alpha1+ - ENGLISH UI / German Locale [Build ID: 6aabe09ac092c51d4b394bde9c7ea0055b952e3)]" {tinderbox: Win-x86@6, pull time 2012-11-26 00:29:34} on German WIN7 Home Premium (64bit) with own separate User Profile @Markus: We will need a backport to 3.6. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1099246/comments/8 ------------------------------------------------------------------------ On 2012-12-04T06:39:21+00:00 Libreoffice-z wrote: 3.6.2 (?) regression Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1099246/comments/9 ------------------------------------------------------------------------ On 2012-12-04T07:13:26+00:00 Andis wrote: In Version 4.0.0.0.alpha1+ (Build ID: e14b5f33ceae3280b46eb97a88b949d00263956) on Ubuntu 12.04 after copy/paste whole sheet as described in comment 8, the conditional formatting records survives after pasting. However, new problem arises; on open file in 4.0 original conditional formatting setting (if cell value is > 0, than cell style = Number) is changed to empty value (if cell value is equal = (empty box), then Default style). Probably another kind of problem. Libreoffice also still hangs, when there are 12 monthly sheets in a file, when I try to copy/paste content of the whole sheet. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1099246/comments/10 ------------------------------------------------------------------------ On 2012-12-04T07:16:30+00:00 Andis wrote: (In reply to comment #10) > > Libreoffice also still hangs, when there are 12 monthly sheets in a file, > when I try to copy/paste content of the whole sheet. Update! It is not hanging, it just takes several minutes to paste. Few seconds in Libreoffice 3.5.5. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1099246/comments/11 ------------------------------------------------------------------------ On 2012-12-05T13:17:14+00:00 Markus Mohrhard wrote: (In reply to comment #11) > (In reply to comment #10) > > > > > Libreoffice also still hangs, when there are 12 monthly sheets in a file, > > when I try to copy/paste content of the whole sheet. > > Update! It is not hanging, it just takes several minutes to paste. Few > seconds in Libreoffice 3.5.5. Can you please open new bug reports for new issues. I'll have a hard time to track bug reports otherwise. As long as the title contains conditional formatting it will show up in my search. Adding additional bug reports to an existing bug report leads to me loosing track of the different problems mentioned in the bug report. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1099246/comments/12 ------------------------------------------------------------------------ On 2012-12-19T10:36:16+00:00 John wrote: *** Bug 58509 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1099246/comments/13 ------------------------------------------------------------------------ On 2012-12-19T10:37:16+00:00 John wrote: I can confirm that this issue still exists in 4.0 beta 1. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1099246/comments/14 ------------------------------------------------------------------------ On 2013-01-02T15:56:51+00:00 Doledoux wrote: I've tried the Version 4.0.0.0.beta2 on MacOS 10.7.5. I still lose the Conditional Formatting when deleting a multiple selection. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1099246/comments/15 ------------------------------------------------------------------------ On 2013-01-14T01:23:39+00:00 Christopher M. Penalver wrote: Reproducible in: Microsoft Windows Vista Business x86 6.0.6002 Service Pack 2 Build 6002 Version 4.0.0.1 (Build ID: 527dba6f6e0cfbbc71bd6e7b88a52699bb48799) 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 Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1099246/comments/18 ------------------------------------------------------------------------ On 2013-02-03T11:41:12+00:00 John wrote: Not reproducible in Version 4.1.0.0.alpha0+ (Build ID: 28b7359e00fec9fd3bfab3c9105cf250c4320a2) TinderBox: Win-x86@6, Branch:master, Time: 2013-02-02_00:14:06 using either of Rainer Bielefeld's methods. Can this be marked as resolved? Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1099246/comments/19 ------------------------------------------------------------------------ On 2013-02-03T14:28:44+00:00 Christopher M. Penalver wrote: Reproducible in: Microsoft Windows Vista Business x86 6.0.6002 Service Pack 2 Build 6002 Version 4.0.0.3 (Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89) Using original reporter's attachment https://bugs.freedesktop.org/attachment.cgi?id=70378 highlight cells K4:K5 -> click Delete -> Undo and the Background Color of cells K4:K5 are not restored. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1099246/comments/20 ------------------------------------------------------------------------ On 2013-02-03T15:04:33+00:00 John wrote: @Christopher M. Penalver I agree that this is not working with the original attachment (I had misunderstood the instructions earlier). Tested on Windows XP with: Version 4.1.0.0.alpha0+ (Build ID: 28b7359e00fec9fd3bfab3c9105cf250c4320a2) TinderBox: Win-x86@6, Branch:master, Time: 2013-02-02_00:14:06 Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1099246/comments/22 ** Changed in: df-libreoffice Status: Unknown => Confirmed ** Changed in: df-libreoffice Importance: Unknown => High ** Bug watch added: freedesktop.org Bugzilla #56316 https://bugs.freedesktop.org/show_bug.cgi?id=56316 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1099246 Title: [Upstream] Undo does not preserve conditional formatting To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1099246/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
