Bug 78330

Summary: BASIC: Change/Read Background-Color of a Cell in Calc by a Macro
Product: LibreOffice Reporter: Georg <georg>
Component: BASICAssignee: 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:

Description Georg 2014-05-06 08:53:16 UTC
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
Comment 1 Georg 2014-05-06 08:55:36 UTC
*to the last statement, if you change the background in libreoffice again, you can't read it. Thats what i meant.
Comment 2 raal 2014-08-27 12:11:15 UTC
Hello,
please could you attach test file with macro code? It's VBA code? Thank you

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.