Development:MediaWiki/Tables
Jump to navigation
Jump to search
See also: Development | Development:MediaWiki
Native Tables
Variations how native tables can be structured. [1]
Apparently it is not possible to fix the header or the first row. [1]
Testing article is here
Insert Google Sheet tables
In order to integrate google sheet tables into the wiki
- Open the google sheet you want to share. Go to File->Share-> Publish to Web -> Select the tab you want to publish -> Click publish. [2]
- Go to edit source and add the following code
{{#widget:Google Spreadsheet|key=1Ji9CK5Uf04SX4uYnD020Rnda9TMr-m9TbwRCqlHCuwA|width=600|height=400}}
- Replace the key with the key of your Google sheet. You will find it as the long letter&numbers code in the Url. Change width and height if necessary.
Advantages of Google Sheets
- More native workflows e.g. possibility to do calculations.
- Possibility to change field sizes, color fields etc. add currencies
- Slightly smaller and more readable display
Open Google Sheet Questions
- Is it possible to make google sheets responsive on mobile so that the site continues to load in the correct size? [3]
- Is it possible to fix the header or first row somehow? This is important to have a good workflow on mobile. Otherwise it is impossible to read tables. It appears that there are plugins but maybe there is a simpler solutions. [4] [5] [6]
Examples of Inserted Google Sheets
References
- ↑ https://phabricator.wikimedia.org/T42763
- ↑ https://support.google.com/docs/answer/183965?hl=en&co=GENIE.Platform%3DDesktop
- ↑ https://stackoverflow.com/questions/69230026/trying-to-make-a-google-sheet-embed-auto-size-without-scrolling-on-the-webpage
- ↑ https://www.mediawiki.org/wiki/Extension:FixedHeaderTable
- ↑ https://support.google.com/sites/thread/81716891/freeze-rows-in-site-embedded-google-spreadsheet?hl=en
- ↑ https://support.google.com/sites/thread/15211369/how-do-you-embed-a-google-sheet-but-keep-the-top-two-rows-frozen-instead-of-just-the-top-row?hl=en