[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