Development:MediaWiki/Tables

From InvestmentWiki
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

  1. 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]
  2. Go to edit source and add the following code {{#widget:Google Spreadsheet|key=1Ji9CK5Uf04SX4uYnD020Rnda9TMr-m9TbwRCqlHCuwA|width=600|height=400}}
  3. 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

Volkswagen: Deliveries/FY2023

References