https://bugs.freedesktop.org/show_bug.cgi?id=84927
Bug ID: 84927
Summary: Calc - Errors in function "Conditional Formatting"
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: critical
Priority: medium
Component: Spreadsheet
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: lazylo...@gmail.com
Created attachment 107731
--> https://bugs.freedesktop.org/attachment.cgi?id=107731&action=edit
Sample ods file attached in case you need it for your testing / verification.
Happens in :
1. opensuse Factory - Libreoffice Version: 4.3.1.2, Build ID: 430m0(Build:2)
2. Debian Wheezy Backports - Libreoffice Version: 4.3.2.2.0+, Build ID:
430m0(Build:2)
Both the libreoffice configuration is reset (rm -rf ~/.config/libreoffice) and
retested to confirm that problem still exist.
# Sample ods file attached in case you need it for your testing / verification,
Filename:Conditional_Format.ods
Formating :
Conditional formatting using Formula as described below:
For cell C2, if C2>B2 , change background colour to Green
For cell C2, if C2<B2 , change background colour to Red
# See worksheet named :Sample.png
Problem 1 :
Copy of formatting (is intermittent) sometimes does not work - conditional
format is not copied.
You have to randomly try to find out for yourself all the possible variations.
One reproducable example :
1. Select C2:C31, which is conditionally formatted.
2. Copy format and paste to D2:D31, only D2 is formated as shown in image.
# See worksheet named : intermittent.png
Problem 2 :
Properly conditional formatted spreadsheet may lost some of its conditional
formatting after saving and immediately reopen.
# See worksheet named : lost.png
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
