Archive: Google Spreadsheet Expert please help ! (50$)
Budget
50$
per month
Posted: 5 years ago
Closed
- Description
- Google Spreadsheet Expert please help ! (50$)
Hello! Thank you for having interest in this topic.
I am trying to have Google Spreadsheet as my main tool, but still, there are lots of missing points that I am not aware of and not accustomed enough. Maybe not knowing its feature, and now knowing it's shortcut.
So here I have a few questions. About Google spreadsheet usage. Please look into it and see if you can help me out kindly :)
Question 1:
When I write something in google spreadsheet cell, and fill some color inside, and copy this cell,
In my clipboard, it contains not only the texts that written, but also the color's value information of the cell.
So my question is, How would I grab or manipulate those values in clipboard?
Question 2:
related with Question 1, I wonder if I can make some cell directly filling certain color value just having the color code in my clipboard. Not through manual clicking process around tools in Google spreadsheet, I wish I can fell in cell's color just by clipboarded Cell information, which contains the color value (color code)
Do you think it's possible?
For example ) in my clipboard, there could be the cell's already completed information such as "Colorcode = 0x124445 , Rawtext = Work:"
so when I press Ctrl + v, pasting the clipboarded cell information, it automatically even change the color inside of the cell in Google Spreadsheet.
Question 3:
How would I be able to withdraw only plain raw texts from a cell that contains color information inside? so when I paste the clipboarded information, it perfectly fits inside of the cell, whether its color is green or red or black, just fitting in as plain text. not whitening the cell's color.
For example, in Google spreadsheet, we can double-click inside of the cell, then we can grab its plan text. and when pasting it in another cell, we can double click inside of the cell again and paste it, in this case, it perfectly preserve the cell's color even though it's cell copy-paste process. Can we achieve it with simple hotkeys?
Question 4:
When trying to move around the cells inside of google spreadsheet, What I currently do is, (1) Selecting the target cell, (2) Press Ctrl+c (3) Press Esc (to wipe out the original cell info since it's purpose is cell moving) (4) then paste it to target cell position.
but then, for some reason, the format of the moved cell is changed.
for example) When I set the spreadsheet format as text-middle-placed, by pressing Ctrl + a and clicking to text-middle-place, when after moving the cell, the cell's format is changed as text-edgy-placed.
It automatically changes the format when I move around the cells.
Do you have any solution to set default spreadsheet shape? so I don't have to change the cell's format again everytime I move the cells?
Question 5 (Optional): + (10$)
Withdrawing the spreadsheet into my android background.
I want to get the widget of Google Spreadsheet and tried to withdraw my spreadsheet into my Android device background, But everytime I try it fails. And it's only available to withdraw "new-made" spreadsheet.
Will there be any solution for this? when it could be solved, I will reward you further 10$. separately original reward 50$.
Essential Feature note 1:
please be noted that cell-clipboard information manipulation is the main question in this project.
Essential Feature note 2:
If you think you can answer those questions above, please kindly, film/videocapture the process and show me as video tutorial. :)
Thank you for reading! Have a good day and bid me if you think you can build one. Anytime !
And I am willing to respond very quickly to explain more what I exactly need.
also, if you can really make it out well this time in this project, I will promise to carry out further projects with you. Thanks alot.
Skills:
video,google spreadsheets,tutorial,android,film industry,general programming,software development,widget
- Category
Drag