[Libreoffice-bugs] [Bug 52565] New: (regression) Conditional Format formula for wrong cell is displayed
bugzilla-daemon at freedesktop.org
bugzilla-daemon at freedesktop.org
Fri Jul 27 07:24:05 CEST 2012
https://bugs.freedesktop.org/show_bug.cgi?id=52565
Bug #: 52565
Summary: (regression) Conditional Format formula for wrong cell
is displayed
Classification: Unclassified
Product: LibreOffice
Version: 3.6.0.2 rc
Platform: Other
OS/Version: Linux (All)
Status: NEW
Severity: critical
Priority: medium
Component: Spreadsheet
AssignedTo: libreoffice-bugs at lists.freedesktop.org
ReportedBy: james_avera at yahoo.com
Created attachment 64757
--> https://bugs.freedesktop.org/attachment.cgi?id=64757
Demo spreadsheet with conditional formatting
The Conditional Formatting dialog sometimes shows information about
the wrong cell (that is, some cell other than the current selection).
Please open the attached CondFmt.ods spreadsheet, which was created
with LibreOffice 3.4.4
Click any cell in column A, then Format->Conditional Formatting
and display Condition #1. Every cell shows the Formula
MOD(B1,2)=0
which is incorrect except for cell A1. In all the others, the formula is
MOD(Bx,2)=0 [where x is the row number]
That this is the case can be confirmed by observing that the 'Yellow' style is
conditionally applied only when the number in column B is even.
You can also open the spreadsheet using LO 3.4.4 and see the correct formulas.
Marking this as critical because IMO this regression must be fixed before 3.6
is released, as it makes it impossible to rationally edit Conditional Formats.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
More information about the Libreoffice-bugs
mailing list