Created attachment 95695 [details]
VBA macro with assignment and font color setting

Hello,
in attached XLS file there is simple VBA macro which (after pressing "CZ" button) copies cells from list "Src" to list "Dest" and sets font color of 2 cells to white:

Sub copy_to_CZ1()
    
    Sheets("Dest").Range("A2") = Sheets("Src").Range("A3")
    Sheets("Dest").Range("B2") = Sheets("Src").Range("B3")
    Sheets("Dest").Range("C2") = Sheets("Src").Range("C3")
    Sheets("Dest").Range("B2:C2").Font.Color = RGB(255, 255, 255)
    Sheets("Dest").Range("D2") = Sheets("Src").Range("D3")
    Sheets("Dest").Range("E2") = Sheets("Src").Range("E3")
    
    
    Sheets("Dest").Select
    Range("D2").Select
    
End Sub

But after pressing "CZ" button last two assignments aren't executed (but Sheets("Dest").Select and Range("D2").Select is executed). If you delete row with font color setting. All assignments are executed properly.

I cannot confirm this bug in other LibreOffice versions but it was working in OpenOffice 3.2.1...

Sincerely
Laube Roman