Loading Profile...
Twitter,
Facebook, or email.
I am trying to create a custom layout for the spreadsheet gadget and link to it.
When I check the use layout url the gadget does not show up in preview.
Ive also tried using the the layout that is in the gadget settings by default and get the same results which is why I think this feature is broken.
http://rvauser.appspot.com/#PRESENTAT...
I’m
undecided
Layout Field broken in Spreadsheet Gadget when using DDE
-
Matt,
Can you email support@risevision.com with the Spreadsheet you are using so we can look into this further?
ThanksComment -
-
Hey Mat,
Is the DDE server running? Is the Excel spreadsheet open that the DDE data source references? I think both these conditions need to be true in order for a DDE data source to work.
Thx. -
-
Yes to both.
The gadget is working fine. Only when i check use custom layout url does it stop working. Even when i dont change the url and leave the default one it does not work. -
-
That default layout is not meant to be used as is. You have to alter it to work with your particular spreadsheet. What I really need is the URL of the custom layout you have created.
Thx. -
-
Here is my layout. I didnt change anything in here besides the link to the css
https://s3.amazonaws.com/riseclientco... -
-
All i wont to do is align all the numbers right instead of left. So I was expecting to be able to download the default css change the alignment attribute from left to right and be done with it. Its sounding like that is not the case.
-
-
When you specify a custom layout you'll also need to customize the columns and their headings so they correspond to the columns in your spreadsheet. This blog post has instructions on how to do that.
Thx.-
Thanks donna i will look a this
-
-
-
-
-
Mat,
Any update on this? Did it solve your issue? -
-
I guess im still confused here.
Where would I find the default xml layout for this spreadsheet gadget.
The one that is listed in the gadget settings is: http://c560290.r90.cf2.rackcdn.com/Ta...
Can you confirm this is what i should be starting from? It looks like xml for the directory gadget. -
-
Yes, that is the correct file to use. That layout file has an example for each type of data you can have in the columns - text (the default), image or QR Code.
-
-
The post you provided tells me how to make a custom layout. All i really want to do at this point is take the default layout the spreadsheet gadget uses and hosted it on my site and verify that works. I will deal with the customization part later.
What do i need to do to make that happen? -
-
Mat,
You have to customize that file. You can't skip this step. Well, you could, but then you would have to create a spreadsheet where the first column is text, second column is a link to an image, third column is text, and fourth column is data that you want to show in a QR code, because this is what that sample layout file expects. You have to do one or the other. Without it, the Gadget will not work.
Thx. -
-
Also, you said that you want to take the default layout that the Gadget uses and use that. If the Layout URL box is not checked, the Gadget does not use a layout file at all. It builds the layout based on the number of columns in the spreadsheet. This data can only be text. To display other types of data (i.e. image or QR code) or change the CSS styling, that's when a custom layout would be used.
-
-
Thanks donna that helped.
I took dde out of the equation and everything works fine.
So i think that is where my confusion is.
In this sample presentation I have two instances of the google spreadsheet gadget. One pulling from a google spreadsheet and one using dde. Both are using the same layout.
The google spreadsheet one shows up fine but the dde one does not. Just like my original post if I uncheck the use custom layout the data does show up so its not an issue with the dde service or an un opened spreadsheet.
Is the gadget putting something in the layout on the fly that i need to add to my custom layout to make dde work?
sample presentation:
http://rvauser.appspot.com/#PRESENTAT...
layout:
https://s3.amazonaws.com/riseclientco... -
-
Hey Mat,
I can't actually get the Google Spreadsheet Gadget to show up at all, probably because the spreadsheet is not public.
Are you using the exact same data and number of columns in both the Google Spreadsheet and the DDE spreadsheet? If so, can you make a copy of it and share it with me so I can try it out?
Thx. -
-
Your right sorry that spreadsheet wasn't public should be now.
They both have 8 columns and are pretty much identical except for the names of the stocks.
google spreasheet: https://docs.google.com/a/risedisplay...
dde: The gadget using dde pulls from the second tab of the spreadsheet i just sent. -
-
Thanks for the links.
OK, for some reason the DDE data source does not return columns as a, b, c etc. It returns them as c1, c2, c3. That means that the layout file for the DDE data source would have to look like this:
<td class="c1"></td>
<td class="c2"></td>
<td class="c3"></td>
<td class="c4"></td>
<td class="c5"></td>
<td class="c6"></td>
<td class="c7"></td>
<td class="c8"></td>
You should get data back by changing those lines. -
-
Better yet, the following should also work and would not require you to have to have two layout files, one for DDE and one for Google spreadsheet:
<td class="a c1"></td>
<td class="b c2"></td>
<td class="c c3"></td>
<td class="d c4"></td>
<td class="e c5"></td>
<td class="f c6"></td>
<td class="g c7"></td>
<td class="h c8"></td> -
-
The above Solved my issue Donna. Thanks for all your help!
-
EMPLOYEE
EMPLOYEE
EMPLOYEE
