Bug 78330 - BASIC: Change/Read Background-Color of a Cell in Calc by a Macro
Summary: BASIC: Change/Read Background-Color of a Cell in Calc by a Macro
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version: 4.2.3.3 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2014-05-06 08:53 UTC by Georg
Modified: 2014-08-27 12:11 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:


Attachments

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.