Evan Plaice

677 reputation

520

bio	website	code.google.com/p/…
	location	Westminster, CO
	age	28
visits	member for	2 years, 10 months
	seen	Feb 8 at 17:09
stats	profile views	50

I'm passionate about coding and researching the history of technology as well as exploring where technology is leading.

I used to work in flight simulation doing both hardware implementation (electrical design, wiring), web development (design, development, webmaster), as well as software development (desktop development in C#).

I'm a big fan of both using and contributing to Open source projects.

I am the creator of the pypreprocessor library that can be found on PYPI as well as Google code.

	677 reputation	bio	website	code.google.com/p/…	visits	member for	2 years, 10 months
520 badges		location	Westminster, CO		seen	Feb 8 at 17:09

summary answers questions tags badges favorites bounties reputation activity

172 Actions

suggestions reviews revisions comments badges posts accepts all

May 6	awarded	Popular Question
Feb 8	comment	Text to columns conversion in Google Spreadsheets @bobesponja Thanks for the heads-up. I know there's a bug with Google Scripts where event triggers from imported scripts don't register properly. To fix it, just add the onOpen trigger manually.
Feb 1	comment	Text to columns conversion in Google Spreadsheets @JacobJanTuinstra In your first solution try copying B2 to B3. The result cells contain continuation formulas, not raw data. The cells outputted from the script contain the actual raw data so they can be copied/moved without any issues. The intent of this question is to find an equivalent to Excel's 'Text to Columns' feature. Until, Google officially adds support the script is as close as it's going to get.
Feb 1	revised	Text to columns conversion in Google Spreadsheets deleted 1281 characters in body
Jan 31	comment	Text to columns conversion in Google Spreadsheets @JacobJanTuinstra Because the capability can be added via Google Apps Scripting. I ended up solving my own problem by writing a 'Text To Columns' script that can now be found in the Script Gallery. Googlegooru also posted a video tutorial demonstrating its usage here googlegooru.com/text-columns-google-spreadsheets.
Jan 31	accepted	Text to columns conversion in Google Spreadsheets
Jan 3	awarded	Notable Question
Dec 14	awarded	Self-Learner
Dec 7	revised	Text to columns conversion in Google Spreadsheets added 85 characters in body
Dec 7	revised	Text to columns conversion in Google Spreadsheets added 85 characters in body
Nov 30	revised	Text to columns conversion in Google Spreadsheets added 106 characters in body
Nov 29	revised	Text to columns conversion in Google Spreadsheets added 229 characters in body
Sep 5	comment	How can I avoid sites that scrape and republish others? @Basilevs lol, I'm glad I could help.
Jul 10	awarded	Popular Question
Jul 7	awarded	Yearling
Feb 16	comment	How do I link a cell in Google Spreadsheets to a cell in another document? +1 Whoa! I didn't realize there was an in-line version. The other option is to use Google Apps scripting. Create a function that uses SpreadsheetApp.openById([ID]).getRange() and set a local range with that.
Feb 16	comment	Request for somebody to comment on a section of a Google Docs document? Damn... That's pretty spiffy.
Feb 16	comment	Block quote and folding in Google Docs Hopefully they'll bring the old format back. Until then, this is the only option. If you follow my link to GetSatisfaction.com they're aware that a lot of their users prefer the old format and from talking to the Google's rep, it doesn't sound like they're going to disable the old version any time soon.
Feb 16	comment	Block quote and folding in Google Docs To workaround all the browser inconsistencies, Google switched over to a SVG rendering model for Docs instead of using HTML. That's why the new version of docs doesn't support raw HTML/CSS editing. I have already raised the issue (and received a response) with Google on GetSatisfaction.com here getsatisfaction.com/google/topics/…. I'm hoping, with enough support we can get them to bring the old format back under a different name.
Feb 16	comment	Google Apps for Business Docs Backup No problem. I have been using Dropbox user since the start and Docs for the past year. The hard part is convincing the company I work for to do the same. If you wanted a shared solution in Google Apps for Business, one option would be to create a group account. Make the group account the owner of the shared docs within that group and attach the offline sync to the group account. With Insync, you can attach multiple nodes to a single account.