https://bugs.documentfoundation.org/show_bug.cgi?id=92810
Bug ID: 92810
Summary: FORMATTING: Unable to save edits to conditional
formatting in Manage Conditional Formatting
Product: LibreOffice
Version: 4.4.4.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: petercraigmartin...@gmail.com
Created attachment 117309
--> https://bugs.documentfoundation.org/attachment.cgi?id=117309&action=edit
Spreadsheet with uneditable conditional formatting rule affecting column G
Once a conditional formatting rule has been created, it is possible to edit or
delete that rule in the Manage Conditional Formatting dialog (Format >
Conditional Formatting > Manage). However, the changes cannot be saved, as the
OK button in Manage Conditional Formatting appears to be nonfunctional. (The
Cancel button appears to be nonfunctional as well, but clicking on the dialog
box's Close button effectively cancels the operation.)
In the attached spreadsheet, entries in the column "$ Calc" (Calculated Price,
Column G) are supposed to turn red if there has been a data-entry error in the
"Gal" (Gallons Purchased, Column E), "$PG" (Price in Dollars Per Gallon, Column
F), or the "$ Paid" (Price Actually Paid, Column H) columns. To work correctly,
the test value on the right-hand side of the conditional formatting rule must
be "$H3" for the specified range, which begins at $G3. Saving and reloading the
spreadsheet caused the test value to change from "$H3" to $H5", causing all
entries in G to turn red. (This will be the subject of a separately filed bug.)
Edits to the conditional formatting rule correcting the test value cannot be
saved.
--
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
