https://bugs.freedesktop.org/show_bug.cgi?id=78330
Priority: medium
Bug ID: 78330
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: BASIC: Change/Read Background-Color of a Cell in Calc
by a Macro
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: ge...@gnp-tec.net
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.3.3 release
Component: BASIC
Product: LibreOffice
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
--
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
