https://bugs.documentfoundation.org/show_bug.cgi?id=162067
Bug ID: 162067
Summary: Cell Background Color Changes Incorrectly After
Modifying and Saving Code
Product: LibreOffice
Version: 24.2.4.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When modifying and saving any code in my LibreOffice Document, changing the
background color of a cell using RGB values results in the cell displaying an
incorrect color. In my example, setting a cell's background color to RGB(0, 0,
255) turns it blue as expected, but after changing or commenting out any line
of code and saving, the cell's background color changes to red instead of the
specified blue. Calculating the value myself, so using just 255 instead of
RGB(0,0,255) in this scenario is a working workaround
Steps to Reproduce:
1. Open ColorDemo document
2. Run SetCellColor function
3. Observe result (cell turns blue)
4. Comment out the SetSheetRef function and save
5. Run SetCellColor again
6. Observe difference in results
Actual Results:
After saving the change in the macro code, the Subroutine starts to turn cell
A1 Red
Expected Results:
Sub should continue to turn cell Blue
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 24.2.4.2 (X86_64) / LibreOffice Community
Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2
CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
