Show newer
Yagisanatode

Get the last value in a range in Google Sheets @WorkspaceDevs
youtube.com/watch?v=9JGiO5_lqF

0
Yagisanatode

Prevent consecutive clicks of Google Sheets Image Buttons in with Lock Service and Google Apps Script @WorkspaceDevs
yagisanatode.com/prevent-conse

0
Yagisanatode

This article by @edzitron very much articulates my experiences and feelings about the current tech industry. Good products left to stagnate or enshitify while products we don't need are forced down our throats all in the name of 'innovation'. wheresyoured.at/rotcombubble/

0
Yagisanatode

Now choose to display ALL selected Shared Drive folders OR only those created by you in the Product version of 'List all Files and Folders in a Google Drive Directory in Google Sheets'

yagisanatode.com/products/prod

@WorkspaceDevs

0
Yagisanatode

Generate UUIDs in Google Sheets with Apps Script (Unique IDs)

@WorkspaceDevs

youtu.be/xHTY6uZ1KuQ

0
Yagisanatode

Sort Sheet Tabs by Date in Google Sheets with Apps Script

@WorkspaceDevs

youtu.be/Uvd6JjKqVCM

0
Yagisanatode

Remove Empty Cells from Google Sheets QUERY

youtu.be/0oghlpgSvMw

0
Yagisanatode

Google Sheets QUERY by dates

youtu.be/8UpLqUCI4Tk

0
Yagisanatode

Update and Replace data in files like Text files, HTML, XML, JSON, and JS files in a Google Drive with Apps Script

@WorkspaceDevs

youtu.be/mi6Wb-da-GQ

0
Yagisanatode

Use HTML files stored on Google Drive in Apps Script web apps, dialogues and sidebars for Google Workspace.
youtu.be/6o1VS23hNTo

0
Yagisanatode

Extract CELL Background & Font Colours in Google Sheets with Apps Script @WorkspaceDevs
youtu.be/rD2S4cqyf1c

0
Yagisanatode

Google Sheets FILTER function Dates by Weekday or Weekend. Part 4 of the accompanying written tutorial on the FILTER function and dates and times.
youtu.be/kig03gNtO2A

0
Yagisanatode

Google Sheets FILTER function with Date Time Stamps is now out. Part 3 of the accompanying written tutorial on the FILTER function and dates and times with BONUS section where we use FILTER to filter any DTS after a specific time.
youtu.be/dsNVgw6rxGM

0
Yagisanatode

Google Sheets FILTER function and TIMES video is now out. Part two of the accompanying written tutorial on the FILTER function and dates and times.
youtu.be/ObgFUvty2vU

0
Yagisanatode

Google Sheets FILTER function and DATES video is now out. Part one of the accompanying written tutorial on the FILTER function and dates and times.
youtu.be/OUFvHW5sjUo

0
Yagisanatode

Show this Google Sheets API feature request some love with a comment or +1!:

## Inclusion of a 'setToFit' boolean in row metadata. `pixelSize` does not accurately read row assigned 'Fit to data'

### Description

#### Issue
There is currently no way to get or set the row height to `Fit to data` in the same way that you can in Google Sheets by right-clicking the row, `Resize row` > `Fit to data`.

The closest approximation is in `rowMetadata` > `pixelSize`. However, pixel size is inaccurately read when the row is set to `Fit to data`, reading only the default 21 pixels even when the data may expand the height of the row beyond this pixel height.

See this bug report for an example: [There is no way to get the real height of a row if its height is based on the height of the content in its cells.](issuetracker.google.com/issues). _*The Googler assigned to this bug recommended that a feature request should be made. This is the feature request._

#### Proposed Solution
Introduce the property: `setToFit` as a boolean into `rowMetadata` array of objects alongside `pixelSize`.

Just like when assigning `Fit to data` in Google Sheets, `setToFit` would take priority over `pixelSize` setting any row that has `setToFit` marked as `true` to a row height that would fit the data.

This is a low-memory solution for the API (boolean property) and does not require any modification of existing properties allowing it to be added to the existing API v4.

### Impact
Currently, devs must manually ensure that each row of data is not set to `Fit to data` before modifying duplicating or cutting and pasting ranges with the correct row height. Otherwise, the row heights will not be accurately represented.

With the inclusion of `setToFit` developers would be able to accurately determine if selected rows are based on the actual pixel height or `Fit to data`.

#### Getting and setting the row heights
Let's say a developer wants to copy a range of data from one Google Sheet or Sheet tab to another and ensure that they also duplicate the correct row height.

When iterating over their `rowMetadata` they would first check if `setToFit` is `true` If so, they would mark the property to true in their batch upload payload, otherwise, they would set the `pixelSize`.

issuetracker.google.com/issues

0
Yagisanatode

Copy and Paste Row Heights in Google Sheets with Apps Script. This is a surprisingly tricky and process-costly task. Learn how to do it efficiently while not falling for some common issues. @workspacedevs

youtu.be/HAx1LfcxdRA

0
Yagisanatode

Copying Ranges in Google Sheets with Apps Script - Part 4 in the beginner-friendly series on copying Sheets, Tabs and Ranges in with . Check it out!
@workspacedevs

youtu.be/q6Zh3I9mjeg

0
Yagisanatode

CASA Tier 2 Assessment finally passed for the update of my free 'Sections to Sheets' Google Workspace Editor Add-on.
It was an unusual process. Not necessarily time-consuming, but it did take weeks to process so be prepared for that, developer. @WorkspaceDev

0
Yagisanatode

Duplicate Google Sheets Tabs into other Spreadsheets with Apps Script.

Copy to:

1) a new Google Sheet,

2) an existing Google Sheet,

3) All tabs,

4) Selected tabs and

5) Except for certain tabs.

Beginner friendly. 🧸

@workspacedevs

youtu.be/te9bXK4DngE

0
Show older

googleworkspace

36

googlesheets

35

googleappsscript

34
Qoto Mastodon

QOTO: Question Others to Teach Ourselves
An inclusive, Academic Freedom, instance
All cultures welcome.
Hate speech and harassment strictly forbidden.

Trending now

Resources

Developers

What is Mastodon?

qoto.org

More…

v3.5.19-qoto · Privacy policy