Google Spreadsheet Gadget grid

  • 1
  • Question
  • Updated 4 years ago
  • Answered

I am using Google spreadsheet gadget and it works fine. But now I have a spreadsheet that I want to put in a presentation which requires a border and gridlines. I looked in https://s3.amazonaws.com/Gadget-Spreadsheet/layouts/Table/Table.xml to see if there is a setting to achieve this, but couldn't find it.

Any one an idea how to get this done

Photo of roda signage

roda signage

  • 214 Points 100 badge 2x thumb

Posted 4 years ago

  • 1
Photo of Neal

Neal

  • 61,252 Points 50k badge 2x thumb
The best method would likely be with a custom layout.

You can find additional information regarding custom layouts here.

If you have any further questions. Please let us know.

Thanks.
Photo of roda signage

roda signage

  • 214 Points 100 badge 2x thumb

Before even trying to make a change I first copied the layout from https://s3.amazonaws.com/Gadget-Spreadsheet/layouts/Table/Table.xml into googledrive and tried to run the spreadsheet presentation. Unforunately it didn't show.

So it could be that google drive isn't a proper place for the layout file.

Thus imported it into Risevision storage and changed the layout url to risevision lib.  Also this gives me an empty page.

What to do next to get it on screen.

(Edited)
Photo of Neal

Neal

  • 61,252 Points 50k badge 2x thumb
Google Drive is not the ideal place to store files for use with Rise Vision. Normally the links provided aren't directly to the files in question.

Can you confirm that you got the URL for the layout from Storage by temporarily adding it to a Video (or Image) Item? And to confirm, if you use the default layout, you do see the spreadsheet in the Presentation?

Thanks.
Photo of roda signage

roda signage

  • 214 Points 100 badge 2x thumb

Yes using the default layout i get the spreadsheet exactly as I set it up

Photo of roda signage

roda signage

  • 214 Points 100 badge 2x thumb

I did what you suggested and placed an image placeholder on that screen and added the link to https://googledrive.com/host/0B6TiTVvCQxXRWUNIdFlhSFg1aGM/table.xml but also the image is not shown on the screen.



Photo of Neal

Neal

  • 61,252 Points 50k badge 2x thumb
Sorry I wasn't clearer, I intended you did that with the file you uploaded to Rise Storage.

Also, this is just to get the link so you can use it in the Spreadsheet Gadget.  You don't need to keep the Image/Video Item in the Presentation once you have the URL to the layout.
Photo of roda signage

roda signage

  • 214 Points 100 badge 2x thumb
Also selecting the item out of storage in Rise vision to connect it to a image placeholder doesn't give me an image on the presentation.
Photo of Neal

Neal

  • 61,252 Points 50k badge 2x thumb
If you copy the URL from the Image Item, and paste that to the custom layout field in the Spreadsheet Gadget, does the spreadsheet then appear in the Presentation after you've saved and published it?

If the spreadsheet now shows in the Presentation, you can remove the Image Item.

Thanks.
Photo of roda signage

roda signage

  • 214 Points 100 badge 2x thumb
Nope a blank screen
Photo of Neal

Neal

  • 61,252 Points 50k badge 2x thumb
I believe I've found your layout, and it looks like there's a slight difference between yours and the source material.

Here's an image of both of them, with the one in Rise Storage at top.


I would suggest redoing the layout so that they are exactly the same to begin with before making changes.

Thanks.
Photo of roda signage

roda signage

  • 214 Points 100 badge 2x thumb

Well sure that is a big difference but i can't make it up how you get this my screen which i took from

https://commondatastorage.googleapis.com/risemedialibrary-165ebc3e-1db5-44da-98b3-f0c8dfe0b8e8/table...  is identical as the source I took from

https://s3.amazonaws.com/Gadget-Spreadsheet/layouts/Table/Table.xml

So a browser/editor issue here?


Photo of Neal

Neal

  • 61,252 Points 50k badge 2x thumb
It looks like your spreadsheet has more data than the sample table layout.  You'll need to modify it so that you add columns E through H for the headers and type of data.
Photo of roda signage

