[Libreoffice-bugs] [Bug 142727] Colorize Cells
https://bugs.documentfoundation.org/show_bug.cgi?id=142727 Andreas Heinisch changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |NOTABUG --- Comment #5 from Andreas Heinisch --- So I checked for the exact reason of this bug. In Bug 130476, we changed the behaviour of the hex literals. So in preceeding zeros are ignored and the resulting number is converted to an int, which leads to -256, which is obviously not a color. However, if you cast the literal to a long by adding & at the end (&), the value is preserved as long and the cell color gets the correct value. So imho not a bug. You can just change your lines from: Tabelle.getCellbyPosition(6,l).CellBackcolor = to: Tabelle.getCellbyPosition(6,l).CellBackcolor = & -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 142727] Colorize Cells
https://bugs.documentfoundation.org/show_bug.cgi?id=142727 --- Comment #4 from Andreas Heinisch --- As a workaround you may use: ThisComponent.Sheets(0).getCellByPosition(0, 0).CellBackcolor = RGB(0, 255, 0) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 142727] Colorize Cells
https://bugs.documentfoundation.org/show_bug.cgi?id=142727 --- Comment #3 from Andreas Heinisch --- Repro with: Sub TestFunction() ThisComponent.Sheets(0).getCellByPosition(0, 0).CellBackcolor = End Sub Cell background color should be green in both cases. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 142727] Colorize Cells
https://bugs.documentfoundation.org/show_bug.cgi?id=142727 --- Comment #2 from Uwe Auer --- Being not a programmer, but conversion of into a decimal seems to result in -256. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 142727] Colorize Cells
https://bugs.documentfoundation.org/show_bug.cgi?id=142727 Uwe Auer changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #1 from Uwe Auer --- Repro Version: 7.1.4.2 / LibreOffice Community Build ID: a529a4fab45b75fefc5b6226684193eb000654f6 CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs