After some back and forth on the issue at ( https://issuetracker.google.com/issues/146274218), I agree that it's a bug. If called without a deep filter, the API shouldn't require more than one request to determine which of three mutually exclusive rotation states a cell is in (angled, vertical, none). Can someone at Google re-evaluate the issue's current "won't fix" status?
Regards, Dan On Saturday, December 21, 2019 at 11:43:54 AM UTC-5, Alex Ivanov ✔ wrote: > > I agree. > > As I name (it's not a version of anyone else) it it's *a deep value*. You > need to call this directly with fields property of the request params > > fields=sheets(data(rowData(values(userEnteredFormat(textRotation(angle > )))))) > > curl \ > ' > https://sheets.googleapis.com/v4/spreadsheets/1YvGje4cbSwHQwsQFYVQGfaYG4fm0LLd1T2RTjvZ5i5c?includeGridData=true&ranges=%27Sheet1%27!A1&fields=sheets(data(rowData(values(userEnteredFormat(textRotation(angle))))))&key=[YOUR_API_KEY] > ' \ > --header 'Authorization: Bearer [YOUR_ACCESS_TOKEN]' \ > --header 'Accept: application/json' \ > --compressed > > > returns > > { > "sheets": [ > { > "data": [ > { > "rowData": [ > { > "values": [ > { > "userEnteredFormat": { > "textRotation": { > "angle": 11 > } > } > } > ] > } > ] > } > ] > } > ] > } > > > As for me it's a bug. > > Best, Alex. > > On Monday, December 16, 2019 at 7:27:11 PM UTC+3, Dan wrote: >> >> Hi, >> >> Based on the documentation, it looks like the Get API should be returning >> a effectiveFormat.textRotation field of vertical:true for vertical text or >> angle:rotation for rotated text. Instead, it's returning vertical:false, >> and leaving off the angle. Is this a know bug? Is there a workaround? >> >> Thanks, >> Dan >> > -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-spreadsheets-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/f7c921d4-db7d-4fbc-a3a8-c93814dc1e54%40googlegroups.com.
