Grab the formula from any cell, edit the text, view to check for syntax, and save. The dream of divorcing yourself from the formula bar comes true.
Works with:
150
Overview
Pretty Print-n-Edit Formulas lets you display formulas that are in any cell, and “pretty prints” them, saving eyesore. You can also edit and update the cell.
Additional information
PricingNot available
Developer
Trader status unspecified
Privacy policy
Terms of service
Pretty Print-n-Edit Formulas will ask for the permissions shown below. Learn more
Pretty Print-n-Edit Formulas will need access to your Google account
This will allow Pretty Print-n-Edit Formulas to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Patrick
June 12, 2024
Room for improvment. You only see the formatted text in the sidebar. Personally, i dont like working in the sidebar. When you save it, It saves it as 1 line. Might as well copy the code into a code editor and paste it back in. I want to see the formula pannel with line breaks and indents to be converted to spaces up top. It would be better if you just run the fucntion from the menu and it formats your formula as such. Also your script removes spaces in quotes(text i want to return in the cell), i would make a rule that omits formatting for things inside " ". When I copy paste code in from another app it keeps the indent formatting so i know its possible. I realize sheets doesnt know what cell you are working in until you made the edit. Maybe you would have to make a function that works with onSelectionChange to identify the current cell and then when you run the formatting script it will apply to whatever is selected. Food for thought. Could easily be a 5* extension :)
Is this review helpful?
Yes
No
1-1 of 1
Search
Clear search
Close search
Google apps
Main menu