askvictor / columntools Goto Github PK
View Code? Open in Web Editor NEWGoogle Apps Script to bulk-convert selected columns to Named Ranges
Google Apps Script to bulk-convert selected columns to Named Ranges
When I try to sort horizontally, after I type in row 1 and run the add-on it says " A sheet with the name "SortTemp" already exists. Please enter another name "
In the confirmation prompts for making named ranges and conditional formatting, it would be nice to have an option 'Do not show this message again' that remembers the user knows what they're doing. Doesn't look like this can easily be done using the ui.alert method currently used, so would need to bring up an HtmlTemplate and use callbacks etc.
Hey Victor!
I love the add on! Whenever I create a new named range based on a column or row the title of the named range is listed as the first cell in my selection; however whenever using the newly-created named range as an index, the header cell is included and is throwing off my formulas.
Is there a way to update it to not include the header cell in the named range?
Desired: NamedRange = Sheet1!A2:A50 when NamedRange is in Sheet1!A1 and selection is Sheet1!A1:A50
vs
Current: NamedRange = Sheet1!A1:A50 when NamedRange is in Sheet1!A1 and selection is Sheet1!A1:A50
Thank you!
Hi - I keep getting the same error message when trying to use Column Tools to convert a column to a named range: ReferenceError: "msg" is not defined.
Does anyone know what that means?
Thanks!
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.