Tag: Formatting

Formatting – Highlight the cell border in Google Docs

I'm trying to create a spreadsheet in Google Docs. I need a header at the top and a similar column at the left. To distinguish them from the rest of the table, I try them encourage the row that separates them from the rest of the table, such as the middle row below:

Enter the image description here

When I make a selection of cells, a small triangle appears in the upper right cell of the selection. If I click on it, I can choose which margins are displayed, but I can not control their formatting. When I select the menus: Format -> Paragraph Styles -> Borders and Shading, I can make the margin "under" any cell bold, but this does not affect the border, but an area above it:
Enter the image description here

How can I highlight only certain segments of table borders?

Can I use conditional formatting to mark a cell for dates less than 30 days away?

I have a large table where I have to keep track of upcoming expiration dates, and I want dates that are within 30 days of today's date or have already passed through to be marked in red.
However, everything I've found online causes the whole column to be highlighted or not, whatever I do.

What would the formula be to highlight both data that already exceeded AND data within the next 30 days?

Google Sheets: Conditional Formatting – Custom Formula – contains text

Okay, in column B, I have dates that contain days of the week in the following format: DDD, MMM DD, YYY (for example, Sat, January 19, 2019).

I want each line to be automatically formatted to a specific background color based on the day of the week in column B.

So if B1 contains "Sat", I want row 1 to turn blue.
If B100 contains "Sat", I want line 100 to turn blue.

I tried to use suggestions from these threads like regexmatch:
Conditional formatting based on a portion of the text

or countif:
https://stackoverflow.com/questions/27723102/finding-partial-texts-in-conditional-formatting-custom-formula-is

But none of them seem to work for me.

I am at a loss. Every help is appreciated.

Views – Formatting paragraphs in JSON, in my Drupal powered REST API

1 & # 39; m to organize paragraphs with my content. From the project has many paragraphs. Each paragraph can be of type text or images (thanks to paragraph type function).

1 want to expose my salary to a REST API. 1 so creates a view with a rest import listing projects.

Here's an example of the data I'm getting. This project has three paragraphs (called slides);

[
{
"Title": "My project title"
"Field_slides" "
  •   
     N  n  
     n    
    image
     n              
       N  n
     n          
     N  n      
     n
  •   
     N  n  
     n    
    text
     n              
    Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed temporal and vitality, leaving the work and the grief to do some important things eiusmod. Over the years, I will come, the aliquip nostrud will take advantage of the exercise, making stimulus efforts when the school district and longevity. Would you be a pain in the cupidatat cillum has been criticized in the Duis et dolore magna flee produces no resulting joy. Excepteur cupidatat blacks are not excepteur, the soul is soothing, that is, they leave the common duties of those who are to blame for their labors.
     n          
     N  n      
     n
  •   
     N  n  
     n    
    image
     n              
       N  n
     n          
     N  n      
     n
"
}
]

All slides are on a string. It also shows the edit link and some other HTML markup and 1 can not use this format with my client API.
Ideally, the slides (3 slides here so an array of objects 3) and only slide show content (raw text or image URL) need to be separated. In this way 1 could consume my api.

Any idea how 1 can achieve this?

list – Use the ampersand (&) in the JSON column formatting

I'm trying to use JSON to format a Person column in a Sharepoint list with an email action button.

I want the email to contain a link to the sharepoint list item, but the link contains an ampersand (&).

Unfortunately, the ampersand is a special character and chops the string after the 1st ampersand (as described here). Is there a way to stop this by treating & as an icon instead of a special character?

To dynamically set a column to actionParams when you use a formatting action in JSON – MS FLOW

I am working to trigger ms flow from a link in sharepoint via the modern UI list.
I can trigger the link and trigger the flow, but instead of hard-coding the flow GUID, I want to store it in a field in SharePoint and pass it as an action parameter in the JSON.
Is that possible? See the JSON screenshot below for custom formatting

{
"$ schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
"elmType": "span",
"Style": {
"color": "# 0078d7"
},
"Children": [
    {
      "elmType": "span",
      "attributes": {
        "iconName": "Flow"
      }
    },
    {
      "elmType": "button",
      "style": {
        "border": "none",
        "background-color": "transparent",
        "color": "#0078d7",
        "cursor": "pointer"
      },
      "txtContent": "Start Flow",
      "customRowAction": {
        "action": "executeFlow",
         //How can i pass a column field name there to the ID instead of the hardocded GUID?
        "actionParams": "{"id": "c42f9124-653d-468a-8178-07063e5f5c88"}"
      }
    }
  ]
}

8.0 oreo – App location change button after formatting SD card lost?

I'm on Oreo and previously had a "change" button under the memory area of ​​most apps that would move a few KB of the app to the SD card. I've just formatted the SD card for internal storage, and that button no longer exists. Can not I move apps to the SD card now, or is there a way to do that? Why is the button gone? (By default, apps do not have their own storage, not SD, I've installed a new app to test it.)

Formatting – Keep the size of the math variables as you copy them to a text cell

If I enter a mathematical cell, the text of any variable or operator can remain constant (in my case 13 pt). However, when I try to enter equations into my text cell (for analysis / discussion), the text will be scaled. Part of the type is 13, and everything on a fraction is reduced to 9.94. If I select all and set the size using the write wizard, only the maximum is set and fractions are reduced.

Since this is just idiots for quantum mechanics and physicists, I have mixed x, y, y, z, w, w, s, s, and so on into my equations, so scaling can make it incredibly difficult to understand my equations However, typing formatted text into mathematical cells is a nightmare.

Output formatting – fine-tuning of PlotLabel graphics – Lissajous curves

Overall, I am very satisfied with my Lissajous curves Poster makers; But getting the finishing touches to the graphics was a challenge. I've tried two different ways to limit the proportions between the curves equally: 1) Force the graph labeling ratio above a line and; 2) An attempt was made to force the proportions of the use PlotRange, I do not suppose there are any Mathematica Experts who would like to share options for improving these graphical features? (I hope I can make some really big plans with my free one Mathematica Online cloud credits.)

makeLurves[cols_,rows_] : = Module[{graphics, radius = 0.45},
 (* Subroutines *)
 functionX[anglevar_, freq_] : = Radius * sin[freq anglevar];
functionY[anglevar_, freq_] : = Radius * Cos[freq anglevar];
(* Draw graphic *)
Graphic = Table[
  ParametricPlot[{functionX[t,x]funktiony[t,y]}, {t, 0.2 Pi}
Frame-> False,
Axis-> wrong,
PlotStyle-> directive[Thick,Black],
PlotRange -> {{-. 5, .5}, {-. 5, 5}},
Mesh-> Automatic,
Performance goal -> "speed",
PlotLabel-> TraditionalForm[x/y ],
AspectRatio> 1],
{x, rows}, {y, columns}
];
Graphics Grid[graphics,
 Frame->All,
 ImageSize->800]
]makeLurves[6,6] // rasterize

Enter the image description here