Summary: |
VBA: set font color in cell |
Product: |
LibreOffice
|
Reporter: |
Laube Roman <roman.laube> |
Component: |
BASIC | Assignee: |
Not Assigned <libreoffice-bugs> |
Status: |
NEW
---
|
QA Contact: |
|
Severity: |
normal
|
|
|
Priority: |
medium
|
CC: |
serval2412
|
Version: |
4.2.2.1 release | |
|
Hardware: |
Other | |
|
OS: |
Linux (All) | |
|
Whiteboard: |
|
i915 platform:
|
|
i915 features:
|
|
Attachments: |
VBA macro with assignment and font color setting
|
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
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