https://bugs.documentfoundation.org/show_bug.cgi?id=162897
--- Comment #19 from Michael <[email protected]> --- Unfortunately for me, I have no idea about the inner workings of LibreCalc, so I don't know what's practical and what is not. I very much appreciate all the work you guys do. One of the volunteers has upgraded to 24.8.0 so he can change the color of the Spreadsheet/Cell Focus Color which you recently implemented. It has made his work on the spreadsheet much easier. Thank you! 1. Originally, we requested that the background of the cell when in Edit Mode would be the image itself. That would be ideal. 2. Someone said Option 1 wasn't feasible, so the next best option would be to have a way to set the background colour of the cell when in Edit Mode by having a separate variable from Application Colors - Background Color. It would be best to be able to change the colour of the cell when in Edit mode and not affect the Document Background color, which leads to other issues. 3. Someone said Option 2 is not practical or feasible either, so the next best option would be to have an item on the Formatting Toolbar to change the Document Background colour. Having it there makes it easy to swap colours back and forth as required. 3a. Ideally, that would be an application that looks and works like Font Color. Perhaps someone on the development team could write application that looks and acts like Font Color that changes the Document Background. 3b. In the meantime, just having a macro would suffice. I tried a macro someone posted in an earlier comment. That macro runs when it is in: My Macros & Dialogs - Module 1. It does not work when it is a module for a specific spreadsheet - like our Extensions module. When I run that version of the macro, I get a Basic Runtime Error, Variable not defined for this line: curScheme = keyNode.CurrentColorScheme If I can get the macro from the Spreadsheet - Extension modules to work, then I can put it into all the current spreadsheets we're running, and the other volunteers will be able to use it. It won't be as elegant as Option 3a with an icon like the Font Color application and it won't have all the colour options, but I made an input box in the macro that allow the user to pick one of 12 colors. Perhaps in time there will be a proper application that we, and others, can have on one of their toolbars. -- You are receiving this mail because: You are the assignee for the bug.
