#Eldin Pieter hehim GMT 1 5324

1 messages · Page 1 of 1 (latest)

fierce dune
#

Like through an HTTP call, or through the built-in Javascript interpreter?

foggy vortex
crimson atlas
#

the actual google app script, so the built-in javascript interpreter.

#

yeah, that's what i've been reading

#

from what i'm understanding, i can use setItalic on a TextStyle object.
how do i get a TextStyle object? not sure, but it seems i can use getTextStyle on a TextRange object.

#

for THAT i have to use .getText on... a TableCell?

#

but after that, I can't figure it out. is TableCell its own thing? or is it a range object?

#

i'm super confused with this

fierce dune
#

Yeah, it's table_cell.getText().getTextStyle()

crimson atlas
#

how do i get a table_cell?
because range.getCell() doesn't seem to do it

fierce dune
#

Well, from the very top level it's something like

#

OH

#

LOL

#

So first of all

#

Ignore that link from Eldin because it's pointing at the Slides API

#

And then from the top it's something like

crimson atlas
#

oh! that was my problem too 😦

fierce dune
#

SpreadsheetApp.getActiveSpreadsheet().getSheetByName(name).getRange(some_inputs).getTextStyle()

#

lol I was looking at that and was like "Wow they changed this API a bunch since I was last here"

crimson atlas
#

lol! ty for realizing it and pointing it out!

#

that looks WAY intense

#

so, for sheets api, it is a bit different; there is no setItalic. it looks like it might use some kind of "builder"?

fierce dune
#

range.setFontStyle

foggy vortex
crimson atlas
#

thank you!

fierce dune
foggy vortex
#

I agree with you (now) 😄

fierce dune
#

Yeah it's this weird thing where the table embeds in Docs and Slides are two different things, and neither of them is the same as any of the Spreadsheets API (e.g. they don't support conditional formatting)