https://bugs.freedesktop.org/show_bug.cgi?id=57395
Priority: medium
Bug ID: 57395
Assignee: [email protected]
Summary: FORMATTING: modifying reference for CONDITIONAL
FORMATTING of a single cell also modifies references
in adjacent cells
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 3.6.4.1 rc
Component: Spreadsheet
Product: LibreOffice
Created attachment 70408
--> https://bugs.freedesktop.org/attachment.cgi?id=70408&action=edit
Sample Document
I found this problem during my investigations for "Bug 48970 - EDITING:
Deleting a column in particular.xls corrupts following columns" with
"LibreOffice 3.6.4.1 rc" German UI/ German Locale [Build-ID: a9a0717] on German
WIN7 Home Premium (64bit) and a sample document what is a simplified Version of
Attachment 60391
Steps how to reproduce:
1. Open attached sample0.ods2.
2. Click cell D17, check Conditional formatting in 'Format -> Conditional
Formatting -> Conditional Formatting'. Reference should be 'Sample.$D17=""'
3. Click cell D18
4. Menu 'Format -> Conditional Formatting -> Conditional Formatting'
> Dialog opens
5. Modify formula from 'Sample.$D18=""' to 'Sample.$E18=""' <ok>
Expected: only this cell gets new formatting (so it happens with 3.5)
Actual: all similar conditions in B11:D22 change reference from column D
to column E (check as per step 2)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
