holidaycas.blogg.se

You can write macros for LibreOffice in either LibreOffice Basic, BeanShell, JavaScript or Python, but, unless you've installed (or are willing to install) a Java Runtime Environment, you're stuck with LibreOffice Basic. I suppose it could be done with PDF forms but I don't know how to work with those either. World of Darkness traits come in dots, so to make it more easily fillable, I'd click cells instead. I'm trying to design a simple character sheet for the Vampire the Requiem game on Calc, in a way that it's light, fast and easy to fill. if I knew what part of the code determines which are the right cells to change and toggle with each click instead of counting several clicks, I'd have a solution I suppose. This document has the solution with a different criteria (it changes cells to many different colors in an array, and counts clicks so it changes again after a few), but I couldn't figure it out because it's all commented in russian, and my russian is a little rusty. This is actually for Excel, and unfortunately because they went straight to the solution with little explaining, I don't know what each line does and couldn't modify it. I even found two close solutions on the web, but:Ĭhange color of cell with mouse click in Excel

I'm not completely incapable of programming (I work with php), but I'm not familiar with this. I've seen how to create a macro, but I don't know the coding language used here.

When document is saved, it should save the current condition so it persists when I reopen. If I click again, it changes back to white. So here's what I need: when I click on certain cells in a spreadsheet in LibreOffice Calc, the background color changes to black.