[Upstream] Undo does not preserve conditional formatting
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
LibreOffice |
Fix Released
|
High
|
|||
libreoffice (Ubuntu) |
Invalid
|
Medium
|
Unassigned |
Bug Description
1) lsb_release -rd
Description: Ubuntu 12.10
Release: 12.10
2) apt-cache policy libreoffice-calc
libreoffice-calc:
Installed: 1:3.6.2~
Candidate: 1:3.6.2~
Version table:
*** 1:3.6.2~
900 http://
100 /var/lib/
1:
500 http://
3) What is expected to happen via the attached document is highlight rows 4 through 11 -> click Edit -> Delete Cells... -> Delete entire row(s) -> button OK -> Ctrl+Z and the rows show back up with their original conditional formatting.
4) What happens instead is the numbers show up, but the conditional formatting has been removed.
Reproducible in:
Microsoft Windows Vista Business x86 6.0.6002 Service Pack 2 Build 6002
Version 4.0.0.1 (Build ID: 527dba6f6e0cfbb
Does not occur in gnumeric.
apt-cache policy gnumeric
gnumeric:
Installed: 1.10.17-1.1ubuntu1
Candidate: 1.10.17-1.1ubuntu1
Version table:
*** 1.10.17-1.1ubuntu1 0
500 http://
100 /var/lib/
ProblemType: Bug
DistroRelease: Ubuntu 12.10
Package: libreoffice-calc 1:3.6.2~
ProcVersionSign
Uname: Linux 3.5.0-17-generic i686
ApportVersion: 2.6.1-0ubuntu9
Architecture: i386
CheckboxSubmission: 30b6638832e1972
CheckboxSystem: 2954e74ba17fb0e
Date: Sun Jan 13 18:48:18 2013
InstallationDate: Installed on 2012-06-11 (216 days ago)
InstallationMedia: Xubuntu 12.04 "Precise Pangolin" - Alpha i386 (20120131.1)
MarkForUpload: True
SourcePackage: libreoffice
UpgradeStatus: Upgraded to quantal on 2012-09-14 (121 days ago)
summary: |
- Undo does not preserve conditional formatting + [Upstream] Undo does not preserve conditional formatting |
Changed in df-libreoffice: | |
importance: | Unknown → High |
status: | Unknown → Confirmed |
Changed in df-libreoffice: | |
status: | Confirmed → Invalid |
Changed in df-libreoffice: | |
status: | Invalid → Confirmed |
Changed in df-libreoffice: | |
status: | Confirmed → Invalid |
Changed in df-libreoffice: | |
status: | Invalid → Confirmed |
Changed in df-libreoffice: | |
status: | Confirmed → Fix Released |
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