| Summary: |
BASIC: Change/Read Background-Color of a Cell in Calc by a Macro |
| Product: |
LibreOffice
|
Reporter: |
Georg <georg> |
| Component: |
BASIC | Assignee: |
Not Assigned <libreoffice-bugs> |
| Status: |
NEEDINFO
---
|
QA Contact: |
|
| Severity: |
normal
|
|
|
| Priority: |
medium
|
CC: |
raal
|
| Version: |
4.2.3.3 release | |
|
| Hardware: |
Other | |
|
| OS: |
Windows (All) | |
|
| Whiteboard: |
BSA |
|
i915 platform:
|
|
i915 features:
|
|
|---|
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.
I think i found a problem. If you set a background-color of a cell in libreoffice you can't read the actual RGB-Value with the line 'var=ActiveSheet.Cells(c, r).Interior.Color'. It always returns an older value, not the actual. But if you change the background value with 'ActiveSheet.Cells(c, r).Interior.Color = RGB(r_val,g_val,b_val)' (actually works), you can read the actual value. And again, if you now try to read the BG-Color in the macro, you still read the old color. Operating System: Windows 7 Version: 4.2.3.3 release