Assigned
Status Update
No update yet.
Comments
ca...@google.com
Hello,
Thank you for contacting the Google Cloud support team.
I have gone through your reported issue, however it seems like this is an issue observed specifically at your end within your project environment. It would need more specific debugging and analysis. To ensure a faster resolution and dedicated support for your issue, I kindly request you to file a support ticket by clicking
Please note that the Issue Tracker is primarily meant for reporting commonly observed issues and requesting new features. For individual support issues, it is best to utilize the support ticketing system. I'm going to close this issue which will no longer be monitored. If you have any additional issues or concerns, please don’t hesitate to create a new issue on the
Thank you, we appreciate your cooperation!
fu...@gmail.com
Hi Carles,
that sounds great! You got the idea!!!
Actually, I tried using build method just until I found out it couldn't be used as a return of a custom function, but yes, that's essencially what I (and maybe other users) would like to achieve.
Thanks for the fast reply and attention.
that sounds great! You got the idea!!!
Actually, I tried using build method just until I found out it couldn't be used as a return of a custom function, but yes, that's essencially what I (and maybe other users) would like to achieve.
Thanks for the fast reply and attention.
ca...@google.com
Hello again,
Thanks a lot for your clarifications.
I have brought this feature request up internally. As soon as I have any news I will notify them here.
Kind regards,
Carles
Thanks a lot for your clarifications.
I have brought this feature request up internally. As soon as I have any news I will notify them here.
Kind regards,
Carles
is...@google.com
gi...@gmail.com
I have just stumbled into exactly the same problem, so I fully support the request
ka...@gmail.com
The return of RichTextValue will be much appreciated, because currently it is lost in functions.
My use case: copying one of the cells from the range to the current cell, rich formatting is lost currently.
My use case: copying one of the cells from the range to the current cell, rich formatting is lost currently.
xe...@gmail.com
Hello,
I'm not sure how I came across this, and I'm not a programmer!
Still, I would like to know if it's possible to copy the value from another cell retaining the rich text, be it via a custom function ( =COPYRTF( cell) ) or another built in feature;
Thanks!
I'm not sure how I came across this, and I'm not a programmer!
Still, I would like to know if it's possible to copy the value from another cell retaining the rich text, be it via a custom function ( =COPYRTF( cell) ) or another built in feature;
Thanks!
li...@oleniklaw.co.il
Hi all,
In my case, just part of the cell is a hyperlink.
Has this been solved? i.e. formatting completely lost when copying a cell that contains richtext to another cell.
The strange thing is that when you copy-paste manually, it does work and it does copy the cell perfectly, including formatting.
In my case, just part of the cell is a hyperlink.
Has this been solved? i.e. formatting completely lost when copying a cell that contains richtext to another cell.
The strange thing is that when you copy-paste manually, it does work and it does copy the cell perfectly, including formatting.
da...@gmail.com
Hi there,
I'd like to also add my voice to being able to return single RichTextValues or arrays of RichTextValues in custom functions.
My use-case is deisgning custom functions that help build a home budgeting speadsheet where a user can define expenditure categories (in a Categories Sheet) with colour-coded formating on each category tag, and these colours would be copied to the matching rows on the bank account transation data Sheet (by regex matching into the transaction description cell).
It would be much more convenient to just copy the style over rather than setting up a menu funciton that defined conditional formating rules.
Many thanks!
I'd like to also add my voice to being able to return single RichTextValues or arrays of RichTextValues in custom functions.
My use-case is deisgning custom functions that help build a home budgeting speadsheet where a user can define expenditure categories (in a Categories Sheet) with colour-coded formating on each category tag, and these colours would be copied to the matching rows on the bank account transation data Sheet (by regex matching into the transaction description cell).
It would be much more convenient to just copy the style over rather than setting up a menu funciton that defined conditional formating rules.
Many thanks!
an...@gmail.com
Hi,
I would love to have this as well. I'm working on the resource planning application.
Thank You,
Andrew
I would love to have this as well. I'm working on the resource planning application.
Thank You,
Andrew
[Deleted User] <[Deleted User]>
This would be great, so support the request and returning the RichTextValues from the formulas
sr...@nithyananda.org
I also find this feature useful. In fact, ideally, I would like to be able to create rich text using both spreadsheet formulas and spreadsheet macros.
do...@gmail.com
+1
wi...@gmail.com
+1
mc...@gmail.com
+1
hm...@umich.edu
+1
[Deleted User] <[Deleted User]>
+1
ps...@gmail.com
+1
sa...@gmail.com
+1
sc...@gmail.com
+1
an...@squareup.com
+1 this came up for me today. Very surprised that it's possible to create a RichTextValue but that I can't return it from a function :/
an...@gmail.com
+1
[Deleted User] <[Deleted User]>
+1
ma...@gmail.com
+1
[Deleted User] <[Deleted User]>
If this would help anyone here - while you can't return RichTextValue as a function, you can set the value to a specied cell (or range if using RichTextValues), so if you can read and write from/to fixed cells this can work!
sk...@boweryfarming.com
+1
sm...@gmail.com
+∞
Would like to create a metadata sheet for each spreadsheet which would describe the contents of each of the sheets.
In this way the activities of each sheet could be inspectable (also why does the chrome spell checker think inspectable has a space between inspect and able?) and displayable from other sheets.
This would make managing lots of spreadsheets that relate to each other possible directly from the spreadsheets similar to how a Zettlekasten index works.
If there is some security reason why this is not possible please indicate this. What is the current status of this request?
Would like to create a metadata sheet for each spreadsheet which would describe the contents of each of the sheets.
In this way the activities of each sheet could be inspectable (also why does the chrome spell checker think inspectable has a space between inspect and able?) and displayable from other sheets.
This would make managing lots of spreadsheets that relate to each other possible directly from the spreadsheets similar to how a Zettlekasten index works.
If there is some security reason why this is not possible please indicate this. What is the current status of this request?
bg...@gmail.com
+1
ry...@gmail.com
+1
ma...@gmail.com
+1
sp...@gmail.com
+1
cl...@yosyshq.com
+1
an...@gmail.com
+1
ol...@grasp.gg
+1
ol...@gmail.com
Comment has been deleted.
[Deleted User] <[Deleted User]>
+1
dh...@carleton.edu
Please fix this. It is immensely deflating to spend all this time trying to (a) write a custom function for something that seems like it should be baked-in, and (b) finish writing the code only to find that the finished RichTextValue cannot be assigned to the cell.
ci...@gmail.com
It would be very useful to be able to return a hyperlink from a function.
Even if it was possible to return a new formula from a function so we could return "=HYPERLINK(\"www.google.com \", \"Example Link\")"
and it would re-interpret that. You could limit this to not allow a new custom function in that return, or just keep executing whatever is returned in the same 30 runtime limit
Even if it was possible to return a new formula from a function so we could return "=HYPERLINK(\"
and it would re-interpret that. You could limit this to not allow a new custom function in that return, or just keep executing whatever is returned in the same 30 runtime limit
ma...@gmail.com
+1
nu...@gmail.com
Script to start "pm" on the device, which has a very rudimentary
shell.
base=/system export CLASSPATH=$base/framework/pm.jar exec
dr...@gmail.com
+1
ch...@contractors.roche.com
Comment has been deleted.
im...@seven-shapes.com
+1
bi...@gmail.com
Just checking back in on this. Seems like this wouldn't be that tall an order? Maybe there's a workaround?
[Deleted User] <[Deleted User]>
This seems like a crucial feature.
[Deleted User] <[Deleted User]>
+1
ma...@gmail.com
Me: "Finally, I've figured out how to get it to work, behold my custom function that formats only part of the cell's text! Now I just have to return the value and..."
cell in Sheets: ( blank... )
Me: ( ;v;)
+1
lg...@coursera.org
+1
AND it should show an error instead of an empty string/blank. Was scratching my head for a long time debugging why the final string got blank
AND it should show an error instead of an empty string/blank. Was scratching my head for a long time debugging why the final string got blank
ca...@gmail.com
I've been struggling for hours to get permission to edit a cell in a spreadsheet owned by the same email address because I have to use `setRichTextValue` to work around this bug.
jp...@google.com
ro...@gmail.com
Still no way? Argh.... I've been looking for a way to do this for years.
oc...@gmail.com
+1
wp...@bamboohr.com
+1
ji...@googlemail.com
+1
ev...@thistle.co
+1
ja...@gmail.com
+1
je...@factshaven.com
I vote for having the ability to return rich text from a custom function.
[Deleted User] <[Deleted User]>
+1
jo...@gmail.com
+1
ke...@edmonton.ca
Has anyone determined a workaround....I really need this.
br...@fortisgames.com
Any updates on that?
lg...@coursera.org
This would make scripts so much more useful! Strong +1 here
ma...@gmail.com
it makes no sense how such a major feature doesn't exist, I mean come on ! it's 2024 ! How is it possible to not be able to return a RichText ??????
EVERYTHING has RichText support nowadays...
Sure you can use RichText in Google Sheets technically but not via Scripts even though that's were it's the most useful ?
Disappointing..
pr...@gmail.com
+1 to being able to return single RichTextValues or arrays of RichTextValues in custom functions.
je...@googlemail.com Restricted+
Restricted+
Comment has been deleted.
pa...@therrien.ca
+1
to...@gmail.com
+1
lo...@gmail.com
+1
Description
RichTextValue was a great new feature recently introduced, thank you Google s2. The only downside I've noticed is that it cannot be used as a return of a custom function. So, I thought it would be very useful to have a method, let's say "getRichTextValue", under class RichTextValue that would return a formatted text to a cell on a sheet running a custom function. Right now method "getText()" under RichTextValue only returns raw text values.
What is the purpose of this new feature?
To have RichTextValue as a return of a custom function.
What existing data does this use?
Users would have to build formatted text using RichTextValueBuilder and call the new method "RichTextValue().getRichTextValue()" to write formatted text to a given cell on a spreadsheet.
Please provide any additional information below, including the particular use cases you believe this feature would enable or improve.
Example:
//function returns the word "text" with bolded "te" on a cell running this custom function
function test(){
var bold=SpreadsheetApp.newTextStyle().setBold(true).build();
var test=SpreadsheetApp.newRichTextValue().setText("test").setTextStyle(0,2,bold).build().getRichText();
return test;
}
sometimes users (at least I do) like to make only part of a text bold/italic/underlined/etc/etc, and sometimes it is not possible (or not preferable) to separate cells to do it, hence the creation of RichText classes. Some of these users (at least I do) use custom functions to automate processes. So, let's get these two together and make this world a better place =P