https://bugs.freedesktop.org/show_bug.cgi?id=48970

Rainer Bielefeld <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]

--- Comment #12 from Rainer Bielefeld <[email protected]> ---
@Olav
I see absolutely nothing. Please describe exactly what problem you see in your
sample document

@bfoman
Have you any idea what is happening here? 

---

I created a more simple sample document with following important modifications:
a) I modified Style "Excel_CondFormat_1_2_1", added green background (so that
it can be observed more easy, test it by deleting contents of D17), 
b) added a  formula to D26, referring to $E$26

Can someone explain my following observation with  "LibreOffice 3.5.7.2 rc
German UI/Locale [Build-ID: 3215f89-f603614-ab984f2-7348103-1225a5b] on German
WIN7 Home Premium (64bit) 

0. Open Attachment 70408 (simpyfied version of att. 2012-04-20 07:21 UTC, 
   Jiri Kosina)
1. Check conditional formatting in D17
   > is 'Sample.$D17=""'
2. Check refeerence in D26: is to '$E$26'
3. Delete column C
   > Range B11:C22 gets green background ?!?
4. Redo step 2
   As expected in (now) C26 the reference changed from '$E$26' to '$D$26'
5. Redo step 1 for (now) C17
   Unexpectedly (?) the reference for conditional formatting 
   did not change from 'Sample.$D17=""' to 'Sample.$C17=""'

The reason for that effect might be that the deletion of column C was within
the range for conditional formatting, see Bug 57395. If that's the reason, the
new question is where we find buggy behavior - in Excel or in LibO?

My skills here are too limited to find the core of the problem.

-- 
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

Reply via email to