2,756
edits
Development:MediaWiki/Tables: Difference between revisions
no edit summary
No edit summary |
No edit summary |
||
| Line 2: | Line 2: | ||
== Native Tables == | == Native Tables == | ||
Variations | Variations how native tables can be structured. [https://www.mediawiki.org/wiki/Help:Tables] | ||
Apparently it is not possible to fix the header or the first row. <ref>https://phabricator.wikimedia.org/T42763</ref> | Apparently it is not possible to fix the header or the first row. <ref>https://phabricator.wikimedia.org/T42763</ref> | ||
| Line 9: | Line 9: | ||
In order to integrate google sheet tables into the wiki | 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. | # Open the google sheet you want to share. Go to File->Share-> Publish to Web -> Select the tab you want to publish -> Click publish. <ref>https://support.google.com/docs/answer/183965?hl=en&co=GENIE.Platform%3DDesktop</ref> | ||
# Go to edit source and add the following code: | # Go to edit source and add the following code <code><nowiki>{{#widget:Google Spreadsheet|key=1Ji9CK5Uf04SX4uYnD020Rnda9TMr-m9TbwRCqlHCuwA|width=600|height=400}}</nowiki></code> | ||
# Replace the key with the key of your Google sheet. You will find it as the long letter&numbers code in the Url. | |||
< | ==== 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? <ref>https://stackoverflow.com/questions/69230026/trying-to-make-a-google-sheet-embed-auto-size-without-scrolling-on-the-webpage</ref> | |||
* 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. <ref>https://www.mediawiki.org/wiki/Extension:FixedHeaderTable</ref> <ref>https://support.google.com/sites/thread/81716891/freeze-rows-in-site-embedded-google-spreadsheet?hl=en</ref> <ref>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</ref> | |||
==== Examples of Inserted Google Sheets ==== | |||
[[Volkswagen:Deliveries/FY2023]] | |||
== References == | == References == | ||