roda signage

  • 214 Points 100 badge 2x thumb
Thought first that the layout file that was made worked already but now know it is just a skeleton in which you have to make changes

Changed the lay-out file to this and now it works as I wanted

<?xml version="1.0" encoding="UTF-8"?><Template>
   <Style>
      <![CDATA[
          body {  background: transparent; user-select: none; -moz-user-select: none; -webkit-user-select: none; -khtml-user-select: none; }    
          table { width:100%; table-layout: fixed; border-collapse: collapse; border: 4px outset #FFB7B7;
                      border-color: #FFFFFF #FFFFFF #FFFFFF #FFFFFF; } 
          th, td { text-align: left; font-weight: normal; text-shadow: 1px 1px #A0A0A0; -webkit-box-sizing: border-box; -moz-box-sizing: border-box; box-sizing: border-box; border: 4px inset #FFB7B7;
                      border-color: #FFFFFF #FFFFFF #FFFFFF #FFFFFF; }
            /* Column widths are based on these cells */
           .row-ID           { width: 3%;  }
           .row-tijd         { width: 7%;  }
           .row-home         { width: 34%; } 
           .row-visitor      { width: 34%; }
           .row-scorehome    { width: 4%;  }     
           .row-scoredash    { width: 2%;  }
           .row-scorevisitor { width: 4%;  }
           .row-remarks      { width: 11%; }
            #scrollContainer { height: 100%; overflow: hidden; }
            
           /* Color Conditions: changeUpIncrease - Change Up Green Down Red - Styling for Change Up Green changeUpDecrease - Change Up Green Down Red - Styling for Change Down Red changeDownDecrease - Change Down Green Up Red -                                     Styling for Change Down Green changeDownIncrease - Change Down Green Up Red - Styling for Change Up Red valuePositivePositive - Value Positive Green Negative Red - Styling for Value Positive Green valuePositiveNegative - Value Positive Green Negative Red - Styling for Value Negative Red valueNegativeNegative - Value Negative Green Positive Red - Styling for Value Negative Green valueNegativePositive - Value Negative Green Positive Red - Styling for Value Positive Red */ 
           
           .changeUpIncrease, .changeDownDecrease, .valuePositivePositive, .valueNegativeNegative { color: rgb(0, 255, 0); } .changeUpDecrease, .changeDownIncrease, .valuePositiveNegative, .valueNegativePositive { color:green; }

            /* Change these to over-ride the Heading Font and Data Font. */
            
           .heading_font-style {font-family:Verdana, Verdana, Geneva, sans-serif;color:rgb(255, 255, 255);font-size:32px;font-weight:normal;}
           .data_font-style {font-family:Verdana, Verdana, Geneva, sans-serif;color:rgb(255, 255, 255);font-size:32px;font-weight:normal;}
      ]]>
   </Style>
   <Layout>
      <![CDATA[
         <div id="scrollContainer">  
           <table class="page" > 
               <thead>
                    <tr class="heading_font-style">
                    
                        <!-- The headings for Columns A-H. There must be one heading per column. --> 
                        
                        <th class= "row-ID">S</th>
                        <th class= "row-tijd">Tijd</th> 
                        <th class= "row-home">Thuis</th> 
                        <th class= "row-visitor">Uit</th>
                        <th class= "row-scorehome"></th>
                        <th class= "row-scoredash"></th>
                        <th class= "row-scorevisitor"></th>
                        <th class= "row-remarks">Status</th>
                    </tr>
               </thead> 
               <tbody>
                    <tr class="repeat item data_font-style"> 
                    
                        <!-- Shows data in Columns A-H. --> 
                        
                        <td class="A"></td>
                        <td class="B"></td>
                        <td class="C"></td>
                        <td class="D"></td>
                        <td class="E"></td>
                        <td class="F"></td> 
                        <td class="G"></td>
                        <td class="H"></td>
                    </tr> 
               </tbody> 
           </table>
         </div>
      ]]>
   </Layout>
</Template>



Thx for your support and keeping on top of it.
(Edited)