Google Sheets and language selection

Special forum to share and discuss skins for Pano2VR and Object2VR
xi4
Posts: 41
Joined: Mon Feb 04, 2019 10:00 am
Location: Украина
Contact:

1. I have seen virtual tours in Pano2VR, the information in which can be edited using Google Sheets.
2. I have also seen multilingual virtual tours (English, French, Spanish, etc. ..).

Is there somewhere an instruction on how to implement this?
Marco360
Posts: 23
Joined: Wed Feb 19, 2020 1:02 pm

unfortunately: no.

I startet working on that but my skills are limited an the demand is "just for fun" as I do not have a customer requesting.

there is someone in the Facebook group who write an own js (javascript). On load he gets data from spreadsheets (as JSON) and uses IDs to change the info-hotspot information (not the language, but the content).
there are some hints in the code (Russian) but with basic skills you might understand.

this is the tour (from browser-history) as I just didn't find the original author.
https://k360.ru/panoramas/florentina/
User avatar
Tony
Posts: 1341
Joined: Mon Feb 15, 2010 6:54 am
Location: Adelaide, South Australia
Contact:

Hi,

The name on the license is Maksim Bobylev he's active in the Facebook User Group.

Tony
Tony Redhead | Panoramic Photographer | mobile: +61438501002 | website: https://tonyredhead.com - https://redsquare.com | Pano2VR Tutorials: https://tonyredhead.com/pano2vr | instagram: https://www.instagram.com/tonyredhead/
Idocio
Posts: 52
Joined: Wed Apr 15, 2020 9:26 pm

@hopki It would be very interesting to do a webinar with these kinds of solutions.
User avatar
Hopki
Gnome
Posts: 13004
Joined: Thu Jan 10, 2008 3:16 pm
Location: Layer de la Haye, Essex UK
Contact:

Hi,
You have been able to do this sever since you can use an iframe in a text box, so a very long time.
Google Sheets allows you to "Publish to web". This is found under the File menu.
Select Embed
Then select your document, in this case, I have a sheet called 2021 and the document name is Price List.

This is what I typed up in Google Sheets.
Note under the View menu I removed the Guidelines so you do not see the indervidual cells

Screenshot 2021-06-03 at 15.25.55.png
Screenshot 2021-06-03 at 15.25.55.png (34.39 KiB) Viewed 15961 times

Then using the embed code in a text box this is what it looks like in the panorama.

Screenshot 2021-06-03 at 15.18.14.png
Screenshot 2021-06-03 at 15.18.14.png (78.5 KiB) Viewed 15961 times


I did slightly modify their code,
I added frameBoarder="0" at the start

So it looks like this <iframe frameBorder="0" src=

In their code you will see:
single=true
Set this to false.

Update the spreadsheet and the price update in the pano.
Regards,
Garden Gnome Support
If you send an e-mail to support please send a link to the forum post for reference.
support@ggnome.com
https://ggnome.com/wiki/documentation/
Idocio
Posts: 52
Joined: Wed Apr 15, 2020 9:26 pm

Thank you for the demo @hopki. Very useful.
How could you remove the line in front of the items? In your example it does not appear.
Captura de pantalla 2021-06-03 184557.jpg
Captura de pantalla 2021-06-03 184557.jpg (11.96 KiB) Viewed 15952 times
User avatar
Hopki
Gnome
Posts: 13004
Joined: Thu Jan 10, 2008 3:16 pm
Location: Layer de la Haye, Essex UK
Contact:

Hi,
Did you remove the Guidelines?
If so can you post your skin?
Regards,
Garden Gnome Support
If you send an e-mail to support please send a link to the forum post for reference.
support@ggnome.com
https://ggnome.com/wiki/documentation/
User avatar
Hopki
Gnome
Posts: 13004
Joined: Thu Jan 10, 2008 3:16 pm
Location: Layer de la Haye, Essex UK
Contact:

Hi,
Just had another play and I am not getting that line.
Also in the spreadsheet you can add direct links to the shopping cart :-)
Regards,
Attachments
Screenshot 2021-06-03 at 22.41.35.png
Screenshot 2021-06-03 at 22.41.35.png (21.39 KiB) Viewed 15939 times
Garden Gnome Support
If you send an e-mail to support please send a link to the forum post for reference.
support@ggnome.com
https://ggnome.com/wiki/documentation/
Idocio
Posts: 52
Joined: Wed Apr 15, 2020 9:26 pm

I have the grid lines hidden, as you indicate.
OK. I have already found the problem.
Only that line appears when viewing the page in Chrome. With Egde and Opera it is shown as in your example.

Do you know if there is any way that it only shows the information of selected cells? So that the title of the document and the sheet do not appear.

I have consulted the Google Sheet documentation. There is a range parameter, but if I use it then it doesn't show me the sheet content in the browser.

https://support.google.com/docs/answer/ ... insertadas
User avatar
Shytsko
Posts: 80
Joined: Sat Dec 31, 2011 10:56 am
Location: Minsk, Belarus
Contact:

HI.
This is to help.
https://support.google.com/docs/answer/ ... ic=2818998

Regards, Peter
Idocio
Posts: 52
Joined: Wed Apr 15, 2020 9:26 pm

Shytsko wrote: Sat Jun 05, 2021 11:43 am HI.
This is to help.
https://support.google.com/docs/answer/ ... ic=2818998

Regards, Peter
That is the documentation I have looked at.
wiso
Posts: 281
Joined: Wed Oct 26, 2016 6:52 pm

very useful,
thank you!

wiso
wiso
Posts: 281
Joined: Wed Oct 26, 2016 6:52 pm

hi ,
i tried differt possibilitys, but never came on a fulfilling result.

there are always some boarders or labeling in the iframe.

this is my best result:
K1600_Skizze (135).JPG
K1600_Skizze (135).JPG (34.11 KiB) Viewed 15198 times
with this code: (modified google code)

<iframe src=„https://docs.google.com/spreadsheets/d/ ... “></iframe>

someone hints?
regards,
wiso
paolodalprato
Posts: 9
Joined: Fri Nov 02, 2018 1:06 pm

wiso wrote: Thu Oct 07, 2021 10:25 am hi ,
i tried differt possibilitys, but never came on a fulfilling result.

there are always some boarders or labeling in the iframe.

this is my best result:

K1600_Skizze (135).JPG

with this code: (modified google code)

<iframe src=„https://docs.google.com/spreadsheets/d/ ... “></iframe>

someone hints?
regards,
wiso
My solution, use a container with masking option enabled, put the text box inside a bit bigger (as example 101% )
wiso
Posts: 281
Joined: Wed Oct 26, 2016 6:52 pm

masking container sounds great - i will try it!

thank you,
wiso
Post Reply