Garden Gnome Software

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?

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/

Hi,

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

Tony

@hopki It would be very interesting to do a webinar with these kinds of solutions.

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


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



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,

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.

Hi,
Did you remove the Guidelines?
If so can you post your skin?
Regards,

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,

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

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

Regards, Peter

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.

very useful,
thank you!

wiso

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:
with this code: (modified google code)

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

someone hints?
regards,
wiso

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% )

masking container sounds great - i will try it!

thank you,
wiso