https://bugs.documentfoundation.org/show_bug.cgi?id=95887
Bug ID: 95887
Summary: FORMATTING: Absolute cell references $Sheet1.$A$1 in
conditional formats are changed when a sheet is moved
Product: LibreOffice
Version: 5.0.3.2 release
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: eugene...@gmail.com
Created attachment 120608
--> https://bugs.documentfoundation.org/attachment.cgi?id=120608&action=edit
Example of conditional formatting being changed
When dragging a spreadsheet tab to a different position, conditional formatting
that contains $Sheet1.$A$1 style absolute references gets changed, messing up
the formatting.
Consider the example spreadsheet attached (CondFormatTest.ods). The cells with
conditional formatting should all be green. The conditional formats in the
example spreadsheet use different cell reference styles.
Drag Sheet1 to place it after Sheet2. The first and last cells change to red.
Examining the conditional formatting rules shows that the rules for these two
cells (that use the $Sheet1.$A$1 style) now refer to $Sheet2 instead of
$Sheet1.
Next add a new sheet (Sheet3). Drag Sheet3 to become the first sheet. Now the
conditional formatting rules for the first and last cells refer to $Sheet3.
It appears that $Sheet1.$A$1 style references are stuck referencing whatever
spreadsheet tab is in the original position after the sheet is moved.
The behaviour seems kind of similar to bug 73655 only applied to conditional
formatting
--
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
