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
*to the last statement, if you change the background in libreoffice again, you can't read it. Thats what i meant.
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.