Status Update
Comments
[Deleted User] <[Deleted User]> #2
Looking at the exiftool data, it reports Orientation = 6, which is rotated 90 degrees counter-clockwise and needs 90 degrees clockwise rotation to appear correct. Of course, it's unusual that a Google format would be correct in exiftool and not in Google's own ExifInterface library. I see it's also not handling the rotation as I would expect in Chrome.
exiftool -V ~/Downloads/676x380.webp
ExifToolVersion = 12.60
FileName = 676x380.webp Dog\ Yule\ Log.mp4 Lil\ Bub\ Video\ Yule\ Log.mp4 android-studio-2022.2.1.19-mac_arm.dmg gradle.properties simpsons_background.png
Directory = /Users/clee/Downloads
FileSize = 116812
FileModifyDate = 1683650274
FileAccessDate = 1683655195
FileInodeChangeDate = 1683654924
FilePermissions = 33188
FileType = WEBP
FileTypeExtension = WEBP
MIMEType = image/webp
FileType [override] = Extended WEBP
FileTypeExtension [override] = WEBP
RIFF 'VP8X' chunk (10 bytes of data):
VP8X (SubDirectory) -->
+ [BinaryData directory, 10 bytes]
| WebP_Flags = 8
| ImageWidth = 2063598243
| ImageHeight = 97024
RIFF 'VP8 ' chunk (53444 bytes of data):
VP8Bitstream (SubDirectory) -->
+ [BinaryData directory, 53444 bytes]
| VP8Version = 0
| ImageWidth = 676
| HorizontalScale = 0
| ImageHeight = 380
| VerticalScale = 0
RIFF 'EXIF' chunk (63321 bytes of data):
Warning = [minor] Improper EXIF header
EXIF (SubDirectory) -->
+ [TIFF directory]
| ExifByteOrder = II
| + [IFD0 directory with 12 entries]
| | 0) ImageWidth = 4000
| | 1) ImageHeight = 3000
| | 2) Make = samsung
| | 3) Model = SM-S908U1
| | 4) Orientation = 6
| | 5) XResolution = 72 (72/1)
| | 6) YResolution = 72 (72/1)
| | 7) ResolutionUnit = 2
| | 8) Software = S908U1UES2CWCC
| | 9) ModifyDate = 2023:04:22 09:15:37
| | 10) YCbCrPositioning = 1
| | 11) ExifOffset (SubDirectory) -->
| | + [ExifIFD directory with 30 entries]
| | | 0) ExposureTime = 0.03333333333 (1/30)
| | | 1) FNumber = 2.2 (220/100)
| | | 2) ExposureProgram = 2
| | | 3) ISO = 400
| | | 4) ExifVersion = 0220
| | | 5) DateTimeOriginal = 2023:04:22 09:15:37
| | | 6) CreateDate = 2023:04:22 09:15:37
| | | 7) OffsetTime = -05:00
| | | 8) OffsetTimeOriginal = -05:00
| | | 9) ShutterSpeedValue = 0.03333333333 (1/30)
| | | 10) ApertureValue = 2.27 (227/100)
| | | 11) BrightnessValue = 0.21 (21/100)
| | | 12) ExposureCompensation = 0 (0/100)
| | | 13) MaxApertureValue = 2.27 (227/100)
| | | 14) MeteringMode = 2
| | | 15) Flash = 0
| | | 16) FocalLength = 2.2 (220/100)
| | | 17) SubSecTime = 960
| | | 18) SubSecTimeOriginal = 960
| | | 19) SubSecTimeDigitized = 960
| | | 20) FlashpixVersion = 0100
| | | 21) ColorSpace = 1
| | | 22) ExifImageWidth = 676
| | | 23) ExifImageHeight = 380
| | | 24) ExposureMode = 0
| | | 25) WhiteBalance = 0
| | | 26) DigitalZoomRatio = 1 (100/100)
| | | 27) FocalLengthIn35mmFormat = 13
| | | 28) SceneCaptureType = 0
| | | 29) ImageUniqueID = DA8XLOD01SM
| + [IFD1 directory with 8 entries]
| | 0) ImageWidth = 512
| | 1) ImageHeight = 384
| | 2) Compression = 6
| | 3) XResolution = 72 (72/1)
| | 4) YResolution = 72 (72/1)
| | 5) ResolutionUnit = 2
| | 6) ThumbnailOffset = 852
| | 7) ThumbnailLength = 62463
ma...@rioclarense.com.br <ma...@rioclarense.com.br> #3
For context, I found this because I got a bug report about a similar issue with an upside down photo on a Samsung Galaxy S10 and managed to reproduce the problem as a sideways WEBP on an S22 Ultra. I can supply more pictures from different Samsung models exhibiting this same problem if that would be useful.
mm...@inboundcycle.com <mm...@inboundcycle.com> #4
Will anyone please take a look at this bug? It appears on many, very common devices and results in mis-rotated images.
sp...@spell.ml <sp...@spell.ml> #5
Hi,
I can confirm there is an issue with the WebP exif reading implementation. I ran into the same issue when retrieving WebP images from the Amazon's Serverless Image Handler. Initially I thought it was a bug in the library I'm using (Coil) but found out it wasn't the case.
I have a bugfix available for the issue and am preparing a PR (that will be submitted via Gerrit).
Validated with my own images (a yellow sticky note captured at all 4 orientations) + the one from the google repo + the one from the topic starter.
Note: The bottom left image is a google webp without exif, the bottom right image is a google webp with exif
Note 2: It's also broken in Chrome & Firefox but works correctly on Safari/Finder on MacOS. I might submit bugfixes for those too.
ka...@valeo.com <ka...@valeo.com> #6
st...@gmail.com <st...@gmail.com> #8
Thanks for the detailed investigation! I've replied on the PR with more details - but I'm not sure this image is a valid WebP.
da...@gmail.com <da...@gmail.com> #9
Branch: androidx-main
commit 161d43d41357f5d34fe7907c82ed9fca0b04d57a
Author: Laurence Muller <laurence.muller@gmail.com>
Date: Fri Dec 22 14:38:22 2023
Fix attribute reader for WebP images with Exif App1 Sections
The current attribute reader for WebP images fails to read the attributes if the Exif metadata contains an Exif App1 Section. The reason is that the byte-order is specified after the Exif App1 Section marker in the Exif payload. This patch will check if the Exif App1 section is present and correct the payload accordingly. This will allow it to read the Exif metadata (such as image orientation) correctly.
Test: Added a new image to cover this use case with a test. Run the instrument test using: ./gradlew :exifinterface:exifinterface:connectedAndroidTest
Fixes:
Change-Id: Idbb14e9fbcb038616ce650da03ed1d7eb9f997a5
M exifinterface/exifinterface/src/androidTest/java/androidx/exifinterface/media/ExifInterfaceTest.java
A exifinterface/exifinterface/src/androidTest/res/raw/invalid_webp_with_jpeg_app1_marker.webp
M exifinterface/exifinterface/src/androidTest/res/values/arrays.xml
M exifinterface/exifinterface/src/main/java/androidx/exifinterface/media/ExifInterface.java
ma...@lovehoney.co.uk <ma...@lovehoney.co.uk> #10
Hi, since this issue is now fixed in the codebase, is there any timeline on when this will be rolled out via a minor update (e.g v1.3.8)?
Would love to be able to use Exifinterface without having to use local workarounds in my apps.
[Deleted User] <[Deleted User]> #11
This will be included in 1.4.0, likely released sometime in Q2 - I'm afraid we won't be doing a 1.3.8 release as the current exifinterface
release branch is too old and we need to snap it to a more recent version from androidx-main
.
da...@google.com <da...@google.com> #12
Branch: androidx-main
commit fd3fee5a3ef4d40a3a35a869b7bfb2399e63e814
Author: Ian Baker <ibaker@google.com>
Date: Tue Feb 20 18:16:04 2024
Add comment for test added in
Test: ExifInterfaceTest
Bug: 281638358
Change-Id: Ied3650ee5d2bf290556c86ad546c3e28bd2f8d8a
M exifinterface/exifinterface/src/androidTest/java/androidx/exifinterface/media/ExifInterfaceTest.java
vf...@valeo.com <vf...@valeo.com> #13
The following release(s) address this bug.It is possible this bug has only been partially addressed:
androidx.exifinterface:exifinterface:1.4.0-alpha01
ta...@gmail.com <ta...@gmail.com> #14
Alternatively, putting this in PageElement, and allowing any PageElement that can be linked would be useful. Right now the behavior is only applicable to SheetCharts and to a degree Image (which doesn't implement refresh).
[Deleted User] <[Deleted User]> #15
jc...@gmail.com <jc...@gmail.com> #16
[Deleted User] <[Deleted User]> #17
[Deleted User] <[Deleted User]> #18
Currently, you can automatically refresh Charts, but it does not look like that is possible with Tables.
It seems like the only way to automate this is to recreate the Slides with the API each time the data changes, rather than using links back to Google Sheets.
si...@xero.com <si...@xero.com> #19
dr...@gmail.com <dr...@gmail.com> #20
ar...@gmail.com <ar...@gmail.com> #21
[Deleted User] <[Deleted User]> #22
[Deleted User] <[Deleted User]> #23
no...@re-com.fr <no...@re-com.fr> #24
[Deleted User] <[Deleted User]> #25
to...@gmail.com <to...@gmail.com> #26
mi...@gmail.com <mi...@gmail.com> #27
[Deleted User] <[Deleted User]> #28
wi...@altschool.com <wi...@altschool.com> #29
ko...@gmail.com <ko...@gmail.com> #30
[Deleted User] <[Deleted User]> #31
ma...@gmail.com <ma...@gmail.com> #32
al...@gmail.com <al...@gmail.com> #33
[Deleted User] <[Deleted User]> #34
st...@gmail.com <st...@gmail.com> #35
jr...@fossil.com <jr...@fossil.com> #36
Using Google Suite for business in a rather big company (as email suggests) and our will is to "Googlize" a lot of our documents, which includes KPIs reports/dashboards.
I often create presentation slides to show global KPIs to stakeholders and embed charts and figures/rates from spreasheets.
As I'm looking for a 1-click feature, I've already implemented a refresh() method to update all of my charts at once. I've also added period and variation rates in it and would really appreciate to be able to use a refresh()-like method to update all my single cell tables for each slide, even via script.
Hopefully our prayers will be worth it !
Thanks guys
er...@gmail.com <er...@gmail.com> #37
vl...@gmail.com <vl...@gmail.com> #38
ca...@whiting-turner.com <ca...@whiting-turner.com> #39
This is important feature. I'm using Chrome Sign Builder in dozens of displays. Currently Google Slides is missing two key features in this category. 1) Method to Skip/Unskip slides and 2) way to update linked content from Sheets or Slides.
[Deleted User] <[Deleted User]> #40
ad...@pickandgo.ovh <ad...@pickandgo.ovh> #41
[Deleted User] <[Deleted User]> #42
[Deleted User] <[Deleted User]> #43
za...@gmail.com <za...@gmail.com> #44
Would save us so much time and effort.
ma...@gmail.com <ma...@gmail.com> #45
sm...@gmail.com <sm...@gmail.com> #46
[Deleted User] <[Deleted User]> #47
[Deleted User] <[Deleted User]> #48
ti...@google.com <ti...@google.com>
[Deleted User] <[Deleted User]> #49
ma...@gmail.com <ma...@gmail.com> #50
Everyone would love to hear answers to these Burning questions.
- Will this feature be added to Google Slides?
- Will this feature be added to the Google Slides API V1 or will it show up in a V2 release?
- What kind of timeline should we expect? <- This is the question that if answered would make people the most happy.
I would greatly appreciate a response.
Thanks for all you guys do.
er...@ericdush.com <er...@ericdush.com> #51
[Deleted User] <[Deleted User]> #52
[Deleted User] <[Deleted User]> #53
[Deleted User] <[Deleted User]> #54
ma...@gmail.com <ma...@gmail.com> #55
ad...@ddsb.ca <ad...@ddsb.ca> #56
[Deleted User] <[Deleted User]> #57
do...@tcd.ie <do...@tcd.ie> #58
be...@phooto.com.br <be...@phooto.com.br> #59
[Deleted User] <[Deleted User]> #60
[Deleted User] <[Deleted User]> #61
[Deleted User] <[Deleted User]> #62
ha...@gmail.com <ha...@gmail.com> #63
[Deleted User] <[Deleted User]> #64
[Deleted User] <[Deleted User]> #65
rg...@gmail.com <rg...@gmail.com> #66
zs...@gmail.com <zs...@gmail.com> #67
[Deleted User] <[Deleted User]> #68
[Deleted User] <[Deleted User]> #69
da...@schibsted.com <da...@schibsted.com> #70
rm...@gmail.com <rm...@gmail.com> #71
to...@2degrees.nz <to...@2degrees.nz> #72
ww...@gmail.com <ww...@gmail.com> #73
th...@gmail.com <th...@gmail.com> #74
al...@gmail.com <al...@gmail.com> #76
yu...@gmail.com <yu...@gmail.com> #77
be...@ask4.com <be...@ask4.com> #78
jo...@gmail.com <jo...@gmail.com> #79
vb...@motorola.com <vb...@motorola.com> #80
mu...@motorola.com <mu...@motorola.com> #81
hu...@motorola.com <hu...@motorola.com> #82
rg...@audienceproject.com <rg...@audienceproject.com> #83
vc...@audienceproject.com <vc...@audienceproject.com> #84
je...@latam.com <je...@latam.com> #85
la...@gmail.com <la...@gmail.com> #86
ma...@noaa.gov <ma...@noaa.gov> #87
lu...@gmail.com <lu...@gmail.com> #88
ol...@gmail.com <ol...@gmail.com> #89
ra...@gmail.com <ra...@gmail.com> #90
tg...@wayfair.com <tg...@wayfair.com> #91
pa...@airbus.com <pa...@airbus.com> #92
th...@gmail.com <th...@gmail.com> #93
lo...@iris-worldwide.com <lo...@iris-worldwide.com> #94
[Deleted User] <[Deleted User]> #95
be...@gmail.com <be...@gmail.com> #96
wi...@gmail.com <wi...@gmail.com> #97
je...@noaa.gov <je...@noaa.gov> #98
ty...@gmail.com <ty...@gmail.com> #99
ch...@airgas.com <ch...@airgas.com> #100
ma...@johnlewis.co.uk <ma...@johnlewis.co.uk> #101
er...@gmail.com <er...@gmail.com> #102
ti...@farfetch.com <ti...@farfetch.com> #103
c....@gmail.com <c....@gmail.com> #104
c....@gmail.com <c....@gmail.com> #105
MAKE
THIS HAPPEN
GOOGLE SAN
ma...@gmail.com <ma...@gmail.com> #106
[Deleted User] <[Deleted User]> #107
sk...@gmail.com <sk...@gmail.com> #108
[Deleted User] <[Deleted User]> #109
This is a no brainer!
Ideally with an option to update with just the value from source, or with both value and format from source.
da...@gmail.com <da...@gmail.com> #110
[Deleted User] <[Deleted User]> #111
as...@gmail.com <as...@gmail.com> #112
hy...@gmail.com <hy...@gmail.com> #113
sy...@gmail.com <sy...@gmail.com> #114
Please do add this functionality.
sp...@gmail.com <sp...@gmail.com> #115
am...@photosynth.ca <am...@photosynth.ca> #116
ol...@gmail.com <ol...@gmail.com> #117
To automate a customer facing tool.
ma...@gmail.com <ma...@gmail.com> #118
bc...@gmail.com <bc...@gmail.com> #119
jo...@gmail.com <jo...@gmail.com> #120
ms...@hodgequalityteam.com <ms...@hodgequalityteam.com> #121
Cu...@tab.co.nz <Cu...@tab.co.nz> #122
wj...@gmail.com <wj...@gmail.com> #123
rs...@gmail.com <rs...@gmail.com> #124
ke...@revevol.eu <ke...@revevol.eu> #125
[Deleted User] <[Deleted User]> #126
da...@hotwiremedia.co.uk <da...@hotwiremedia.co.uk> #127
da...@hotwiremedia.co.uk <da...@hotwiremedia.co.uk> #128
[Deleted User] <[Deleted User]> #129
[Deleted User] <[Deleted User]> #130
al...@booking.com <al...@booking.com> #131
ta...@omio.com <ta...@omio.com> #132
bm...@plrb.org <bm...@plrb.org> #133
em...@gmail.com <em...@gmail.com> #134
[Deleted User] <[Deleted User]> #135
an...@harristime.ca <an...@harristime.ca> #136
al...@gmail.com <al...@gmail.com> #137
[Deleted User] <[Deleted User]> #138
So let's see if 138 are enough. This feature will be helpful for many use cases.
ma...@laposte.net <ma...@laposte.net> #139
da...@avast.com <da...@avast.com> #140
bo...@gmail.com <bo...@gmail.com> #141
em...@redhat.com <em...@redhat.com> #142
ma...@gmail.com <ma...@gmail.com> #143
mi...@gmail.com <mi...@gmail.com> #144
hv...@gmail.com <hv...@gmail.com> #145
ti...@mindmaze.ch <ti...@mindmaze.ch> #146
ja...@spinmortgage.com <ja...@spinmortgage.com> #147
bi...@gmail.com <bi...@gmail.com> #148
sl...@gmail.com <sl...@gmail.com> #149
et...@eganco.com <et...@eganco.com> #150
[Deleted User] <[Deleted User]> #151
[Deleted User] <[Deleted User]> #152
Guys I have a workaround...it starts with installing Microsoft Office...
[Deleted User] <[Deleted User]> #153
na...@rutgersprep.org <na...@rutgersprep.org> #154
mi...@gmail.com <mi...@gmail.com> #155
jo...@gwc.org.uk <jo...@gwc.org.uk> #156
fr...@gmail.com <fr...@gmail.com> #157
da...@tcg.com <da...@tcg.com> #158
g9...@go.thu.edu.tw <g9...@go.thu.edu.tw> #159
ar...@abchospital.com <ar...@abchospital.com> #160
bc...@gmail.com <bc...@gmail.com> #161
[Deleted User] <[Deleted User]> #162
da...@gmail.com <da...@gmail.com> #163
Any one else NOT seeing the "Linked objects" option under "Tools" on Google Slides as i'm not seeing it?
al...@booking.com <al...@booking.com> #164
ma...@gmail.com <ma...@gmail.com> #165
g9...@go.thu.edu.tw <g9...@go.thu.edu.tw> #166
[Deleted User] <[Deleted User]> #167
>
> Any one else NOT seeing the "Linked objects" option under "Tools" on Google Slides as i'm not seeing it?
I just used this for the first time and its destroyed my presentation. All I have are black warning triangles where the charts used to be. This is going to take hours to fix *sigh*
T+30mins: A fix - I deleted all the data in the linked worksheets, updated all the linked objects again to make them blank. Then I undid the delete in the worksheet and updated linked objects again.
Note: There is no option to manually update without changing the source table/chart and rolling back to previous versions doesn't help.
T+110mins: Still trying to refresh all my data. You know what would be really handy right now? A script which could automatically refresh all the tables in my presentation.
ro...@gmail.com <ro...@gmail.com> #168
a nightmare...
sh...@gmail.com <sh...@gmail.com> #169
Now I have:
function onOpen() {
var ui = SlidesApp.getUi();
ui.createMenu('Custom Menu')
.addItem('Batch Update Charts', 'batchUpdate')
.addToUi();
}
function batchUpdate(){
var gotSlides = SlidesApp.getActivePresentation().getSlides();
for (var i = 0; i < gotSlides.length; i++) {
var slide = gotSlides[i];
var sheetsCharts = slide.getSheetsCharts();
for (var k = 0; k < sheetsCharts.length; k++) {
var shChart = sheetsCharts[k];
shChart.refresh();
}
}
}
pa...@bbva.com <pa...@bbva.com> #170
I don´t think the issue is solved, i think the idea is to trigger it, not to press a buttom every time we want it.
Regards
je...@arkea-am.com <je...@arkea-am.com> #171
I also need it urgently !
Pressing the button "Update all" is an improvment but :
- as my Slide is embedded in a webpage,
- as the Sheet page changes every 20 minutes (Stock markets),
an automatic update is absolutely necessary.
Thank you in advance Team Google !
[Deleted User] <[Deleted User]> #172
[Deleted User] <[Deleted User]> #173
ma...@gmail.com <ma...@gmail.com> #174
[Deleted User] <[Deleted User]> #175
mc...@ww.catholic.edu.au <mc...@ww.catholic.edu.au> #176
jr...@ohiohipoint.com <jr...@ohiohipoint.com> #177
[Deleted User] <[Deleted User]> #178
r....@lineopi.ch <r....@lineopi.ch> #179
ph...@gmail.com <ph...@gmail.com> #180
ad...@gmail.com <ad...@gmail.com> #181
ja...@gmail.com <ja...@gmail.com> #182
ah...@koeppeldirect.com <ah...@koeppeldirect.com> #183
cr...@qualityclouds.com <cr...@qualityclouds.com> #184
[Deleted User] <[Deleted User]> #185
There is just one thing I need
I don't care about Linked Objects
That button is no use to me.
You should update on your own
Microsoft does this you know
Make my wish come true oh
All I want for Christmas is code
Seriously, every month this causes a huge time sink for me. Presentations over 30 slides just don't work, they are too unstable to be worked on simultaneously and can't ever be trusted to update fully. This platform is not fit for purpose and I wouldn't be surprised if we pull the plug on the migration before it completes.
je...@jennifersrussell.com <je...@jennifersrussell.com> #186
We are using the google sheet to calculate their unique results from this assessment into tables, pie charts, and bar charts and then outputting that data and some other static and dynamic text to Google slides to generate a unique Results Report pdf using Google Slides and the UPDATE command. Problem is the charts are updating but NONE of the linked tables are updating when you go to create the pdf which is what we need to send to each person.
We are having to convert all linked tables into a score card chart one cell at a time to get it to update correctly but this is creating a lot of issues with the formatting and is a very tedious work around as you are taking a whole table fulll of data and having to create an individual scorecard chart for every single cell...just because the linked tables in google slides aren't updating like everything else when you create the pdf.
We notice this issue is YEARS old and has been assigned but is still not fixed. What can we do? How is it that it's this old and nothing has happened?
li...@gmail.com <li...@gmail.com> #187
sc...@gmail.com <sc...@gmail.com> #188
ma...@solvay.com <ma...@solvay.com> #189
ol...@gmail.com <ol...@gmail.com> #190
mi...@stellantis.com <mi...@stellantis.com> #191
[Deleted User] <[Deleted User]> #192
No, but its no wonder why the company is still using MS Office for everything else apart from my one deck. We were supposed to have moved over by now but no one is able to.
[Deleted User] <[Deleted User]> #193
ti...@gmail.com <ti...@gmail.com> #194
A lot of time has passed, but no changes have occurred. Very sad.
[Deleted User] <[Deleted User]> #195
ma...@decarb.co <ma...@decarb.co> #196
pt...@alphagraphics.com <pt...@alphagraphics.com> #197
bh...@gmail.com <bh...@gmail.com> #198
ki...@airbus.com <ki...@airbus.com> #199
but loosing faith...
ra...@my.tccd.edu <ra...@my.tccd.edu> #200
+1
jo...@caremin.com <jo...@caremin.com> #201
** NOTE: The chart table function which does let you automatically update is very ugly and impossible to format in PowerPoints. The chart-table function should allow you to update it as if it was a normal table (e.g., resizing, formatting, size, etc.)
gr...@gmail.com <gr...@gmail.com> #202
[Deleted User] <[Deleted User]> #203
[Deleted User] <[Deleted User]> #204
ta...@gmail.com <ta...@gmail.com> #205
[Deleted User] <[Deleted User]> #206
is...@gmail.com <is...@gmail.com> #207
[Deleted User] <[Deleted User]> #208
[Deleted User] <[Deleted User]> #209
ad...@gmail.com <ad...@gmail.com> #210
eb...@gmail.com <eb...@gmail.com> #211
co...@googlemail.com <co...@googlemail.com> #212
lu...@gmail.com <lu...@gmail.com> #213
The fact that this is such a simple fix and has been requested over 3 years ago and has not yet been addressed is pure blasphemy.
There is the ability to update charts and tables manually, and update charts automatically, but not tables automatically? Which Google gods decided charts deserved this special privilege over tables? What do you have against tables google?... not to mention the 200 people in this thread asking nicely to solve this issue for over 3 years now.
Could you at least give us the ability to edit Chart tables so that they can match the format of actual tables?
The best I can do right now is to create a table in Google Sheets, create a scorecard chart for EVERY cell and manually arrange all the individual scorecard charts into a table looking structure on my Google Slide, which is a complete nightmare.
Please Google programmers, find the compassion in your heart to end my suffering and just change the "getSheetCharts" function to simply "getSheetsObjects" which includes all charts, tables, and anything else from linked from sheets, and allow the "refresh" function to update all of these objects the same way that it currently updates charts.
Thank you :)
ga...@stellantis.com <ga...@stellantis.com> #214
I have several presentations that are linked to sheets which are used as project tracking documents. The slides are the exec review and I have to go through and manually update them every single day, including on holidays and weekends.
Not sure why we haven't seen a resolution for this yet.
ku...@gmail.com <ku...@gmail.com> #215
nobody@google.com <nobody@google.com> #216
aa...@gmail.com <aa...@gmail.com> #217
Just fell down this rabbit hole and discovered this fairly simple API request has been sitting here for years despite dozens of requests. Please implement this! It's crazy that there's no way to automatically update a linked table programatically.
aa...@gmail.com <aa...@gmail.com> #218
ik...@liveperson.com <ik...@liveperson.com> #219
[Deleted User] <[Deleted User]> #220
pa...@laskowski.in <pa...@laskowski.in> #221
[Deleted User] <[Deleted User]> #222
[Deleted User] <[Deleted User]> #223
de...@brooklynrobotfoundry.com <de...@brooklynrobotfoundry.com> #224
pp...@gmail.com <pp...@gmail.com> #225
[Deleted User] <[Deleted User]> #226
jo...@europeanappliances.com <jo...@europeanappliances.com> #227
[Deleted User] <[Deleted User]> #228
Happy Birthday to you
Happy 4th Birthday dear 'Way to update a linked Google Sheets table within a Slide from the API' issue
Happy Birthday to you
And not a moment too soon, our whole company is moving back to Microsoft :-)
el...@gmail.com <el...@gmail.com> #229
[Deleted User] <[Deleted User]> #230
ky...@gmail.com <ky...@gmail.com> #231
vd...@woolworths.com.au <vd...@woolworths.com.au> #232
ah...@woolworths.com.au <ah...@woolworths.com.au> #233
ex...@triplelift.com <ex...@triplelift.com> #234
fl...@gmail.com <fl...@gmail.com> #235
sa...@gmail.com <sa...@gmail.com> #236
[Deleted User] <[Deleted User]> #237
[Deleted User] <[Deleted User]> #238
ja...@harvamarketing.fi <ja...@harvamarketing.fi> #239
iv...@auchan.ru <iv...@auchan.ru> #240
Just do it!
r....@lineopi.ch <r....@lineopi.ch> #241
d....@e-daf.io <d....@e-daf.io> #242
ma...@justeattakeaway.com <ma...@justeattakeaway.com> #243
[Deleted User] <[Deleted User]> #244
jd...@gmail.com <jd...@gmail.com> #245
[Deleted User] <[Deleted User]> #246
ph...@gmail.com <ph...@gmail.com> #247
[Deleted User] <[Deleted User]> #248
[Deleted User] <[Deleted User]> #249
jo...@gmail.com <jo...@gmail.com> #251
le...@gmail.com <le...@gmail.com> #252
[Deleted User] <[Deleted User]> #253
rp...@gmail.com <rp...@gmail.com> #254
it...@ajegroup.com <it...@ajegroup.com> #255
Please add the functionality.
ll...@woolworths.com.au <ll...@woolworths.com.au> #256
Please add the functionality.
ed...@idd.edu.br <ed...@idd.edu.br> #257
Dear Google Team,
Please add the functionality.
in...@virginiaschool.ae <in...@virginiaschool.ae> #258
th...@gmail.com <th...@gmail.com> #259
an...@roche.com <an...@roche.com> #260
cm...@woolworths.com.au <cm...@woolworths.com.au> #261
Please add this functionality.
fe...@gmail.com <fe...@gmail.com> #262
jo...@hwdevelopment.eu <jo...@hwdevelopment.eu> #263
em...@airbus.com <em...@airbus.com> #264
Can this feature be added ?
jm...@anubesolutions.com <jm...@anubesolutions.com> #265
ti...@zonk.com.au <ti...@zonk.com.au> #266
ka...@gmail.com <ka...@gmail.com> #267
da...@gmail.com <da...@gmail.com> #268
el...@gmail.com <el...@gmail.com> #269
nu...@plurisvalue.com <nu...@plurisvalue.com> #270
ka...@gmail.com <ka...@gmail.com> #271
ig...@gmail.com <ig...@gmail.com> #272
an...@gmail.com <an...@gmail.com> #273
lu...@gmail.com <lu...@gmail.com> #274
to...@gmail.com <to...@gmail.com> #275
aw...@gmail.com <aw...@gmail.com> #276
ve...@gmail.com <ve...@gmail.com> #277
la...@eliram.net <la...@eliram.net> #278
je...@salesforce.com <je...@salesforce.com> #279
update or CREATE "linked google sheets table" within slides api is a huge miss
wm...@gmail.com <wm...@gmail.com> #280
th...@gmail.com <th...@gmail.com> #281
er...@cms.k12.nc.us <er...@cms.k12.nc.us> #282
ni...@gmail.com <ni...@gmail.com> #283
te...@responsiveedtx.com <te...@responsiveedtx.com> #284
dg...@casasporcristo.org <dg...@casasporcristo.org> #285
ph...@gmail.com <ph...@gmail.com> #286
cr...@marleyspoon.com <cr...@marleyspoon.com> #287
ma...@airbus.com <ma...@airbus.com> #288
jo...@all-in.global <jo...@all-in.global> #289
cs...@pcsforpeople.com <cs...@pcsforpeople.com> #290
hc...@gmail.com <hc...@gmail.com> #291
ke...@torchstar.us <ke...@torchstar.us> #292
jm...@gmail.com <jm...@gmail.com> #293
to...@adverity.com <to...@adverity.com> #294
th...@gmail.com <th...@gmail.com> #295
op...@oxygenatwork.com <op...@oxygenatwork.com> #296
jo...@ekzact.ws <jo...@ekzact.ws> #297
ag...@gmail.com <ag...@gmail.com> #298
sd...@ting.com <sd...@ting.com> #299
jr...@coding-cowboys.com <jr...@coding-cowboys.com> #300
tc...@tienshanschool.org <tc...@tienshanschool.org> #301
now at least over 300 people found this since 2017 and still waiting.
How many more people does it need to increase Priority?
I have tried the following:
- copy the code for "batchUpdate" from
- deploy code
- goto triggers
- set a timer based trigger to run function "batchUpdate"
el...@gmail.com <el...@gmail.com> #302
[Deleted User] <[Deleted User]> #303
jo...@gmail.com <jo...@gmail.com> #304
ju...@gmail.com <ju...@gmail.com> #305
pl...@gmail.com <pl...@gmail.com> #306
iv...@zizooboats.at <iv...@zizooboats.at> #307
dy...@gmail.com <dy...@gmail.com> #308
nb...@swdubois.k12.in.us <nb...@swdubois.k12.in.us> #309
li...@ledger.fr <li...@ledger.fr> #310
sh...@fraclabs.org <sh...@fraclabs.org> #311
jo...@veeva.com <jo...@veeva.com> #312
lo...@easy-cube.de <lo...@easy-cube.de> #313
tx...@crumbl.com <tx...@crumbl.com> #314
cm...@woolworths.com.au <cm...@woolworths.com.au> #315
sa...@airbus.com <sa...@airbus.com> #316
ro...@kperfection.com <ro...@kperfection.com> #317
dk...@gmail.com <dk...@gmail.com> #318
ja...@gmail.com <ja...@gmail.com> #319
[Deleted User] <[Deleted User]> #320
[Deleted User] <[Deleted User]> #321
im...@gmail.com <im...@gmail.com> #322
va...@consumer.org <va...@consumer.org> #323
an...@gmail.com <an...@gmail.com> #324
jm...@cps.edu <jm...@cps.edu> #325
wm...@gmail.com <wm...@gmail.com> #326
[Deleted User] <[Deleted User]> #327
an...@gsuite.sbs-software.com <an...@gsuite.sbs-software.com> #328
hi...@gmail.com <hi...@gmail.com> #329
[Deleted User] <[Deleted User]> #330
e.g. a slide presentation during an auction shows a number value ($500). When the number changes the slide gets updated via a google sheet or via a different API.
[Deleted User] <[Deleted User]> #331
ni...@contisports.co.uk <ni...@contisports.co.uk> #332
Those tables are then incorporated into slides in a rolling presentation on our office wall. Someone has to remember to go into the Slides presentation and click to update the links. All we would like to do is to update those links programmatically - ideally whenever there is an update available, but if not then at fixed time intervals.
na...@gmail.com <na...@gmail.com> #333
ss...@azgfd.gov <ss...@azgfd.gov> #334
ds...@gmail.com <ds...@gmail.com> #335
be...@pigment.com <be...@pigment.com> #336
[Deleted User] <[Deleted User]> #337
ab...@gmail.com <ab...@gmail.com> #338
fi...@gmail.com <fi...@gmail.com> #339
cs...@capsher.com <cs...@capsher.com> #340
jo...@gmail.com <jo...@gmail.com> #341
fi...@gmail.com <fi...@gmail.com> #342
jo...@gmail.com <jo...@gmail.com> #343
Please add us to the list of requested user.
[Deleted User] <[Deleted User]> #344
[Deleted User] <[Deleted User]> #345
el...@gmail.com <el...@gmail.com> #346
cl...@gmail.com <cl...@gmail.com> #347
mi...@camunda.com <mi...@camunda.com> #348
la...@barcscandinavia.com <la...@barcscandinavia.com> #349
co...@gmail.com <co...@gmail.com> #350
mi...@rtbhouse.com <mi...@rtbhouse.com> #351
ti...@gmail.com <ti...@gmail.com> #352
Does it matter if I +1000
instead of just +1
? It's so disheartening to see what seems like a low-lift feature sit unimplemented for SIX YEARS. I am very curious how many requests over what period of time would get this moved from a P2 to a P1. I love so many of the features of Google Slides and Sheets, it's a shame that this simple concept isn't among them. Please help make the Slides/Sheets integration more useful by extending auto-update via API from charts to tables!
pi...@gmail.com <pi...@gmail.com> #353
wi...@verizon.com <wi...@verizon.com> #354
io...@gmail.com <io...@gmail.com> #355
I understand your enthusiasm for the requested feature. You currently utilize Google Slides as a communication board, with spreadsheets serving as the foundational data for multiple slides. It would be incredibly beneficial if there was an automatic mechanism that refreshed the tables on your slides whenever changes were made to the underlying spreadsheet data. This functionality would provide the advantage of granting specific users access to the spreadsheet without needing to share the entire presentation. By eliminating the need for manual table updates, it would enhance your workflow efficiency and facilitate seamless collaboration.
os...@gmail.com <os...@gmail.com> #356
[Deleted User] <[Deleted User]> #357
ws...@gmail.com <ws...@gmail.com> #358
function refreshLink() {
// Get the Google Slides presentation
var presentation = SlidesApp.openById("1dM7UaQcNbTUKQ4ykGfKCEjYZjSK6xu9jlTAG3y1A0hY");
// Get the Google Sheet that is linked to the presentation
var sheet = SpreadsheetApp.openById("1KICpQEHrEQjaihwITz7AHNCC5Z7CaQqICf4wLGXK840");
// Get the slide that contains the linked object
var slide = presentation.getSlides()[0];
// Get the linked object
var linkedObject = slide.getLinkedObjects()[0];
// Refresh the link to the Google Sheet
linkedObject.refreshAll();
}
Please help by providing a timely solution.
Thank you for your consideration and timely response.
el...@gmail.com <el...@gmail.com> #359
ha...@woolworths.co.nz <ha...@woolworths.co.nz> #360
ss...@azgfd.gov <ss...@azgfd.gov> #361
te...@evvonow.com <te...@evvonow.com> #362
[Deleted User] <[Deleted User]> #363
Please, please, please...
[Deleted User] <[Deleted User]> #364
This one is badly needed!
it...@kagotoku.jp <it...@kagotoku.jp> #365
me...@gmail.com <me...@gmail.com> #366
mu...@gmail.com <mu...@gmail.com> #367
du...@gmail.com <du...@gmail.com> #368
tu...@gmail.com <tu...@gmail.com> #369
Google, this is a major thing for businesses, and businesses are what give you revenue (I would do this from one of my two Gmail-based business accounts if I wanted them public).
ti...@hackerone.com <ti...@hackerone.com> #370
ke...@gmail.com <ke...@gmail.com> #371
dp...@gmail.com <dp...@gmail.com> #372
jo...@onepeloton.com <jo...@onepeloton.com> #373
mb...@gmail.com <mb...@gmail.com> #374
ca...@gmail.com <ca...@gmail.com> #375
ma...@gmail.com <ma...@gmail.com> #376
lu...@gmail.com <lu...@gmail.com> #377
nooooo google..... why????
please do it
cp...@parameta.co <cp...@parameta.co> #378
to...@leiepoort.be <to...@leiepoort.be> #379
po...@gmail.com <po...@gmail.com> #380
js...@woolworths.com.au <js...@woolworths.com.au> #381
This is very standard workflow in the Microsoft Suite world... create a template in Excel and in PowerPoint whereby data from the spreadsheet automatically updates data in the slide charts and tables.
I'd even live with the fact that you can't copy and paste link a single cell from Sheets to Slides (and have to do an odd workaround of pasting two cells and then changing the range).
This a major productivity limitation.
ma...@qunomedical.com <ma...@qunomedical.com> #382
gb...@googlemail.com <gb...@googlemail.com> #383
em...@pearlxinfra.com <em...@pearlxinfra.com> #384
tb...@alliedrestoration.com <tb...@alliedrestoration.com> #385
ka...@googlemail.com <ka...@googlemail.com> #386
st...@sia.tech <st...@sia.tech> #387
Please add this functionality.
[Deleted User] <[Deleted User]> #388
mi...@possehl-online.com <mi...@possehl-online.com> #389
We would really need that feature for our Sales Team
ra...@gmail.com <ra...@gmail.com> #390
ca...@gmail.com <ca...@gmail.com> #391
do...@gmail.com <do...@gmail.com> #392
ja...@gmail.com <ja...@gmail.com> #393
ba...@guru.smk.belajar.id <ba...@guru.smk.belajar.id> #394
to...@justeattakeaway.com <to...@justeattakeaway.com> #395
+1.000.000
ka...@googlemail.com <ka...@googlemail.com> #396
he...@teads.com <he...@teads.com> #397
ti...@gmail.com <ti...@gmail.com> #398
Please implement this feature! It is the only thing missing from my project being fully self-sufficient.
su...@wesang.com <su...@wesang.com> #399
gb...@gmail.com <gb...@gmail.com> #400
ja...@gmail.com <ja...@gmail.com> #401
ke...@gmail.com <ke...@gmail.com> #402
ha...@kamps.org <ha...@kamps.org> #403
ke...@vo-ov.com <ke...@vo-ov.com> #404
ma...@gmail.com <ma...@gmail.com> #405
sh...@gmail.com <sh...@gmail.com> #406
ca...@gmail.com <ca...@gmail.com> #407
sh...@datapelago.com <sh...@datapelago.com> #408
re...@cabify.com <re...@cabify.com> #409
br...@gmail.com <br...@gmail.com> #410
ta...@four-africa.co.za <ta...@four-africa.co.za> #411
gc...@bintertechnic.com <gc...@bintertechnic.com> #412
si...@zoi.tech <si...@zoi.tech> #413
th...@gmail.com <th...@gmail.com> #414
ca...@gmail.com <ca...@gmail.com> #415
tr...@gmail.com <tr...@gmail.com> #416
go...@motorolasolutions.com <go...@motorolasolutions.com> #417
go...@pressureprofile.com <go...@pressureprofile.com> #418
[Deleted User] <[Deleted User]> #419
be...@sthelenssc294.co.uk <be...@sthelenssc294.co.uk> #420
jo...@obilityb2b.com <jo...@obilityb2b.com> #421
jv...@squarespace.com <jv...@squarespace.com> #422
re...@gmail.com <re...@gmail.com> #423
This prevents me from completing automation on report generation.
tr...@visma.com <tr...@visma.com> #424
m....@gwr-projekt.de <m....@gwr-projekt.de> #425
no...@joinmosaic.com <no...@joinmosaic.com> #426
ja...@verizonconnect.com <ja...@verizonconnect.com> #427
se...@progreen-solar.com <se...@progreen-solar.com> #428
556 people +1 here is probably a factor of a thousand that have attempted but didn't bother requesting the update. (I mean, it has been 6 years with zero movement)
[Deleted User] <[Deleted User]> #429
ya...@gmail.com <ya...@gmail.com> #430
he...@jiridiblik.com <he...@jiridiblik.com> #431
ti...@cross-join.com <ti...@cross-join.com> #432
ja...@datadise.com <ja...@datadise.com> #433
ni...@gmail.com <ni...@gmail.com> #434
ra...@gmail.com <ra...@gmail.com> #435
ca...@gmail.com <ca...@gmail.com> #436
[Deleted User] <[Deleted User]> #437
ja...@gmail.com <ja...@gmail.com> #438
sa...@biograph.com <sa...@biograph.com> #439
th...@ironmountain.co.uk <th...@ironmountain.co.uk> #440
wi...@palmetto.com <wi...@palmetto.com> #441
ch...@socialive.us <ch...@socialive.us> #442
jb...@opustwoics.com <jb...@opustwoics.com> #443
ph...@perfect-home-solutions.com <ph...@perfect-home-solutions.com> #444
ja...@autorfp.ai <ja...@autorfp.ai> #445
ed...@vtdt.edu.lv <ed...@vtdt.edu.lv> #446
am...@gmail.com <am...@gmail.com> #447
it...@gmail.com <it...@gmail.com> #448
da...@estetiskaskolan.se <da...@estetiskaskolan.se> #449
la...@veolia.com <la...@veolia.com> #450
ca...@gmail.com <ca...@gmail.com> #451
li...@gmail.com <li...@gmail.com> #452
ir...@akeneo.com <ir...@akeneo.com> #453
rk...@redhat.com <rk...@redhat.com> #454
df...@rockinfo.com <df...@rockinfo.com> #455
le...@gmail.com <le...@gmail.com> #456
ei...@gmail.com <ei...@gmail.com> #457
ma...@lablab.cl <ma...@lablab.cl> #458
vi...@ecovelo.com <vi...@ecovelo.com> #459
ma...@marble.aero <ma...@marble.aero> #460
ni...@creditkarma.com <ni...@creditkarma.com> #461
mi...@airasia.com <mi...@airasia.com> #462
aj...@ipsos.com <aj...@ipsos.com> #463
ms...@ised.es <ms...@ised.es> #464
ev...@1stdibs.com <ev...@1stdibs.com> #465
lc...@aisd.net <lc...@aisd.net> #466
am...@gmail.com <am...@gmail.com> #467
al...@gmail.com <al...@gmail.com> #468
ma...@wbschools.us <ma...@wbschools.us> #469
ak...@acefour.in <ak...@acefour.in> #470
bl...@axial1.com <bl...@axial1.com> #471
f....@ryte.com <f....@ryte.com> #472
je...@qoria.com <je...@qoria.com> #473
wi...@verizon.com <wi...@verizon.com> #474
ma...@bs-energy.de <ma...@bs-energy.de> #475
up...@gmail.com <up...@gmail.com> #476
ig...@milfordhavenschool.co.uk <ig...@milfordhavenschool.co.uk> #477
cg...@lauryheating.com <cg...@lauryheating.com> #478
bk...@gogipper.com <bk...@gogipper.com> #479
Ma...@kubra.com <Ma...@kubra.com> #480
Ma...@kubra.com <Ma...@kubra.com> #481
de...@solvay.com <de...@solvay.com> #482
sh...@gmail.com <sh...@gmail.com> #483
Really required....
ad...@fmhtcc.org <ad...@fmhtcc.org> #484
le...@gmail.com <le...@gmail.com> #485
to...@dexters.co.uk <to...@dexters.co.uk> #486
And linked sheets do not transfer with accurate data - row heights and text fitting do not match. This is hugely frustrating as you have to amend the sheet in slides, which when you refresh sends it back to the incorrect format.
Why is this such a poor function?
jp...@hopkinton.k12.ma.us <jp...@hopkinton.k12.ma.us> #487
When I try to access either of these 'blocking' issues, I get 'Access Denied'.
If anyone has access to these, it might be good to escalate/advocate for their fix..
Description
Just as there is a request for updating a linked chart within a slide (RefreshSheetsChartRequest) I would really love one to update a linked Table in the same way
What is the purpose of this new feature?
I have a slide with a number of tables rendered for display, but I have to manually update them when the underlying data changes.
What existing APIs would this affect?
None
What existing data does this use?
None
Please provide any additional information below.