Shades | : sunglasses : automatically ruin Wikipedia biography | Wiki library

I have created a google sheet and have set up protections that restrict users to checking/unchecking a single cell. When they check or uncheck the cell, it shades data found in the same sheet. ie. numbers >90% shade dark green. numbers >80% shade light green. etc.

This, of course, works fine on my end because I don't have any protections in place for myself. However, I just realized that the users can't use the checkbox to shade cells that are protected. They are able to check/uncheck but the code in onEdit won't shade for them like it does for me.

When I first made the doc, I had set it up for conditional formatting so it would take care of it automatically. However, this made the sheets slow down as it could be shading anywhere from 50 to 300 cells in a page. (Each page has a different number of cells.) I could go back to this if I have to. If there's a way to speed that up, I'm all ears.

However, I'm hoping someone out there can help a noob figure out how to protect the cell so the user can't edit it but let the shading work as described in the first paragraph.

Thoughts?

Sandi

Edited:

Here's the code that is activated through onEdit when a user checks the "shade" cell: (I'm sure there's a better way to write the code...but still learning and kind of hacking my way through...)

I sincerely hope, that I followed all the rules and guidelines and that my question/problem is comprehensive enough to find an adequate answer. First, a small intro:
For a current project of mine I want to designate specific types to tree node objects. To keep matters simple here, I will use colours as an analogy.

Let's suppose I have the following enum, derived from the enum standard library:

How to disable color interpolation in GLFW and OpenGL 3.3 so that left half of the screen is pure white and the other half is completely black instead of having smooth transition through all shades of gray?

I am having some trouble with coloring my scatterplot markers. I have a simple dataframe with a value "pos" and two other values, "af_min" and "af_max". I want to color the markers based on some conditions for af_x and af_y, but since I don't any column to exploit as a hue, I created my own column "color".

I need to pass an array of integers to a shader as a uniform. As uniform arrays are not yet supported, I'm using a FORMAT_R8 texture/isampler2D to achieve this.

If I'm correctly reading the bytes from the texture, they should be in the range [0..7] and then by normalizing that value, I should get different shades of red, but that's not happening.

In the screenshot you can see that when the value is read as 0, it's correctly displaying it black, but when it's other than 0, it's full red, no shades. I tried comparing the value read and it's always greater than any value I can try, up to the maximum value of a 32 bit signed integer, so no idea what value I'm reading back from the texture.

Any ideas?

The full project is here: https://github.com/Drean64/clash-of-the-colors/tree/simple

GDScript:

When using createMuiTheme(), the palette object has gives you 3 options for you primary color, light, main, and dark. But what if you wanted a custom color like medium_light or medium_dark for primary? I ask this because I need 4 shades of a color for my UI, which is one more than you seem to be able to add to your palette. I know other fields allow you to store more colors, (secondary, error, etc.), but I'd like to have all four of these colors in primary in order to avoid confusion.

If this is not at all possible, what might be a sensible work-around?

I have a grayscale image created using Pillow – it's mode L – and I'd like to save it as shades of a single colour, so that instead of shades from black-to-white, it's shades from cyan-to-white.

So, say I was doing this:

I am creating a video effect that is supposed to look as in "Matrix" movie, but a bit different ("Matrix"-like video output will be mixed with an altered alpha channel with real video, so it will look half real, half with digits). I am using simply mplayer with caca driver (mplayer -vo caca video.mp4) together with screen recording and then mixing videos in other software. For this I needed to change "static uint32_t ascii_glyphs[]" array in file dither.c (from the code of the caca library as it published here: https://github.com/cacalabs/libcaca/blob/master/caca/dither.c) from: ' ', '.', ':', ';', 't', '%', 'S', 'X', '@', '8', '?' to contain all Katakana symbols. But the problem is that it looks like they are not printable. So the terminal output of the video contains only shadow blocks. I should say that the bash code:

I've made this heatmap of a correlation matrix for a class. I want to fix the color scaling, specifically for infection_status. The pink shades its chosen are to similar not just to infections tatus but they even look the same as hpi.