https://bugs.freedesktop.org/show_bug.cgi?id=76104
Priority: medium
Bug ID: 76104
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: VBA: set font color in cell
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: roman.la...@centrum.cz
Hardware: Other
Status: UNCONFIRMED
Version: 4.2.2.1 rc
Component: BASIC
Product: LibreOffice
Created attachment 95695
--> https://bugs.freedesktop.org/attachment.cgi?id=95695&action=edit
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
--
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
